Mikkel Høgh wrote: > On 14/10/2008, at 20.23, Daniel Verite wrote: >> What I've noticed on drupal-6.4 with Ubuntu 8.04 is that the default >> postgresql.conf has: >> ssl=true >> and since drupal doesn't allow connecting to pgsql with unix socket >> paths [1], what you get by default is probably TCP + SSL encryption. >> A crude test that just connects and disconnect to a local pg server >> appears to me to be 18 times faster when SSL is off. >> So you might want to check if setting ssl to false makes a difference >> for your test. > > Ouch, there's a gotcha. So enabling SSL gives you SSL connections by > default, even for localhost? That’s… unexpected. Yes. To avoid it, specify "hostnossl" in the pg_hba.conf file.That will refuse all SSL connections. //Magnus -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
