Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 29 Nov 2007 10:20:56 -0500
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
- References:
- Why dos select work when pg_dump fails?
- From: Darren Reed
- Why dos select work when pg_dump fails?
- Prev by Date: Re: Enable Syslog on Postgres
- Next by Date: Re: Enable Syslog on Postgres
- Previous by thread: Why dos select work when pg_dump fails?
- Next by thread: clear statistics in pg_stat
- Indexes: