471,354 Members | 2,237 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Pg_dumpall problem

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?
Also, what does one do when the dump file over 5 gigs? How can I possibly
correct whatever error is ocurring?

TIA

Patrick Hatcher

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
3 1783
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 pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

----- Original Message -----
From: Patrick Hatcher
To: pg***********@postgresql.org
Sent: Thursday, November 20, 2003 12:34 AM
Subject: [GENERAL] Pg_dumpall problem
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?
Also, what does one do when the dump file over 5 gigs? How can I possibly
correct whatever error is ocurring?
Depending what the error is sed is a wonderful tool for editing large files.

Matthew
Nov 12 '05 #3

----- Original Message -----
From: Patrick Hatcher
To: pg***********@postgresql.org
Sent: Thursday, November 20, 2003 12:34 AM
Subject: [GENERAL] Pg_dumpall problem
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?
Also, what does one do when the dump file over 5 gigs? How can I possibly
correct whatever error is ocurring?
Depending what the error is sed is a wonderful tool for editing large files.

Matthew
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Edwin Quijada | last post: by
reply views Thread by Hunter Hillegas | last post: by
reply views Thread by Hunter Hillegas | last post: by
1 post views Thread by Patrick Hatcher | last post: by
3 posts views Thread by Denis Gasparin | last post: by
3 posts views Thread by Henrik Farre | last post: by
1 post views Thread by Bob Powell | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.