X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A29819DCB92 for ; Wed, 7 Dec 2005 23:24:05 -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 22437-07 for ; Wed, 7 Dec 2005 23:24:09 -0400 (AST) X-Greylist: delayed 00:06:31.199354 by SQLgrey- Received: from smtp103.biz.mail.mud.yahoo.com (smtp103.biz.mail.mud.yahoo.com [68.142.200.238]) by postgresql.org (Postfix) with SMTP id EF65B9DCB0A for ; Wed, 7 Dec 2005 23:24:02 -0400 (AST) Received: (qmail 30992 invoked from network); 8 Dec 2005 03:17:28 -0000 Received: from unknown (HELO noneworkstation) (tancy@gussmanntech.com@219.93.187.158 with login) by smtp103.biz.mail.mud.yahoo.com with SMTP; 8 Dec 2005 03:17:27 -0000 From: "Tan Chen Yee" To: Subject: Unable to restore compressed file. Date: Thu, 8 Dec 2005 11:17:21 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C5FBE8.F74DC260" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcX7peaoe2pbFWH2Tku0xTYeYf5+Tw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-Id: <20051208032402.EF65B9DCB0A@postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.928 required=5 tests=[HTML_MESSAGE=0.001, MSGID_FROM_MTA_ID=0.927] X-Spam-Score: 0.928 X-Spam-Level: X-Archive-Number: 200512/57 X-Sequence-Number: 19777 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C5FBE8.F74DC260 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I used pg_dump -u -F c -f E:\Temp\Test.tar.gz TestDB to backup. Then, I dropped and recreated TestDB. However, I failed to restore with this command pg_restore -u -F c -d TestDB E:\Temp\Test.tar.gz. Here is what I got : pg_restore: [archiver (db)] connection to database "TestDB" failed: FATAL: password authentication failed for user "postgres" I don't understand why the password is invalid. I am sure I used that password to create backup as well. How should I restore the gz file ? Thanks ! Tan ------=_NextPart_000_0000_01C5FBE8.F74DC260 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I used pg_dump -u -F c -f E:\Temp\Test.tar.gz TestDB = to backup. Then, I dropped and recreated = TestDB.

However, I failed to restore with this command = pg_restore -u -F c -d TestDB E:\Temp\Test.tar.gz.

 

Here is what I got :

 

pg_restore: [archiver (db)] connection to database "TestDB" failed: FATAL:  password authentication failed = for user "postgres"

 

I don’t understand why the password is invalid. = I am sure I used that password to create backup as = well.

 

How should I restore the gz file = ?

 

Thanks !

 

Tan

------=_NextPart_000_0000_01C5FBE8.F74DC260--