On Mon, Dec 12, 2011 at 12:23 PM, Andreas Kretschmer
<akretschmer@spamfence.net> 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
releasenotes...