Problem in my backup command

From: "Sree Narayana" <sreeman007(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Problem in my backup command
Date: 2006-09-08 11:11:20
Message-ID: 8ea4d8d0609080411v7ba5a549yc36ae3f435266a97@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Shoaib Mir 2006-09-08 11:19:01 Re: Problem in my backup command
Previous Message Shane Ambler 2006-09-08 05:47:37 Re: replication/synchronisation