> "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
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
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