Thread: pg_restore stalled ???

pg_restore stalled ???

From
"Gauthier, Dave"
Date:

Hi:

 

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

 

pg_dump –C –file=thedb.pgdump thedb

 

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.  ps shows no cpu usage.  du shows no increasing disk space usage where the DB was initialized.

 

Any clues?

 

Thanks

 

Re: pg_restore stalled ???

From
Andreas Kretschmer
Date:
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°

Re: pg_restore stalled ???

From
Tom Lane
Date:
"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

Re: pg_restore stalled ???

From
"Gauthier, Dave"
Date:
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