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