Re: pg_dump problems - Mailing list pgsql-general

am  09.12.2005, um 12:21:25 +0100 mailte durumdara@mailpont.hu folgendes:
> Hi !
>
> We have an old web service with a pgsql database (in Suse Linux). This
> database created by another programmer who no accessible now.
>
> We want to dump this database to get data from it. But I have no passwords.

Change the trust-level in pg_hba.conf to:
local   all         all                               trust

Reload the config. Now you can login (local) without password.

For more Info:
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html



HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===