Re: Pg_dumpall problem

From: "Matthew Lunnon" <mlunnon(at)rwa-net(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>, "Patrick Hatcher" <PHatcher(at)macys(dot)com>
Subject: Re: Pg_dumpall problem
Date: 2003-11-20 09:38:51
Message-ID: 002401c3af4a$1b53bfe0$8e8bbd3e@rwanet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


----- Original Message -----
From: Patrick Hatcher
To: pgsql-general(at)postgresql(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2003-11-20 09:53:02 Re: SELECT Question
Previous Message Holger Klawitter 2003-11-20 09:24:30 Re: SELECT Question