Re: trying to back up a database

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/