Re: Problme in my pg_dump command - Mailing list 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