Skip site navigation (1) Skip section navigation (2)

Re: Why dos select work when pg_dump fails?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darren Reed <darrenr+postgres(at)fastmail(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Why dos select work when pg_dump fails?
Date: 2007-11-29 15:20:56
Message-ID: 13498.1196349656@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Darren Reed <darrenr+postgres(at)fastmail(dot)net> writes:
> For whatever reason, I'm back dealing with corrupted tables but
> curiously while this fails:

> pg_dump -U postgres -a -t table -f /data/table.dump

> this works:

> psql -U postgres -A -o /data/table.dump -c "SELECT * FROM table;"

pg_dump is evidently failing while trying to get the definitions
of that table's indexes.  Does "\d table" work?

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2007-11-29 17:18:08
Subject: Re: Enable Syslog on Postgres
Previous:From: Jeff LarsenDate: 2007-11-29 14:46:40
Subject: Re: Enable Syslog on Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group