Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256

2019-09-19 Thread rob stone
On Thu, 2019-09-19 at 15:23 +0200, Matthias Apitz wrote: > El día Thursday, September 19, 2019 a las 10:31:01PM +1000, rob stone > escribió: > > > > > https://www.postgresql.org/docs/11/auth-password.html > > > > Chapters 20.5 and 20.6 may give you more information. > > The form of the passw

Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256

2019-09-19 Thread domenico febbo
Hi, maybe you want to use [1] pgcrypto encrypt/decrypt function using "secret" word stored outside database. See F.25.4. Raw Encryption Functions [1] https://www.postgresql.org/docs/11/pgcrypto.html Regards, Il giorno gio 19 set 2019 alle ore 16:19 Adrian Klaver < adrian.kla...@aklaver.com> ha

Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256

2019-09-19 Thread Adrian Klaver
On 9/19/19 3:30 AM, Matthias Apitz wrote: Hello, Our software, a huge ILS, is running on Linux with DBS Sybase. To connect to the Sybase server (over the network, even on localhost), credentials must be known: a user (say 'sisis') and its password. For Sybase we have them stored on the disk of

Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256

2019-09-19 Thread Tom Lane
Matthias Apitz writes: > Is there somehow an API in PG to use ciphered passwords and provide as a > shared library the blob to decrypt it? No. Consider a non-password auth mechanism, for instance SSL certificates. You might find that an SSL certificate file stored where libpq will find it is al

Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256

2019-09-19 Thread Matthias Apitz
El día Thursday, September 19, 2019 a las 10:31:01PM +1000, rob stone escribió: > Hello, > > On Thu, 2019-09-19 at 12:30 +0200, Matthias Apitz wrote: > > Hello, > > > > Our software, a huge ILS, is running on Linux with DBS Sybase. To > > connect to the Sybase server (over the network, even on l

Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256

2019-09-19 Thread rob stone
Hello, On Thu, 2019-09-19 at 12:30 +0200, Matthias Apitz wrote: > Hello, > > Our software, a huge ILS, is running on Linux with DBS Sybase. To > connect to the Sybase server (over the network, even on localhost), > credentials must be known: a user (say 'sisis') and its password. > > For Sybase