X-Original-To: pgsql-admin@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id DC5704762F6
	for <pgsql-admin@postgresql.org>; Wed,  9 Apr 2003 03:33:35 -0400 (EDT)
Received: from shield.pirmabanka.lv (unknown [195.114.57.4])
	by postgresql.org (Postfix) with ESMTP id 7EDE14762E1
	for <pgsql-admin@postgresql.org>; Wed,  9 Apr 2003 03:33:32 -0400 (EDT)
Received: from wall2.pirmabanka.lv (wall2-pub.pirmabanka.lv [195.114.57.14])
	by shield.pirmabanka.lv (8.12.9/8.12.9) with SMTP id h397XWx0002419
	for <pgsql-admin@postgresql.org>; Wed, 9 Apr 2003 10:33:32 +0300
Received: from share.pirmabanka.lv ([10.0.0.10]) by wall2.pirmabanka.lv;
	Wed, 09 Apr 2003 10:33:30 +0300 (EET DST)
Received: from pc311x1.pirmabanka.lv (localhost.localdomain [127.0.0.1])
	by pirmabanka.lv (8.11.6/8.11.6) with SMTP id h397XT314440
	for <pgsql-admin@postgresql.org>; Wed, 9 Apr 2003 10:33:29 +0300
Received: (qmail 14552 invoked by uid 100); 9 Apr 2003 07:33:48 -0000
Date: Wed, 9 Apr 2003 10:33:48 +0300
From: "Victor Yegorov" <viy@pirmabanka.lv>
To: <hetzel.devel@web.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: <no subject>
Message-ID: <20030409073348.GF13190@pirmabanka.lv>
Mail-Followup-To: <hetzel.devel@web.de>, pgsql-admin@postgresql.org
References: <200304090728.h397Slq01098@mailgate5.cinetic.de>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="5Mfx4RzfBqgnTE/w"
Content-Disposition: inline
In-Reply-To: <200304090728.h397Slq01098@mailgate5.cinetic.de>
User-Agent: Mutt/1.4.1i
X-Spam-Status: No, hits=-37.8 required=5.0
	tests=BAYES_10,IN_REP_TO,PGP_SIGNATURE_2,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/130
X-Sequence-Number: 8285

--5Mfx4RzfBqgnTE/w
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* hetzel.devel@web.de <hetzel.devel@web.de> [09.04.2003 10:31]:
> Hello,
> I'm using PostgreSQL on my Intranet-Server.
> To make postgres more secure the entry in the pg_hba.conf for local users=
 is:
>=20
> local all md5
>=20
> If I want to make a dump with pg_dump, I have to insert the password.=20
> But I can't make a Cron-Job because I always have to insert the password!!
> Is there any way to do this automatic?

Yes. Use ~/.pgpass file. Search docs for more info on file format and other
details.

And next time, please, specify subject of your message.

--=20

Victor Yegorov

--5Mfx4RzfBqgnTE/w
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+k8zc2RKGLEykUDYRAldJAJ9rofHlFwxyYwHvilQQuBwj/OK3jwCgs05q
78lVcprMXcEhMMRHEJSI7wg=
=66fV
-----END PGP SIGNATURE-----

--5Mfx4RzfBqgnTE/w--