Re: Backup of database

I highly recommend that you review the page in the PostgreSQL documentation for pg_dump before proceeding. If this is new to you, this page has all the information you should need to get started (including examples at the bottom).

http://www.postgresql.org/docs/9.2/static/app-pgdump.html

You don't need pgadmin on any of your server machines. It's really just a nice to have GUI client for the database. I recommend using psql if you're connecting with a shell.

On Nov 26, 2013, at 10: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.
>
>
>
>