Thread: pg_dumpall

Well, when I turned on security and switched from trust to passwrod (using
pg_shadow) now pg_dumpall does not work.  It simply complains that my
password is wrong, and ignores the -u or -U to try to change me to be
postgres.  If I su to postgres, it complains that I did not supply a
password.

______________________________________________________________________________

                          Your mouse has moved.
       You must restart Windows for your changes to take effect.

#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);

grant writes:

> Well, when I turned on security and switched from trust to passwrod (using
> pg_shadow) now pg_dumpall does not work.  It simply complains that my
> password is wrong, and ignores the -u or -U to try to change me to be
> postgres.  If I su to postgres, it complains that I did not supply a
> password.

Yes, unfortunately that doesn't work.  The upcoming release should do
better.  For now you need to use pg_dump on each database and save the
users with pg_dumpall -g connected to an "insecure" database.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter