Re: Securing .pgpass File? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Securing .pgpass File?
Date
Msg-id 4c9e7fe2d4dde1aa5c823b3dc4cc37df@biglumber.com
Whole thread Raw
In response to Securing .pgpass File?  (Shaun Thomas <sthomas@optionshouse.com>)
Responses Re: Securing .pgpass File?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> Has anyone come up with a good solution for distributing a .pgpass file
> that doesn't expose it to anyone who has access to the distribution
> mechanism?

No, you cannot easily keep it in version control/puppet securely.

One way is to have an external script that does the jobs of
puppet, e.g. for $server in @list do cp pgpass $server/...

Alternatively, use gpg to encrypt the pgpass file, then put *that*
into version control and distribute it. Then have a script on the
server that decrypts it into place. Yes, you have to manually
distribute the encryption key to the servers, but it is a one-time
event, and you can push out changes to the pgpass file easily, and
automate the decrypt-on-the-server bit, including by puppet itself.

It's not clear what the exact threat model is here, but you could
also simply not use pgpass, and find some other means to authenticate.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201210011859
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlBqIOsACgkQvJuQZxSWSshUhgCgtRGVCRLs9F+KPu2RR+rmOVeq
7T8An1ZPdvlEkciRuLiioi2LbSJUTl2f
=GEi7
-----END PGP SIGNATURE-----




pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: How to search for composite type array
Next
From: Craig Ringer
Date:
Subject: pg_typeof equivalent for numeric scale, numeric/timestamp precision?