Re: Problem in my backup command

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
>
>
>
>