pg_restore stalled ???

Gauthier, Dave <dave.gauthier@intel.com> schrieb:

Hi:

I did a pg_dump of a v8,2,5 db using...

pg_dump –C –file=thedb.pgdump thedb

This create a plain text dump.

I’m attempting to restore in v8.3.4 using pg_restore running under v8.3.4
using...

pg_restore –f mydb.pgdump –i –C

pg_restore expect a dump in the custom format.

Please, read the docu about pg_dump and pg_restore. To restore a plain
text dump use psql instead.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

"Gauthier, Dave" <dave.gauthier@intel.com> writes:

I'm attempting to restore in v8.3.4 using pg_restore running under
v8.3.4 using...
pg_restore -f mydb.pgdump -i -C
It doesn;t appear to be doing anything.

It's waiting for an archive to show up on stdin :-(

-f is the *output* file name for pg_restore. Also, you're lacking
any switches here specifying a database to connect to.

regards, tom lane

Ya, I aborted it and am successfully restoring the DB using psql. It's
sure taking up cycles and disk space now :-)

-dave

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, October 01, 2008 11:52 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore stalled ???

"Gauthier, Dave" <dave.gauthier@intel.com> writes:

I'm attempting to restore in v8.3.4 using pg_restore running under
v8.3.4 using...
pg_restore -f mydb.pgdump -i -C
It doesn;t appear to be doing anything.

It's waiting for an archive to show up on stdin :-(

-f is the *output* file name for pg_restore. Also, you're lacking
any switches here specifying a database to connect to.

regards, tom lane