Re: [GENERAL] Query Plans on Slaves

2014-11-09 Thread Tatsuo Ishii
> We're still considering this architecture - so I don't have any plans. > > My question is, does the ANALYZE command, which is only executed on the > master, mean that the statistics / plans that are used on the master are > ALSO used on the slaves? OR does the slave create it's own plan?

Re: [GENERAL] Query Plans on Slaves

2014-11-09 Thread Anthony Presley
We're still considering this architecture - so I don't have any plans. My question is, does the ANALYZE command, which is only executed on the master, mean that the statistics / plans that are used on the master are ALSO used on the slaves? OR does the slave create it's own plan? I would an

Re: [GENERAL] Query Plans on Slaves

2014-11-09 Thread Tatsuo Ishii
> Hi all! > > We're working on our architecture for our next set of systems, and we > normally have a simple master/slave with wal shipping and hot_standby set > up, with pgpool sitting in front of both to do load balancing. > > However, one piece I'm very confused about is the query plans on the

[GENERAL] Query Plans on Slaves

2014-11-09 Thread Anthony Presley
Hi all! We're working on our architecture for our next set of systems, and we normally have a simple master/slave with wal shipping and hot_standby set up, with pgpool sitting in front of both to do load balancing. However, one piece I'm very confused about is the query plans on the slave server.

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread David Johnston
Yes, that is what I was referring to. The Nabble.com website showed them. http://postgresql.1045698.n5.nabble.com/SSL-Certificates-in-Postgres-9-3-and-Windows-7-td5826230.html David J. On Sunday, November 9, 2014, Magnus Hagander wrote: > On Sun, Nov 9, 2014 at 11:37 PM, David Johnston > > wr

Re: [GENERAL] UUID index unused

2014-11-09 Thread Kevin Wooten
This affirmation that it indeed does work set me straight. I inadvertently made a previously immutable UUID function volatile; it was providing the UUIDs in the query. > On Nov 9, 2014, at 2:12 PM, Tom Lane wrote: > > Kevin Wooten writes: >> I am assuming I am crazy and missing something comp

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread Magnus Hagander
On Sun, Nov 9, 2014 at 11:37 PM, David Johnston wrote: > > > On Sunday, November 9, 2014, Adrian Klaver > wrote: >> >> On 11/09/2014 10:14 AM, David G Johnston wrote: >>> >>> Adrian Klaver-4 wrote > > Thank you for all comments and suggestions. More comments/suggestions wil

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread David Johnston
On Sunday, November 9, 2014, Adrian Klaver wrote: > On 11/09/2014 10:14 AM, David G Johnston wrote: > >> Adrian Klaver-4 wrote >> >>> Thank you for all comments and suggestions. >>> >>> More comments/suggestions will have to wait until the missing pieces are >>> filled in. >>> >> >> I read m

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread Adrian Klaver
On 11/09/2014 10:17 AM, David G Johnston wrote: Quoting original message to try and show file contents... harpagornis wrote I am trying to implement SSL certificates with postgres 9.3 locally in Windows 7. In Windows Component Services / Local Services, postrgres is configured to start automa

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread Adrian Klaver
On 11/09/2014 10:14 AM, David G Johnston wrote: Adrian Klaver-4 wrote Thank you for all comments and suggestions. More comments/suggestions will have to wait until the missing pieces are filled in. I read most of these mailing list emails via Nabble and the pieces you show as missing are pre

Re: [GENERAL] UUID index unused

2014-11-09 Thread Tom Lane
Kevin Wooten writes: > I am assuming I am crazy and missing something completely obvious but I > cannot get postgres (9.3.5) to use an index on a UUID, ever. Worksforme: regression=# create table foo (f1 uuid primary key); CREATE TABLE regression=# explain select * from foo where f1 = 'a0eebc

Re: [GENERAL] UUID index unused

2014-11-09 Thread Adrian Klaver
On 11/09/2014 10:58 AM, Kevin Wooten wrote: I am assuming I am crazy and missing something completely obvious but I cannot get postgres (9.3.5) to use an index on a UUID, ever. The main table has a natural composite key (2 uuids and a timestamp) with which it always uses the timestamp as the i

[GENERAL] UUID index unused

2014-11-09 Thread Kevin Wooten
I am assuming I am crazy and missing something completely obvious but I cannot get postgres (9.3.5) to use an index on a UUID, ever. The main table has a natural composite key (2 uuids and a timestamp) with which it always uses the timestamp as the index condition and filters on the UUIDs. Th

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread harpagornis
Windows automatically changed the data folder attribute back to Read Only. The only Windows groups that have full permission are SYSTEM, Administrators and my administrator /user account. -- View this message in context: http://postgresql.1045698.n5.nabble.com/SSL-Certificates-in-Postgres-9-

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread harpagornis
As suggested, I changed the data folder permissions from Read Only to allow Read / Write (I was already logged in as Administrator), but the errors are the same. If I remove the SSL-related lines in pg_hba.conf and postgresql.conf, and use the following lines instead in pg_hba.conf, I am able t

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread David G Johnston
Quoting original message to try and show file contents... harpagornis wrote > I am trying to implement SSL certificates with postgres 9.3 locally in > Windows 7. In Windows Component Services / Local Services, postrgres is > configured to start automatically, with Log On as a local system accoun

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread David G Johnston
Adrian Klaver-4 wrote >> Thank you for all comments and suggestions. > > More comments/suggestions will have to wait until the missing pieces are > filled in. I read most of these mailing list emails via Nabble and the pieces you show as missing are present in what I am reading. If I go to repl

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread Krystian Bigaj
On 9 November 2014 05:07, harpagornis wrote: > I am trying to implement SSL certificates with postgres 9.3 locally in > Windows 7. In Windows Component Services / Local Services, postrgres is > configured to start automatically, with Log On as a local system account. > Postgres on Windows will n

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

2014-11-09 Thread Adrian Klaver
On 11/08/2014 08:07 PM, harpagornis wrote: I am trying to implement SSL certificates with postgres 9.3 locally in Windows 7. In Windows Component Services / Local Services, postrgres is configured to start automatically, with Log On as a local system account. Using my Windows administrator acco

Re: [GENERAL] BDR, 9.4 release schedule, PostgreSQL in Azure, pgPool-II

2014-11-09 Thread Tatsuo Ishii
> Hi All :) > > A few questions from a newbie. > > 1. Use someone BDR in production > (https://wiki.postgresql.org/wiki/BDR_Project)? > 2. When ~ is expected to release 9.4? I don't think it's in 9.4. > 3. Use someone PostgreSQL in Azure and can give any advice? I have no experience with Azur

[GENERAL] BDR, 9.4 release schedule, PostgreSQL in Azure, pgPool-II

2014-11-09 Thread Тарас Савчук
Hi All :) A few questions from a newbie. 1. Use someone BDR in production (https://wiki.postgresql.org/wiki/BDR_Project)? 2. When ~ is expected to release 9.4? 3. Use someone PostgreSQL in Azure and can give any advice? 4. Do I understand correctly that the closest analog of mysql-proxy - it's p