Thread: Upgrade procedure

Last time I had to upgrade, pg_dumpall into pg_restore didn't work
and I had to use something else. A different dump command or a
special option... Can't remember exactly what.

It's upgrade time again. Spent hours searching man pages,
changelogs and release notes and that information still eludes me.
Help ?

Happy new year, all.

--
André Majorel <URL:http://www.teaser.fr/~amajorel/>

Andre Majorel <aym-2lqsgp@teaser.fr> writes:
> Last time I had to upgrade, pg_dumpall into pg_restore didn't work
> and I had to use something else. A different dump command or a
> special option... Can't remember exactly what.

pg_dumpall produces a plain SQL command file, which you feed into psql.

            regards, tom lane