Thread: pg_restore problems

pg_restore problems

From
Bobby Gontarski
Date:
I do:
pg_dump -Ft mydb > mydb.tar
pg_restore -d newdb mydb.tar
and I get tuns of errors. Like:
pg_restore: [archiv߰ (db)] could not execute query: ERROR: relation "pg_ts_cfg map" already exists
Command was: CREATE TABLE pg_ts_cfgmap (
ts_name text NOT NULL,
tok_alias text NOT NULL,
dict_name text[]
what is the problem, why can't I restore the db... (postgresql 8.1)
bobby

Re: pg_restore problems

From
Martijn van Oosterhout
Date:
On Mon, Aug 28, 2006 at 02:38:07PM +0200, Bobby Gontarski wrote:
> I do:
> pg_dump -Ft mydb > mydb.tar
> pg_restore -d newdb mydb.tar
> and I get tuns of errors. Like:
> pg_restore: [archiv?? (db)] could not execute query: ERROR: relation "pg_ts_cfg map" already exists

<Snip>

Normally you restore onto a system that doesn't have the database
already. Obviously if you try to do that you'll get messages saying the
tables already exist.

You can ask for pg_restore to drop the tables before restoring them,
but for obvious reasons this is not the default.

Have anice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

Re: pg_restore problems

From
"chris preston"
Date:
I have setup a new server to hold my postgres 8.1 database.

when i do a pg_dump to a file mydb.tar where to i copy it to on the new
server to restore it
also will all the schemas be copied also

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Martijn van
Oosterhout
Sent: August 28, 2006 7:50 AM
To: Bobby Gontarski
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_restore problems


On Mon, Aug 28, 2006 at 02:38:07PM +0200, Bobby Gontarski wrote:
> I do:
> pg_dump -Ft mydb > mydb.tar
> pg_restore -d newdb mydb.tar
> and I get tuns of errors. Like:
> pg_restore: [archiv?? (db)] could not execute query: ERROR: relation
"pg_ts_cfg map" already exists

<Snip>

Normally you restore onto a system that doesn't have the database
already. Obviously if you try to do that you'll get messages saying the
tables already exist.

You can ask for pg_restore to drop the tables before restoring them,
but for obvious reasons this is not the default.

Have anice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
litigate.