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