Re: pg_restore stalled ??? - Mailing list pgsql-general

From Gauthier, Dave
Subject Re: pg_restore stalled ???
Date
Msg-id 0836165E8EE50F40A3DD8F0D871372670127B9FC@azsmsx421.amr.corp.intel.com
Whole thread Raw
In response to Re: pg_restore stalled ???  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Transactions within a function body
Next
From: Andreas Kretschmer
Date:
Subject: Re: Transactions within a function body