Postgres Pro
Downloads
Home   >   mailing lists

Backup of database - Mailing list pgsql-admin

From joka veera Venkataramana
Subject Backup of database
Date
Msg-id CANGhxCgYrQbvegp1MbjbQ0SLpoVOC1TSqZYBObgE9pO4_N+Dbw@mail.gmail.com
Whole thread Raw
Responses Re: Backup of database  (Andrew Krause <andrew.krause@breakthroughfuel.com>)
Re: Backup of database  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: Backup of database  (Payal Singh <payal@omniti.com>)
List pgsql-admin
Tree view
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.




pgsql-admin by date:

Previous
From: "Verhaag Geert (GEN)"
Date:
Subject: Re: Unable to fire up the server when modifying client authentication setting!
Next
From: Andrew Krause
Date:
Subject: Re: Backup of database