pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIssue 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