Re: pg_restore stalled ???

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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, October 01, 2008 11:52 AM
To: Gauthier, Dave
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pg_restore stalled ???

"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)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