Re: pg_dump get error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dorothy Yung <yungkaki(at)so-net(dot)com(dot)hk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump get error
Date: 2003-04-14 20:00:44
Message-ID: 15068.1050350444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dorothy Yung <yungkaki(at)so-net(dot)com(dot)hk> writes:
> Having searched the archive and found somebody got similar problem
> (http://archives.postgresql.org/pgsql-admin/2001-12/msg00126.php) but
> my problem now is that pg_dump doesn't show on which trigger the error
> occurs.

Best bet is to run pg_dump with query logging turned on, and look in the
postmaster log to see the query that fails.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Seichter 2003-04-14 20:22:46 How log everything?
Previous Message Oleg Bartunov 2003-04-14 18:56:09 Re: Need two languages in the database: Russian and English