Re: trying to back up a database

On Wed, Jan 31, 2001 at 11:27:18PM +0000, Oliver Elphick wrote:

Adam Haberlach wrote:

I'm trying to back up a database, including the user records. If
I use pg_dump, I can get the table, but I cannot seem to be the user
information.

pg_dump -d database >dump

should copy the database schema and all data records into dump.

If I use pg_dumpall, it seems to have trouble connecting to various
databases (in fact, it attempts to connect even if I merely want the
help page).

I don't know what you mean by the last bit. Are you saying that `man
pg_dumpall'
runs pg_dumpall?

Sorry--I mean that when I type "pg_dumpall -h, it connects", but I guess
that is because it is a simple script.

pg_dumpall must be run by postgres, it may well have problems if you
are running it as an unprivileged user.

Aha. That may be my problem, then.

[adam@pinko docs]$ pg_dumpall valhalla -u -s > dbschema.sql
Password: psql: Password authentication failed for user 'adam'
Password: psql: Password authentication failed for user 'adam'
Password: psql: Password authentication failed for user 'adam'
Password: Password: psql: Password authentication failed for user 'adam'
Connection to database 'valhalla' failed.
fe_sendauth: no password supplied

--
Adam Haberlach |A cat spends her life conflicted between a
adam@newsnipple.com |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500 |profound desire to avoid getting wet.

Adam Haberlach writes:

Sorry--I mean that when I type "pg_dumpall -h, it connects", but I guess
that is because it is a simple script.

Nobody ever said that '-h' prints a help screen.

pg_dumpall must be run by postgres, it may well have problems if you
are running it as an unprivileged user.

Nope

[adam@pinko docs]$ pg_dumpall valhalla -u -s > dbschema.sql
Password: psql: Password authentication failed for user 'adam'
Password: psql: Password authentication failed for user 'adam'
Password: psql: Password authentication failed for user 'adam'
Password: Password: psql: Password authentication failed for user 'adam'
Connection to database 'valhalla' failed.
fe_sendauth: no password supplied

Password authentication doesn't work with pg_dumpall. Use something else.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

Peter Eisentraut wrote:

pg_dumpall must be run by postgres, it may well have problems if you
are running it as an unprivileged user.

Nope

Seeing that the unprivileged user may not have SELECT permission on
some of the tables, he ought to have problems!

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"O come, let us worship and bow down; let us kneel
before the LORD our maker." Psalms 95:6