From: durumdara@mailpont.hu <durumdara@mailpont.hu>
To: pgsql-general@postgresql.org
Subject: pg_dump problems
Date: Fri, 09 Dec 2005 12:21:25 +0100
Message-ID: <439968B5.8020308@mailpont.hu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: durumdara@mailpont.hu
Subject: Re: pg_dump problems
In-Reply-To: <439968B5.8020308@mailpont.hu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox