Re: problem with pg_restore?

Jim Michaels wrote:
> I am having problems with pg_restore.  pg_restore --file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost
--port=5432--username=postgres 
>
> this just hangs.
> I am restoring from 8.3.7 to 8.4 - what did I do wrong?

Well, I don't see a database name, was that just an accident when you
cut + pasted the line?

If so, do you see any activity at all? If you turn connection logging on
at the server, does it see any connection attempts?

> could somebody rewrite pg_dumpall and pg_dump so that it makes editable dumps?
> most programmer's text editors can't handle more than 2000 characters per line.
> and I want to be able to edit my dumps.

Might want to get a better editor. Just tried vi with 1000 character
lines and it's perfectly happy. Can't imagine a proper editor
complaining. Having said that, once your file gets into the gigabytes
you'll want more specialised tools (either an on-disk editor or sed/perl).

--
   Richard Huxton
   Archonet Ltd