pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Unable to restore compressed file.
2+ messages / 2 participants
[nested] [flat]

* Unable to restore compressed file.
@ 2005-12-08 03:17  Tan Chen Yee <tancy@gussmanntech.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Tan Chen Yee @ 2005-12-08 03:17 UTC (permalink / raw)
  To: pgsql-admin

I used pg_dump -u -F c -f E:\Temp\Test.tar.gz TestDB to backup. Then, I
dropped and recreated TestDB.

However, I failed to restore with this command pg_restore -u -F c -d TestDB
E:\Temp\Test.tar.gz.

 

Here is what I got :

 

pg_restore: [archiver (db)] connection to database "TestDB" failed: FATAL:
password authentication failed for user "postgres"

 

I don't understand why the password is invalid. I am sure I used that
password to create backup as well.

 

How should I restore the gz file ?

 

Thanks !

 

Tan

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

* Re: Unable to restore compressed file.
@ 2005-12-08 09:23  Guido Barosio <gbarosio@gmail.com>
  parent: Tan Chen Yee <tancy@gussmanntech.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Guido Barosio @ 2005-12-08 09:23 UTC (permalink / raw)
  To: Tan Chen Yee <tancy@gussmanntech.com>; +Cc: pgsql-admin

Hi,

    I wasn't sure, but checking the documentation I've found that both
pg_dump and pg_restore don't allow the "-u" switch, but yes "-U <username"
case.

Check (for pgsql 8):
    http://www.postgresql.org/docs/8.0/interactive/app-pgdump.html
    http://www.postgresql.org/docs/8.0/interactive/app-pgrestore.html

Best regards,
Guido

On 12/8/05, Tan Chen Yee <tancy@gussmanntech.com> wrote:
>
>  I used pg_dump -u -F c -f E:\Temp\Test.tar.gz TestDB to backup. Then, I
> dropped and recreated TestDB.
>
> However, I failed to restore with this command pg_restore -u -F c -d
> TestDB E:\Temp\Test.tar.gz.
>
>
>
> Here is what I got :
>
>
>
> pg_restore: [archiver (db)] connection to database "TestDB" failed:
> FATAL:  password authentication failed for user "postgres"
>
>
>
> I don't understand why the password is invalid. I am sure I used that
> password to create backup as well.
>
>
>
> How should I restore the gz file ?
>
>
>
> Thanks !
>
>
>
> Tan
>



--
"Adopting the position that you are smarter than an automaticoptimization
algorithm is generally a good way to achieve lessperformance, not more" -
Tom Lane.

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


end of thread, other threads:[~2005-12-08 09:23 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-08 03:17 Unable to restore compressed file. Tan Chen Yee <tancy@gussmanntech.com>
2005-12-08 09:23 ` Guido Barosio <gbarosio@gmail.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