473,232 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,232 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 1874
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Edwin Quijada | last post by:
Hi! I am trying to do a dump all and when I do this I get this error pg_dumpall: query failed: ERROR: Unable to convert abstime 'invalid' to timestamp pg_dumpall: query was: SELECT usename,...
0
by: Hunter Hillegas | last post by:
I am trying to restore a file that I created using pg_dumpall. I have searched the archives and the documentation. I know I am supposed to use pg_restore but there is no example for restoring...
0
by: Hunter Hillegas | last post by:
I see that this is in fact documenated in the man page for pg_dumpall, when I was looking at psql and pg_restore. Thanks, Hunter ---------------------------(end of...
1
by: Patrick Hatcher | last post by:
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....
3
by: Denis Gasparin | last post by:
I created a user with no superuser privileges: CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER; Then i created an authorization schema: CREATE SCHEMA AUTHORIZATION aaa; All worked...
3
by: Henrik Farre | last post by:
I just been choosen as sys adm on a small network. We have a old Sun Ultra 1 running postgresql 7.1.3. I would like to migrate the database to a new machine and a newer version of postgresql. But...
1
by: Bob Powell | last post by:
** High Priority ** Hello everyone, I have a restore file created by pg_dumpall. The restore file has two users associated with ownership of tables. The postgres user and a user called...
5
by: NTPT | last post by:
Regardi I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 . Regression tests work well All passed, but Some binaries report a relocation error: :pg_dumpall undefined symbol...
1
by: Ben Trewern | last post by:
All, There seems to be a bug in pg_dumpall: For one of my dbs I've done: ALTER DATABASE dbname SET search_path = mw, public; If I do a pg_dumpall I get a line like:
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.