> 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?
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
> 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
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.
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
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
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
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
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
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
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
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
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
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-
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
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
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
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
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
> 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
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
21 matches
Mail list logo