You don't need to install anything for using pg_dump. You can find this command within postgres bin directory, along with psql and other commands.
A simple pg_dump backup command would look like:
/opt/pgsql/bin/pg_dump -Ft db_name > $FILE
Where $FILE is the name of the backup file you will set. '-F' sets the dump format, and 't' stands for tar
More info can be found in the documentation at http://www.postgresql.org/docs/9.2/static/app-pgdump.html
On Tue, Nov 26, 2013 at 11:28 AM, joka veera Venkataramana <ramanajvv@xxxxxxxxx> wrote:
Now we are planning to take the dump of database with pg_dump utility.Hi,We have Postgresql server on Linux environment and have one database.To use pg_dump utility do I need to install Pgadmin on Linux environment?
If yes, do we need to install Pgadmin with root user? because Postgre server instance we have installed with different user (not root user).We are planning to take daily database dump in tar file format, so that it can occupy less space. Can you please provide the complete pg_dump and restore command for tar file format.
I know all my questions are basic, why we are asking here is previously we were in DB2 now we moved our database to Postgre (Its new for us). Please help us.Thanks,Veera.
