Re: Backup of database

I highly recommend that you review the page in the PostgreSQL documentation for pg_dump before proceeding.   If this is
newto 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
recommendusing psql if you're connecting with a shell.   

On Nov 26, 2013, at 10:28 AM, joka veera Venkataramana <ramanajvv@gmail.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
differentuser (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
providethe 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.
>
>
>
>