On 10/21/2014 5:14 PM, Craig Ringer wrote:
> If you're using the Apple-bundled one, make VERY sure to back everything
> up carefully with pg_dump before upgrading. Then tell me how it goes.
I'd recommend doing..
$ pg_dumpall --globals-only -f 20141021_globals.sql
$ for db in mydb1 mydb2 ... ; do pg_dump -Fc -d $db -f
20141012_dump.$db.pgdump ; done
this will give you the maximum flexibility when you restore.
--
john r pierce 37N 122W
somewhere on the middle of the left coast