Обсуждение: Issue With Restoring a Dump

Поиск
Список
Период
Сортировка

Issue With Restoring a Dump

От
"Jeanna Geier"
Дата:
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


Re: Issue With Restoring a Dump

От
"Magnus Hagander"
Дата:
> 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

Re: Issue With Restoring a Dump

От
Scott Marlowe
Дата:
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...

Re: Issue With Restoring a Dump

От
"Jeanna Geier"
Дата:
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...
>


Re: Issue With Restoring a Dump

От
Scott Marlowe
Дата:
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...