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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

"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/s...reporting.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster