Hello,
I am trying to use libpq in two threads, the issue is that I am getting access
violation after several successful connections.
Each thread connects to different db and disconnects immediately after making a
conenction.
So my question is if this is supported by libpq? Is it possible to us
I am using 2 threads, each declares seperate PGconn conenction object.
It connects e.g. 60 times, one connection from one thread, the other connection
from the other thread, usually one after each other.
And it fails at 61'st connection with access violation.
I already tried with PQconnect and P
It is not possible because connection is local variable in both thread
functions, no common variables are used.
I checked that it also crashes without SSL. Two threads connecting to the same
server, different databases.
Joanna
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
I am sure that I am using seperate threads with seperate connection objects and
libpq is compiled to be threadsafe.
I get access violation both with ssl and without it (without ssl it seems to be
more stable, however afer several hundred connects/disconnects it fails).
J.
--
Sent via pgsql-ge
Hi,
I am trying to generate self-signed certificate for full ssl authentication. I
need to have universal version of this certificate for development purposes (so
any client can connect with any postgresql server with ssl on).
I am using IP while connecting, I mean host=.
However verify-full co
Hi,
I am trying to generate self-signed certificate for full ssl authentication. I
need to have universal version of this certificate for development purposes (so
any client can connect with any postgresql server with ssl on and verify-full
flag).
I am using IP while connecting, I mean host=.
Recently I have been working on implementation of mutual SSL authentication
between our application and PostgreSQL database.
I managed to make it work wih "ssl=true" connection option and "clientcert=1"
flags in pg_hba.conf. Moreover I managed to make it work with C++ application
using libpq and
gards,
Joanna
W dniu 2011-08-22 15:37:28 użytkownik Tom Lane napisał:
> Asia writes:
> > Now the issue is then when using libpq it was enough to have only root
> > certificate in server's root.crt and it worked fine.
> > But when I tried using the same with JDBC i
> Asia writes:
> > Now the issue is then when using libpq it was enough to have only root
> > certificate in server's root.crt and it worked fine.
> > But when I tried using the same with JDBC it turned out that I need to put
> > whole chain (2 certs) of Interm
> Asia writes:
> > I would expect to have only one top-level CA cert in server's and client's
> > root.crt and it was not possible to configure with 2-level intermediate CA.
>
> This seems a little confused, since in your previous message you stated
> that l
>
> I think problem is as follows, server sends to client certificates it
> can accept (as accepted parents), without intermediate CA, Java sees
> only top-level cert and tries to find client cert issued directly by
> top-level CA, I may only assume, that without intermediate CA you will
> be
>
> I personally haven't tired SSL for PostgreSQL but, I think, You should
> put in root.crt only intermediate certificate (C1 - from prev post), so
> all and only all "sub-certs" of intermediate CA will be able to
> establish connection (paranoic security).
>
> Putting intermediate CAs as tru
the other about
how libpq works with chained CA's.
Kind regards,
Joanna
W dniu 2011-09-07 16:06:10 użytkownik Tom Lane napisał:
> Asia writes:
> > The problem is that I believe that this configuration could be better but I
> > cannot put part
> > of CA chain in
13 matches
Mail list logo
