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

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@gmail.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
>
>
>
>