By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,773 Members | 1,724 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,773 IT Pros & Developers. It's quick & easy.

About Pgdump

P: n/a
Hi all,
I want to take backup of our online system on daily basis using
crontab. But actually the pg_hba.conf is configured with password
security.
How I can take the backup without setting password. Or is their any
other
way to take backup.

TIA

regards,
Deepa K
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Friday 19 September 2003 07:35, Deepa K wrote:
Hi all,
I want to take backup of our online system on daily basis using
crontab. But actually the pg_hba.conf is configured with password
security.
How I can take the backup without setting password. Or is their any
other
way to take backup.


Look for the .pgpass entry in the document index. You can create a private
file containing usernames/passwords for databases.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #2

P: n/a

On 19/09/2003 07:35 Deepa K wrote:
Hi all,
I want to take backup of our online system on daily basis using
crontab. But actually the pg_hba.conf is configured with password
security.
How I can take the backup without setting password. Or is their any
other
way to take backup.


You could su to the postgres superuser to do the backup or maybe use a
..pgpass file (needs at least 7.3 IIRC).

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #3

P: n/a
> On Friday 19 September 2003 07:35, Deepa K wrote:
Hi all,
I want to take backup of our online system on daily basis using
crontab. But actually the pg_hba.conf is configured with password
security.
How I can take the backup without setting password. Or is their any
other
way to take backup.


Look for the .pgpass entry in the document index. You can create a private
file containing usernames/passwords for databases.


A second possibility is to create another system and postgres account with
sufficient permissions to run the backup and both 'local' and 'ident sameuser'
in pg_hba.conf. (That's how I have the postgres account set up.)

Then run the backup via cron. You can also use that account to run
periodic vacuums.
--
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.