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/