Re: Sorry.Problme in my pg_restore command.
This is a discussion on Re: Sorry.Problme in my pg_restore command. within the pgsql Novice forums, part of the PostgreSQL category; --> Sorry. Mistakenly I said its problem with pg_dump. Its the problem with pg_restore. Wait for your help. Thank you. ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 10:10 PM
| ||||
| ||||
 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@gmail.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 >      |
Linear Mode
