Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group