John R Pierce <pierce@xxxxxxxxxxxx> writes: > On 12/27/10 11:00 AM, Guillaume Lelarge wrote: >> psql should work the same, apart from new metacommands. I don't think >> you'll experience issues with pg_ctl. I would not recommend you to user >> pg_dump and pg_restore. They are pretty sensitive to the PostgreSQL release. > pg_dump is designed specifically to be able to dump from all supported > older versions so you can convert the data forwards. Right, but the key word in that sentence is "forwards". Dumping from an 8.3 database with 9.0 pg_dump will likely produce SQL that doesn't reload into an 8.3 server, only into 9.0. > pg_restore, yeah, I would not use pg_restore 9 to restore a dump onto a > 8.3.x database. It's mostly pg_dump not pg_restore that determines this. pg_restore just pulls out the SQL that was written by pg_dump. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
