Re: Create Linux Script for PostgreSQL database backup - Mailing list pgsql-admin

From Tom Lane
Subject Re: Create Linux Script for PostgreSQL database backup
Date
Msg-id 10808.1094146405@sss.pgh.pa.us
Whole thread Raw
In response to Re: Create Linux Script for PostgreSQL database backup  (Naomi Walker <nwalke@eldocomp.com>)
List pgsql-admin
Naomi Walker <nwalke@eldocomp.com> writes:
> Christopher Browne wrote:
>>> One question , if you set  access to server with password in
>>> pg_hba.conf how can you pass the apssword in the script?
>>
>> You don't have to if you put it in $HOME/.pgpass; see the
>> documentation for the format of that file...
>>
> True, but I see that as a *big* security hole.

As opposed to putting it in the script file?  Surely you jest.

            regards, tom lane

pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Re: Create Linux Script for PostgreSQL database backup
Next
From: Naomi Walker
Date:
Subject: Re: Create Linux Script for PostgreSQL database backup