Re: Problem in my backup command - Mailing list pgsql-novice

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