| From: | "durumdara(at)mailpont(dot)hu" <durumdara(at)mailpont(dot)hu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_dump problems |
| Date: | 2005-12-09 11:21:25 |
| Message-ID: | 439968B5.8020308@mailpont.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
I do many things, but I cannot create dump from this database.
I know the name of database (inventory), and from zope I see this
connection parameters: "dbname=inventory users=zope". And from zope that
is working good.
When I try to make pg_dump:
pg_dump -s -v -U zope -W inventory >/invdump
it prompt for pwd, and I get auth. error.
When I try to create dump with def. user:
pg_dump -s -v -W inventory >/invdump
It is show error that "root user doesn't exists".
So: how to I dump this database ? Or how to I transfer it to a Windows
machine to make dump on it ?
Is anybody have a solution ?
Thanks for advance: dd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2005-12-09 13:01:54 | GnuPG / PGP signed MD5 and SHA1 checksums for PostgreSQL 8.1.0 |
| Previous Message | Rafael Martinez Guerrero | 2005-12-09 09:00:45 | Re: after vacuum, db is still "growing" :( |