Re: [ADMIN] How to restore from pg_dumpall output

2003-02-14 Thread Laura Conrad
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: Tom> Laura Conrad <[EMAIL PROTECTED]> writes: >> pg_dumpall -p 8050 >/tmp/db.sql >> I then tried to restore (again as the postgres user), as documented in >> the pg_dumpall man page: >> psql -f /tmp/db.sql template1 >> It

Re: [ADMIN] How to restore from pg_dumpall output

2003-02-13 Thread Tom Lane
Laura Conrad <[EMAIL PROTECTED]> writes: > pg_dumpall -p 8050 >/tmp/db.sql > I then tried to restore (again as the postgres user), as documented in > the pg_dumpall man page: > psql -f /tmp/db.sql template1 > It does a few things, and then says: > psql:/tmp/db.sql:16: \conne

[ADMIN] How to restore from pg_dumpall output

2003-02-13 Thread Laura Conrad
I have a database that was built under a Mandrake 7.2 postgres installation. I am now running Debian (woody) on that machine, with postgresql 7.2.1. I still have the data directory from the old installation, so I started a postmaster on a non-standard port, with a -D pointing to that directory