Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-20 Thread Magnus Hagander
Bruce Momjian wrote: > Magnus Hagander wrote: >> On 14 apr 2009, at 04.33, Bruce Momjian wrote: >> >>> Magnus Hagander wrote: > I would actually call the two parameters 'verify-cert' and 'verify- > cn', > and document that they also have "require" behavior. Obviously you > can't

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-20 Thread Tom Lane
Magnus Hagander writes: > Patch also changes the default from "prefer" to "disable", per discussion. I confess to not having paid attention to this thread for awhile. I have to violently object to this conclusion --- it is throwing the baby out with the bathwater. Under the pretense of being "se

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-20 Thread Magnus Hagander
Tom Lane wrote: > Magnus Hagander writes: >> Patch also changes the default from "prefer" to "disable", per discussion. > > I confess to not having paid attention to this thread for awhile. > I have to violently object to this conclusion --- it is throwing the > baby out with the bathwater. Unde

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-20 Thread Tom Lane
Magnus Hagander writes: > Tom Lane wrote: >> Having a connection that >> was encrypted in 8.3 silently become clear-text after installing 8.4 >> is just plain NOT acceptable. >> >> I think the patch would be fine if we simply keep the default where >> it is, however. Is there some point I am mis

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-20 Thread Magnus Hagander
Tom Lane wrote: > Magnus Hagander writes: >> Tom Lane wrote: >>> Having a connection that >>> was encrypted in 8.3 silently become clear-text after installing 8.4 >>> is just plain NOT acceptable. >>> >>> I think the patch would be fine if we simply keep the default where >>> it is, however. Is t

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-20 Thread Peter Eisentraut
On Monday 20 April 2009 11:19:04 Magnus Hagander wrote: > Bruce Momjian wrote: > > Magnus Hagander wrote: > >> On 14 apr 2009, at 04.33, Bruce Momjian wrote: > >>> Magnus Hagander wrote: > > I would actually call the two parameters 'verify-cert' and 'verify- > > cn', > > and document t

[BUGS] BUG #4764: error -7 in like translate

2009-04-20 Thread Paulo Marques
The following bug has been logged online: Bug reference: 4764 Logged by: Paulo Marques Email address: paulo.da...@gmail.com PostgreSQL version: 8.3 Operating system: win server 2003 Description:error -7 in like translate Details: Select the following operating norma

[BUGS] Scripting issue

2009-04-20 Thread Scott Wells
I am trying to script a pg_dumpall command set to use in a crontab entry. The problem I am finding is that the command pg_dumpall seems to be ignoring the -W input. (I get password prompts on all 4 instances within the DB.) It is happening on a Oracle Enterprise Linux 5 server and PostgreSQL

Re: [BUGS] Scripting issue

2009-04-20 Thread hubert depesz lubaczewski
On Mon, Apr 20, 2009 at 11:08:56AM -0700, Scott Wells wrote: > I am trying to script a pg_dumpall command set to use in a crontab > entry. > The problem I am finding is that the command pg_dumpall seems to be > ignoring the -W input. not sure what you mean by -W input. -W is a switch to force too