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

Re: Problem in my backup command

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "Sree Narayana" <sreeman007(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem in my backup command
Date: 2006-09-08 11:19:01
Message-ID: bf54be870609080419i72ecda2w71b3d50b40256634@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
These are not the errors, this is because of the -v switch in your pg_dump
command and it ends up showing the verbose output for pg_dump process. Just
take out the -v swtich from the command and they will not show up.

Thanks,
-- 
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 9/8/06, Sree Narayana <sreeman007(at)gmail(dot)com> wrote:
>
> Hi
> Good morning.
>
> I am trying to implement the database backup through java.
>
> Initailly I have run the following command from windows prompt:
>
> C:\>[path to pg_dump]\pg_dump.exe -h localhost -p 5432 -U postgres -F c -v
> -f C:\[ptah to backup file]\db_backup.backup myDB
>
> On running the above command, the following messages were seen on windows
> command window (I have copied partial set of messages only).
>
> pg_dump: reading schemas
> pg_dump: reading user-defined functions
> pg_dump: reading user-defined types
> pg_dump: reading procedural languages
> pg_dump: reading user-defined aggregate functions
> pg_dump: reading user-defined operators
> pg_dump: reading user-defined operator classes
> pg_dump: reading user-defined conversions
> pg_dump: reading user-defined tables
> pg_dump: reading table inheritance information
> pg_dump: reading rewrite rules
> pg_dump: reading type casts
> pg_dump: finding inheritance relationships
> pg_dump: reading column info for interesting tables
> pg_dump: finding the columns and types of table "pmam1"
> pg_dump: finding the columns and types of table "pmcheck"
> ......................................................
> ......................................................
> ......................................................
> pg_dump: flagging inherited columns in subtables
> pg_dump: reading indexes
> pg_dump: reading indexes for table "pmam1"
> pg_dump: reading indexes for table "pmcheck"
> ......................................................
> ......................................................
> ......................................................
> pg_dump: reading constraints
> pg_dump: reading foreign key constraints for table "pmcheckms"
> pg_dump: reading foreign key constraints for table "pmcheckos"
> ......................................................
> ......................................................
> ......................................................
> pg_dump: reading triggers
> pg_dump: reading triggers for table "pmcheckms"
> ......................................................
> ......................................................
> ......................................................
> pg_dump: reading dependency data
> pg_dump: saving encoding
> pg_dump: saving database definition
> pg_dump: dumping contents of table agentdefvalobject
> pg_dump: dumping contents of table alert
> pg_dump: dumping contents of table alertlogger
> pg_dump: dumping contents of table alertpolicyobject
> I am not sure whether these messages are eror messages or common. So to
> test this, in my java program I have created an error stream and cought the
> messages. Surprisingly it has cought same above messages.
>
> So does it mean that all the above messages are error messages?
> So is there any problem in the command I am running? Then what is the
> correct command?
>
> To suppres this messages, I can do that by removing "-f" from my above
> command.
>
> Please correct my above command.
>
> Thanks
> Sreeman
>
>
>
>

In response to

pgsql-novice by date

Next:From: Solomon AsareDate: 2006-09-08 20:51:02
Subject: Insert Only Postgresql
Previous:From: Sree NarayanaDate: 2006-09-08 11:11:20
Subject: Problem in my backup command

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