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      [EMAIL PROTECTED]       http://yi.org/peter-e/

Reply via email to