Thread: Issue With Restoring a Dump
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
> I'm using Postgre 8.0 Version 1.2.1; I executed the dump > using the following > command: There is no "version 1.2.1" of PostgreSQL 8.0. There 8.0, 8.0.1 etc up to 8.0.8. And this looks a lot like a bug that was fixed in 8.0.8, so you should try an upgrade. //Magnus
On Fri, 2006-08-25 at 13:55, Magnus Hagander wrote: > > I'm using Postgre 8.0 Version 1.2.1; I executed the dump > > using the following > > command: > > There is no "version 1.2.1" of PostgreSQL 8.0. There 8.0, 8.0.1 etc up > to 8.0.8. > > And this looks a lot like a bug that was fixed in 8.0.8, so you should > try an upgrade. This looks like the sub numbering system that enterprise db uses, but that would be 8.1.2.1, not 8.0.1.2.1...
Sorry for the mix-up.... My version of Postgres is just 8.0. The pgadmin is 1.2.1, that's where I got mixed up... So, it sounds like an upgrade might fix this; I'll give that a try. Thanks for your help! ----- Original Message ----- From: "Scott Marlowe" <smarlowe@g2switchworks.com> To: "Magnus Hagander" <mha@sollentuna.net> Cc: "Jeanna Geier" <jgeier@apt-cafm.com>; <pgsql-admin@postgresql.org> Sent: Friday, August 25, 2006 3:58 PM Subject: Re: [ADMIN] Issue With Restoring a Dump > On Fri, 2006-08-25 at 13:55, Magnus Hagander wrote: >> > I'm using Postgre 8.0 Version 1.2.1; I executed the dump >> > using the following >> > command: >> >> There is no "version 1.2.1" of PostgreSQL 8.0. There 8.0, 8.0.1 etc up >> to 8.0.8. >> >> And this looks a lot like a bug that was fixed in 8.0.8, so you should >> try an upgrade. > > This looks like the sub numbering system that enterprise db uses, but > that would be 8.1.2.1, not 8.0.1.2.1... >
On Fri, 2006-08-25 at 16:04, Jeanna Geier wrote: > Sorry for the mix-up.... > > My version of Postgres is just 8.0. The pgadmin is 1.2.1, that's where I > got mixed up... > > So, it sounds like an upgrade might fix this; I'll give that a try. Just FYI, PostgreSQL has had the best batting average on updates of any software package I've ever used. I've never had an update that caused me any real problems, and I've been using it and updating since v6.5.2 or so...