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
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 |