Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

2013-03-17 Thread Ian Pilcher
On 03/18/2013 12:07 AM, Craig Ringer wrote: > So this problem is verified. Thanks for taking the time to look into this. Good to know I'm not crazy. > What we need to happen instead is for root.crt to contain only the > trusted certificates and have a *separate* file or directory for > intermedi

Re: [GENERAL] Enforcing Parameterised Nested Loop Join Order for Foreign Table Joins

2013-03-17 Thread Tom Lane
Adam Zegelin writes: > Some service endpoints have no concept of unqualified queries. In the example > above, a ‘sequence scan’ of Bing is a not possible. In that case, you shouldn't be generating such a path. But keep in mind that this may lead to failure to produce any plan at all for som

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

2013-03-17 Thread Craig Ringer
On 03/09/2013 04:52 PM, Ian Pilcher wrote: > After looking at be-secure.c and investigating the way that OpenSSL > validates certificates, I do not believe that there is any way of > achieving the desired behavior with the current codebase. Test process: SET UP SERVER VERIFIED SSL (NO CLIENT CERT

[GENERAL] Enforcing Parameterised Nested Loop Join Order for Foreign Table Joins

2013-03-17 Thread Adam Zegelin
Hello, I’m in the process of writing a Postgres FDW that can interface with web service endpoints. Certain FDW columns would act as web service parameters, while others would be the output. For example: adam=# select * from bing where query = 'xbox'; query | url

Re: [GENERAL] [HACKERS] Trust intermediate CA for client certificates

2013-03-17 Thread Craig Ringer
On 03/09/2013 04:52 PM, Ian Pilcher wrote: > 3. Once the root CA certificate is trusted, however, the "bad" client >can also connect by using a certificate chain that includes the >Server CA certificate --"cat bad-client.crt server-ca.crt > >~/.postgresql/postgresql.crt". > > After look

[GENERAL] ORDER BY expression required in SELECT if DISTINCT

2013-03-17 Thread Pawel Veselov
Hi. Anything I can do about this? Seems that the problem is that the query is a prepared statement, even if the parameters ($1 and $6) are the same. ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list at character 493 STATEMENT: SELECT DISTINCT t0.package_name, ts_rank(t

Re: [GENERAL] High RAM usage on postgres

2013-03-17 Thread Gunnar "Nick" Bluth
Am 17.03.2013 09:31, schrieb Scott Marlowe: On Thu, Mar 14, 2013 at 12:55 PM, prashantmalik wrote: *Query :* "SELECT * FROM customer" --- top

Re: [GENERAL] sqlj.install_jar stalls

2013-03-17 Thread Adrian Klaver
On 03/11/2013 05:23 AM, vidya.sagar wrote: Hi, I am stuck with this problem since morning... Kindly help Postgre stalls ones i run SELECT sqlj.install_jar('file:///full/path/to/mypackage.jar','MyPackage',true); My Environment is as below: Windows7 postgresql-8.4.12-1-windows jdk-1_5_0_06-windo

Re: [GENERAL] High RAM usage on postgres

2013-03-17 Thread Scott Marlowe
On Thu, Mar 14, 2013 at 12:55 PM, prashantmalik wrote: > Hello, > > We are facing very HIGH memory utilization on postgreSQL server and need > help. > > Total RAM : 32GB > Total CPU : 16cores > > --