[GENERAL] About Pgdump
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
Re: [GENERAL] About Pgdump
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
Re: [GENERAL] About Pgdump
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
Re: [GENERAL] About Pgdump
On Fri, 19 Sep 2003, Edwin Quijada wrote: Where can I find that file .pgpass?? Can I create ? How ate the entry in this file??? Not for 7.3: touch ~/.pgpass chmod 0600 ~/.pgpass echo '*:*:*:username:password' ~/.pgpass Note that this presumes you are logged in as the user who will be dumping the database(s). From: Richard Huxton [EMAIL PROTECTED] To: Deepa K [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [GENERAL] About Pgdump Date: Fri, 19 Sep 2003 10:13:19 +0100 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 -- Nigel J. Andrews ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly