Skip site navigation (1) Skip section navigation (2)

BUG #3691: bug in pg_restore

From: "Maryz" <mairambija(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3691: bug in pg_restore
Date: 2007-10-22 14:52:11
Message-ID: 200710221452.l9MEqB6c038173@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3691
Logged by:          Maryz
Email address:      mairambija(at)gmail(dot)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?

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-10-22 15:04:26
Subject: Re: BUG #3691: bug in pg_restore
Previous:From: Tom LaneDate: 2007-10-22 14:40:28
Subject: Re: BUG #3682: Incomplete database restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group