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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general