Re: How to Output PSQL Errors to a Log File?

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to Output PSQL Errors to a Log File?
Date: 2010-02-23 07:32:03
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC01EBDEF575@XCH-SW-06V.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No. I dumped the 7.1 with the 7.1 version of pg_dump.
Is it better to dump with the 8.3 version of pg_dump? I thought I read it some where in the mailing lists. I don't know how I would be able to dump with the 8.3 version of pg_dump. The database and Postgres 7.1 is loaded on the current production box and Postgres 8.3.8 is loaded on a dev server that I plan to migrate the database to.

Please advise.
Mary

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Joshua D. Drake
Sent: Monday, February 22, 2010 11:25 PM
To: Wang, Mary Y
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] How to Output PSQL Errors to a Log File?

On Mon, 22 Feb 2010 23:19:34 -0800, "Wang, Mary Y"
<mary(dot)y(dot)wang(at)boeing(dot)com>
wrote:
> Hi,
>
> I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in
the
> process of restoring the databases in Postgres 8.3.8. There were lots
> errors showed on the screen when I ran this command 'psql -e template1
-f
> 21.bak' and it actually displayed the line numbers where the errors
> occurred. Because there were so many errors, and I wanted the errors
> to
be
> logged to a log file so I ran this command 'psql -e template1 -f
> 21.bak
>
> late22error.txt', but late22error.txt didn't log the errors, it just
logged
> the transactions. What option should I use to tell psql to log all
errors
> to a log file?
>
> I'm running on RHEL 3.9.

Wow that takes us back aways. Did you dump the 7.1 with the 8.3 version of pg_dump? That should help.

>
> Thanks
> Mary

--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-02-23 07:35:48 Re: Table Column Retrieval
Previous Message Scott Marlowe 2010-02-23 07:31:29 Re: how do I do dump and restore without bugging with constraint?