The following bug has been logged online:
Bug reference: 3691
Logged by: Maryz
Email address: mairambija@gmail.com
PostgreSQL version: 8.0-8.3b
Operating system: WinXP
Description: bug in pg_restore
Details:
In Postgres 8.0-8.2 and now 8.3b backup data in other schemas (not public
schema) with pg_dump. Later with pg_restore I can't restore it.
For example dump:
pg_dump.exe --format=custom -b -i --disable-triggers -h localhost -p 5432 -U
postgres -a postgres -f dmp\other.itm_blygis.out -t other.itm_blygis
Restore:
pg_restore.exe -h localhost -p 5432 -U postgres -a postgres --format=c -a -i
--disable-triggers -t other.itm_blygis -v dmp\other.itm_blygis.out
Maybe it's not a bug. Maybe I do something wrong?