From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Patrick Hatcher <PHatcher(at)macys(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Pg_dumpall problem |
Date: | 2003-11-20 00:59:27 |
Message-ID: | Pine.LNX.4.44.0311200157370.21224-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Patrick Hatcher writes:
> Did a pg_dumpall from my production database (7.3.2) and I tried to restore
> to my Dev database (7.4). I receive a data exception error during the
> import and was stupid enough not to write it down. Is there a log some
> place I can look to see what the error was?
Depends on how you started the postmaster. Maybe it's in syslog, maybe
it's in the log file you specified, or maybe it's in /dev/null. Also, you
could just try again and write down the error this time.
> Also, what does one do when the dump file over 5 gigs?
There should be no problem with that. Except of course that it is large
and slow to reload, but that you have to deal with.
> How can I possibly correct whatever error is ocurring?
Find out what the error is first. :-)
--
Peter Eisentraut peter_e(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-11-20 01:19:26 | Re: Two rules on a view do not like each other :-( |
Previous Message | Dmitry Tkach | 2003-11-20 00:49:07 | Two rules on a view do not like each other :-( |