Re: Sorry.Problme in my pg_restore command.

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 <sreeman007(at)gmail(dot)com> 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
>