On Mon, Dec 12, 2011 at 12:23 PM, Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote: > - you should use 9.1.2, not 9.1.1 ;-) I don't think it's available yet in Debian repositories. I can only use whatever packages they've compiled in their repositories. > - use the pg_dumpall from the new version to make the dump, for instance > pg_dumpall -h <old_host> ... | psql (something like this, on the new > host) So it would look like this from my new server? pg_dumpall -h old_db > mydata.sql > Du you have BYTEA-Columns? The default output-format changed. Some other > details changed too, read the release notes! I don't think I have any BYTEA columns so I think I'm OK. I'll read the release notes... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
