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