Postgres Pro
Downloads
Home   >   mailing lists

BUG #2435: pg_dump/pg_restore with tar format misses indices and constraints - Mailing list pgsql-bugs

From Sidney Li
Subject BUG #2435: pg_dump/pg_restore with tar format misses indices and constraints
Date
Msg-id 200605121255.k4CCt1MM009302@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2435: pg_dump/pg_restore with tar format misses indices and constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: Thanh Thao Nguyen
Date:
Subject: backup database by pg_dump
Next
From: "Jacques Gollion"
Date:
Subject: BUG #2433: Using pg_dump in a .bat : Cannot avoid asking for user Name and Password