Thread: ssl enabling of postgres on Mac OS X
Hi folks. I successfully compiled/built pg 8.1.9 using --with-openssl on a Mac. I modified the startup config files to enable ssl. Server starts without problems, but when I try to require SSL from pgAdminIII, I get "server does not support SSL". Has anyone been able to get an SSL-enabled PG built and running on Mac OS X (10.2.4)? Help -- I am pulling the last hairs I have left.
Michael Hogarth <mahogarth@ucdavis.edu> writes:
> Has anyone been able to get an SSL-enabled PG built and running on
> Mac OS X (10.2.4)?
Dunno about 10.2.x, but it seems to work fine for me on 10.4.10.
Can you connect with psql, and does it show a startup comment like
this:
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
regards, tom lane
On Jul 6, 2007, at 9:57 PM, Michael Hogarth wrote: > Hi folks. > > I successfully compiled/built pg 8.1.9 using --with-openssl on a Mac. > I modified the startup config files to enable ssl. > Server starts without problems, but when I try to require SSL from > pgAdminIII, I get "server does not support SSL". > > Has anyone been able to get an SSL-enabled PG built and running on > Mac OS X (10.2.4)? > > Help -- I am pulling the last hairs I have left. This may not apply at all. When I tried to get subversion to work with openssl, the key was to compile neon with openssl. Does any of this use Neon? If not, then please hit 'd' for delete....
Hello. Is it possible to retrieve information about how many rows were changed/inserted in a table that fired after statement trigger? Thanks, Zlatko
Re: How to retrieve number of rows affected, in an after statement trigger?
From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > Is it possible to retrieve information about how many rows were > changed/inserted in a table that fired after statement trigger? Not directly, but you can store the information from row-level triggers and gather it at the end. See this plperl example: http://people.planetpostgresql.org/greg/index.php?/archives/2007/05/30.html - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200707070745 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFGj30hvJuQZxSWSsgRA9iXAJ0aiS5oVbYxcY69yY0zvig4G4eBTwCdE5ON EYV77TeTYNSRt46fsZDfkTI= =C7mD -----END PGP SIGNATURE-----
Thank you for the answer. At least I'm glad it is possible! But , as I don't know Perl, could you, please, tell me how to accomplish it in plpgsql. Thanks, Zlatko ----- Original Message ----- From: "Greg Sabino Mullane" <greg@turnstep.com> To: <pgsql-general@postgresql.org> Sent: Saturday, July 07, 2007 1:47 PM Subject: Re: [GENERAL] How to retrieve number of rows affected, in an after statement trigger? > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: RIPEMD160 > > >> Is it possible to retrieve information about how many rows were >> changed/inserted in a table that fired after statement trigger? > > Not directly, but you can store the information from row-level > triggers and gather it at the end. See this plperl example: > > http://people.planetpostgresql.org/greg/index.php?/archives/2007/05/30.html > > - -- > Greg Sabino Mullane greg@turnstep.com > PGP Key: 0x14964AC8 200707070745 > http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 > -----BEGIN PGP SIGNATURE----- > > iD8DBQFGj30hvJuQZxSWSsgRA9iXAJ0aiS5oVbYxcY69yY0zvig4G4eBTwCdE5ON > EYV77TeTYNSRt46fsZDfkTI= > =C7mD > -----END PGP SIGNATURE----- > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings