Backup of database

From: joka veera Venkataramana <ramanajvv(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Backup of database
Date: 2013-11-26 16:28:00
Message-ID: CANGhxCgYrQbvegp1MbjbQ0SLpoVOC1TSqZYBObgE9pO4_N+Dbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Krause 2013-11-26 16:53:20 Re: Backup of database
Previous Message Verhaag Geert (GEN) 2013-11-26 12:10:56 Re: Unable to fire up the server when modifying client authentication setting!