"Sidney Li" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
