On Thu, 2008-07-24 at 10:20 -0700, Marc Fromm wrote:
> I backed up all my databases using:
> pg_dumpall -O -c -U postgres > /tmp/pgalldb2
> -O to remove owners on all objects
> -c to drop databases before recreating them during the restore to
> prevent duplicate records
>
> I restored all the data
I backed up all my databases using:
pg_dumpall -O -c -U postgres > /tmp/pgalldb2
-O to remove owners on all objects
-c to drop databases before recreating them during the restore to prevent
duplicate records
I restored all the databases with this command
psql -U postgres -f /tmp/pgalldb2 postgres
