Arindam <[EMAIL PROTECTED]> writes:
> In all the above cases, this is the error I get:
> pg_restore: [archiver (db)] could not execute query: ERROR: cannot
> drop schema public because other objects depend on it
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> Command was: DRO
I am writing a script to carry out updates from Postgres 7.2.1 to
8.1.5. The strategy is as follows:
1. Take the dump of the 7.2.1 database using pg_dump (of 8.1.5)
2. Stop the database
3. Uninstall the database
4. Install the database and start the database
5. Restore the dump taken in step 1 us
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
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
Normally you restore on
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[
