Unable to user pg_restore

From: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Unable to user pg_restore
Date: 2003-10-20 13:01:57
Message-ID: 00fb01c3970a$5f95b620$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear Friends,

I have created a compressed backup for the database - sampledb using the following
$ pg_dump -h 192.128.2.51 -v -u -f /home/db_repository/sampledb20031020.sql.tar.gz wats -F c

while I try to restore this with the pg_restore function as follows
$ pg_restore -d sampledbtest -f /home/db_repositorysampledb.sql.tar.gz -F c -v -c -O -h 192.128.2.51 -p 5432 -u
User name: postgres

It never prompt for password, so I just typed the password , and get the error as follows,
postgres
pg_restore: [archiver] did not find magic string in file header
$

Anyone could advise me on this pls.

Kumar

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message email lists 2003-10-20 13:04:13 Re: date_trunc for 5 minutes intervals
Previous Message Dmitri Fuerle 2003-10-20 13:00:58 Question regarding triggers