Issue With Restoring a Dump - Mailing list pgsql-admin

From Jeanna Geier
Subject Issue With Restoring a Dump
Date
Msg-id 007c01c6c873$2d793430$6700a8c0@geier
Whole thread Raw
Responses Re: Issue With Restoring a Dump
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4 - data recovery
Next
From: "Magnus Hagander"
Date:
Subject: Re: Issue With Restoring a Dump