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: | Raw Message | Whole Thread | 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" :( |