Problme in my pg_dump command

From: "Sree Narayana" <sreeman007(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Problme in my pg_dump command
Date: 2006-09-12 14:28:33
Message-ID: 8ea4d8d0609120728x7df90e82q117fafb4a1e52b46@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sree Narayana 2006-09-12 14:33:22 Re: Sorry.Problme in my pg_restore command.
Previous Message Matthieu Guamis 2006-09-12 12:09:40 INSERT does not finish except if it is carried out a few minutes after the creation of the table