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 EFA265E46C1 for ; Thu, 2 Sep 2004 13:28:59 -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 57159-05 for ; Thu, 2 Sep 2004 16:29:04 +0000 (GMT) Received: from ecintweb.eldocomp.com (ecintweb.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id B46705E3F15 for ; Thu, 2 Sep 2004 13:28:54 -0300 (ADT) Received: by ecintweb.eldocomp.com with XWall v3.29f ; Thu, 2 Sep 2004 09:29:00 -0700 From: Naomi Walker To: Christopher Browne Cc: "pgsql-admin@postgresql.org" Reply-To: "nwalker@eldocomp.com" Subject: Re: Create Linux Script for PostgreSQL database backup Date: Thu, 2 Sep 2004 09:28:59 -0700 X-Assembled-By: XWall v3.29f Message-ID: <41374A4B.5050805@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/27 X-Sequence-Number: 14730 This is a multi part message in MIME format. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Christopher Browne wrote: >A long time ago, in a galaxy far, far away, sandro.garoffolo@unito.it (San= dro Garoffolo) wrote: >=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 >> > >You don't have to if you put it in $HOME/.pgpass; see the >documentation for the format of that file... >=20=20 > True, but I see that as a *big* security hole. --=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 Christopher Browne wrote:
A long time ago, in a galaxy far, far away, sandro.ga=
roffolo@unito.it (Sandro Garoffolo) wrote:
  
One question , if you set  access to server with passwor=
d 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.

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