X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id EB5979DD725 for ; Fri, 9 Dec 2005 10:33:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01843-01 for ; Fri, 9 Dec 2005 10:33:56 -0400 (AST) X-Greylist: delayed 03:12:00.762814 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id D4C089DCD42 for ; Fri, 9 Dec 2005 10:33:49 -0400 (AST) Received: from bha.peto.hu (adsl142.229.axelero.hu [195.228.229.142]) by svr2.postgresql.org (Postfix) with ESMTP id 36D49F0B2D for ; Fri, 9 Dec 2005 11:21:50 +0000 (GMT) Received: from [192.168.1.202] (unknown [192.168.1.202]) by bha.peto.hu (Postfix) with ESMTP id 381EC1448C for ; Fri, 9 Dec 2005 12:08:34 +0100 (CET) Message-ID: <439968B5.8020308@mailpont.hu> Date: Fri, 09 Dec 2005 12:21:25 +0100 From: "durumdara@mailpont.hu" User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: pg_dump problems Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/473 X-Sequence-Number: 88036 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