BUG #2435: pg_dump/pg_restore with tar format misses indices and constraints
The following bug has been logged online:
Bug reference: 2435
Logged by: Sidney Li
Email address: li@epp.agfa.com
PostgreSQL version: 8.1.3
Operating system: Linux
Description: pg_dump/pg_restore with tar format misses indices and
constraints
Details:
when backing up with "pg_dump -o -Ft database_name" then
later restoring with pg_restore, the indices and constraints/triggers are
not restored.
"Sidney Li" <li@epp.agfa.com> writes:
when backing up with "pg_dump -o -Ft database_name" then
later restoring with pg_restore, the indices and constraints/triggers are
not restored.
Seems pretty unlikely. More details, or better a test case, would help.
I think you've probably misdiagnosed your problem, and with no details
there's not much we can do to help. See
http://www.postgresql.org/docs/8.1/static/bug-reporting.html
regards, tom lane