pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Issue With Restoring a Dump
5+ messages / 3 participants
[nested] [flat]

* Issue With Restoring a Dump
@ 2006-08-25 18:20 Jeanna Geier <jgeier@apt-cafm.com>
  2006-08-25 18:55 ` Re: Issue With Restoring a Dump Magnus Hagander <mha@sollentuna.net>
  0 siblings, 1 reply; 5+ messages in thread

From: Jeanna Geier @ 2006-08-25 18:20 UTC (permalink / raw)
  To: 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 




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Issue With Restoring a Dump
  2006-08-25 18:20 Issue With Restoring a Dump Jeanna Geier <jgeier@apt-cafm.com>
@ 2006-08-25 18:55 ` Magnus Hagander <mha@sollentuna.net>
  2006-08-25 20:58   ` Re: Issue With Restoring a Dump Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Magnus Hagander @ 2006-08-25 18:55 UTC (permalink / raw)
  To: Jeanna Geier <jgeier@apt-cafm.com>; pgsql-admin

> 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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Issue With Restoring a Dump
  2006-08-25 18:20 Issue With Restoring a Dump Jeanna Geier <jgeier@apt-cafm.com>
  2006-08-25 18:55 ` Re: Issue With Restoring a Dump Magnus Hagander <mha@sollentuna.net>
@ 2006-08-25 20:58   ` Scott Marlowe <smarlowe@g2switchworks.com>
  2006-08-25 21:04     ` Re: Issue With Restoring a Dump Jeanna Geier <jgeier@apt-cafm.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Scott Marlowe @ 2006-08-25 20:58 UTC (permalink / raw)
  To: Magnus Hagander <mha@sollentuna.net>; +Cc: Jeanna Geier <jgeier@apt-cafm.com>; pgsql-admin

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...



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Issue With Restoring a Dump
  2006-08-25 18:20 Issue With Restoring a Dump Jeanna Geier <jgeier@apt-cafm.com>
  2006-08-25 18:55 ` Re: Issue With Restoring a Dump Magnus Hagander <mha@sollentuna.net>
  2006-08-25 20:58   ` Re: Issue With Restoring a Dump Scott Marlowe <smarlowe@g2switchworks.com>
@ 2006-08-25 21:04     ` Jeanna Geier <jgeier@apt-cafm.com>
  2006-08-25 21:09       ` Re: Issue With Restoring a Dump Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Jeanna Geier @ 2006-08-25 21:04 UTC (permalink / raw)
  To: Scott Marlowe <smarlowe@g2switchworks.com>; Magnus Hagander <mha@sollentuna.net>; +Cc: pgsql-admin

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...
> 




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Issue With Restoring a Dump
  2006-08-25 18:20 Issue With Restoring a Dump Jeanna Geier <jgeier@apt-cafm.com>
  2006-08-25 18:55 ` Re: Issue With Restoring a Dump Magnus Hagander <mha@sollentuna.net>
  2006-08-25 20:58   ` Re: Issue With Restoring a Dump Scott Marlowe <smarlowe@g2switchworks.com>
  2006-08-25 21:04     ` Re: Issue With Restoring a Dump Jeanna Geier <jgeier@apt-cafm.com>
@ 2006-08-25 21:09       ` Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Scott Marlowe @ 2006-08-25 21:09 UTC (permalink / raw)
  To: Jeanna Geier <jgeier@apt-cafm.com>; +Cc: Magnus Hagander <mha@sollentuna.net>; pgsql-admin

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...



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-08-25 21:09 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-25 18:20 Issue With Restoring a Dump Jeanna Geier <jgeier@apt-cafm.com>
2006-08-25 18:55 ` Magnus Hagander <mha@sollentuna.net>
2006-08-25 20:58   ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-08-25 21:04     ` Jeanna Geier <jgeier@apt-cafm.com>
2006-08-25 21:09       ` Scott Marlowe <smarlowe@g2switchworks.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox