X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9D34B9FBC6B for ; Fri, 25 Aug 2006 15:46:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 37746-08 for ; Fri, 25 Aug 2006 18:46:31 +0000 (UTC) X-Greylist: delayed 00:25:43.69097 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 30AA19FBC67 for ; Fri, 25 Aug 2006 15:46:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from socrates.thinkhost.com (mailpipe.socrates.thinkhost.com [64.40.100.194]) by svr4.postgresql.org (Postfix) with ESMTP id 4977B5AF893 for ; Fri, 25 Aug 2006 18:20:46 +0000 (GMT) Received: from geier (adsl-64-91-71-139-rb.lax.customer.centurytel.net [64.91.71.139]) by socrates.thinkhost.com (8.13.6/8.13.5) with SMTP id k7PIKGkq029978 for ; Fri, 25 Aug 2006 14:20:16 -0400 (EDT) (envelope-from jgeier@apt-cafm.com) Message-ID: <007c01c6c873$2d793430$6700a8c0@geier> From: "Jeanna Geier" To: Subject: Issue With Restoring a Dump Date: Fri, 25 Aug 2006 13:20:42 -0500 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Antivirus: avast! (VPS 0634-2, 08/24/2006), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/295 X-Sequence-Number: 22838 Hi, I'm having a problem with restoring a dump that I executed and would appreciate any assistance anyone could give me. I'm a newbie here, so please bear with me. I'm using Postgre 8.0 Version 1.2.1; I executed the dump using the following command: pg_dump -h localhost -U postgres -o dbName > C:\Database_Backups\apt_dump_082506.dmp I got prompted for the password and entered it and it created a file named apt_dump_082506.dmp in my C:\Database_Backups directory. I then created a new database to load the dump into from the template0: createdb -U postgres -T template0 apt_dump_test I got prompted for the password and entered it and it created the database in Postgres. Finally, when I try to restore the dump into this new database, I am not getting prompted for the Password, it is simply throwing an error: psql -U postgres apt_dump_test < C:\Database_Backups\apt_dump_082506.dmp Password: psql: FATAL: password authentication failed for user "postgres" It is not giving me an opportunity to enter the password at all.... Thanks in advance for any help you can provide! Jeanna