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