X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8122B5E472E for ; Thu, 2 Sep 2004 14:36:49 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83325-05 for ; Thu, 2 Sep 2004 17:36:44 +0000 (GMT) Received: from ecintweb.eldocomp.com (ecintweb.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id 01E6E5E4727 for ; Thu, 2 Sep 2004 14:36:43 -0300 (ADT) Received: by ecintweb.eldocomp.com with XWall v3.29f ; Thu, 2 Sep 2004 10:36:42 -0700 From: Naomi Walker To: Tom Lane Cc: "nwalker@eldocomp.com" , Christopher Browne , "pgsql-admin@postgresql.org" Reply-To: "nwalker@eldocomp.com" Subject: Re: Create Linux Script for PostgreSQL database backup Date: Thu, 2 Sep 2004 10:36:41 -0700 X-Assembled-By: XWall v3.29f Message-ID: <41375A29.5020806@eldocomp.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.2 tagged_above=0.0 required=5.0 tests=EXCUSE_16, HTML_50_60, HTML_MESSAGE, HTML_TITLE_EMPTY, LINES_OF_YELLING, LINES_OF_YELLING_2, MIME_BOUND_NEXTPART X-Spam-Level: * X-Archive-Number: 200409/29 X-Sequence-Number: 14732 This is a multi part message in MIME format. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Tom Lane wrote: >Naomi Walker writes: >=20=20 > >>Christopher Browne wrote: >>=20=20=20=20 >> >>>>One question , if you set access to server with password in >>>>pg_hba.conf how can you pass the apssword in the script? >>>>=20=20=20=20=20=20=20=20 >>>> >>>You don't have to if you put it in $HOME/.pgpass; see the >>>documentation for the format of that file... >>> >>>=20=20=20=20=20=20 >>> >>True, but I see that as a *big* security hole. >>=20=20=20=20 >> > >As opposed to putting it in the script file? Surely you jest. > > regards, tom lane >=20=20 > Anything would plain text would be a problem. Isnt .pgpass plain text? --=20 ------------------------------------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100=20 ------------------------------------------------------------------------- Freedom is not worth having if it does not include the freedom to make mistakes. -Mahatma Gandhi -------------------------------------------------------------------------= =20 -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to w= hom it is addressed, and may contain information that is privileged, confid= ential and exempt from disclosure under applicable law. If you are not the = intended addressee, nor authorized to receive for the intended addressee, y= ou are hereby notified that you may not use, copy, disclose or distribute t= o anyone the message or any information contained in the message. If you ha= ve received this message in error, please immediately advise the sender by = reply email, and delete the message. Thank you. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Tom Lane wrote:
Naomi Walker <nwalke@eldocomp.com> writes:
  
Christopher Browne wrote:
    
One question , if you set  access to server with pas=
sword 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
  
Anything would plain text would be a problem.  Isnt .pgpass plain text?

--=20
-------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Eldorado Computing, Inc.              nwalker@eldocomp.com 602-604-3100=
=20
-------------------------------------------------------------------------
Freedom is not worth having if it does not include the freedom to make
mistakes.      -Mahatma Gandhi
-------------------------------------------------------------------------=
=20
-- CONFIDENTIALITY NOTICE --

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom i= t is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are he= reby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received t= his message in error, please immediately advise the sender by reply email, and delete the message. Thank you.

 

--_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb--