| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Adam Haberlach <adam(at)newsnipple(dot)com> |
| Cc: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: trying to back up a database |
| Date: | 2001-02-03 16:41:44 |
| Message-ID: | Pine.LNX.4.30.0102021625310.923-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)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(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2001-02-03 16:44:39 | Re: trying to back up a database |
| Previous Message | Florian Steffen | 2001-02-03 15:21:41 | Timestamp accuracy |