Sorry.
Mistakenly I said its problem with pg_dump.
Its the problem with pg_restore.

Wait for your help.

Thank you.
Sreeman
On 9/12/06, Sree Narayana wrote:

Hi

Good morning.

I have taken a backup of the databse from the windows commandline with the
following command:

C:\[pg_dump loaction]\pg_dump.exe -h localhost -p 5432 -U postgres -F c -v
-f C:\db_backup.backup myDB;

This worked fine.

However I am facing the problem while restoring. I am trying with the
following command from the windows command line:

C:\[pg_restore location]\pg_restore.exe -i -h localhost -p 5432 -U
postgres -d myDB -v C:\db_backup.backup

If I give "-c", its working fine. However I don't want to drop the
database while restoring.
So is it possible to restore database without dropping database?


without "-c" I am getting the following error messages, and no data is
restored in database:

pg_restore: creating SCHEMA public
pg_restore: creating COMMENT SCHEMA public
pg_restore: creating PROCEDURAL LANGUAGE plpgsql
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 448; 2612 16386
PROCEDURAL LANGUAGE
plpgsql
pg_restore: [archiver (db)] could not execute query: ERROR: language
"plpgsql" alrea
dy exists
Command was: CREATE PROCEDURAL LANGUAGE plpgsql;
pg_restore: creating TABLE agentdefvalobject
pg_restore: [archiver (db)] Error from TOC entry 1476; 1259 50028 TABLE
agentdefvalob
ject postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"agentdefvalobj
ect" already exists
Command was: CREATE TABLE agentdefvalobject (
name character varying(100) NOT NULL,
value character varying(100)
);
pg_restore: creating TABLE alert
pg_restore: [archiver (db)] Error from TOC entry 1410; 1259 49738 TABLE
alert postgre
s
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"alert" already
exists
Command was: CREATE TABLE alert (
id integer,
groupname character varying(100),
category character varying(100),
severity...
pg_restore: creating TABLE alertlogger
pg_restore: [archiver (db)] Error from TOC entry 1418; 1259 49792 TABLE
alertlogger p
ostgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"alertlogger" a
lready exists
Command was: CREATE TABLE alertlogger (
valuestring character varying(250)
);
---------------------------------------------------------
---------------------------------------------------------
---------------------------------------------------------

thanks
Sreeman

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedSep 12, '06 at 2:33p
activeSep 12, '06 at 2:33p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Sree Narayana: 1 post

People

Translate

site design / logo © 2022 Grokbase