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

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   |
+------------------------------+---------------------------------------------+

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

Where can I find that file .pgpass??
Can I create ?
How ate the entry in this file???

From: Richard Huxton <dev@archonet.com>
To: Deepa K <kdeepa@midascomm.com>, pgsql-general@postgresql.org
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

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

http://archives.postgresql.org

_________________________________________________________________
Charla con tus amigos en l�nea mediante MSN Messenger:
http://messenger.yupimsn.com/

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 <dev@archonet.com>
To: Deepa K <kdeepa@midascomm.com>, pgsql-general@postgresql.org
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