Re: Backup of database

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

Payal Singh,
OmniTi Computer Consulting Inc.
Junior Database Architect,
Phone: 240.646.0770 x 253

On Tue, Nov 26, 2013 at 11:28 AM, joka veera Venkataramana <
ramanajvv(at)gmail(dot)com> wrote:

> Hi,
>
> We have Postgresql server on Linux environment and have one database.
> Now we are planning to take the dump of database with pg_dump utility.
>
> 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.
>
>
>
>
>