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
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 Azure. So
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
On 9 November 2014 05:07, harpagornis shenl...@runbox.com 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
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 reply
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 account.
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
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:
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.
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
Kevin Wooten kd...@me.com 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
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
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
On Sunday, November 9, 2014, Adrian Klaver adrian.kla...@aklaver.com
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 most
On Sun, Nov 9, 2014 at 11:37 PM, David Johnston
david.g.johns...@gmail.com wrote:
On Sunday, November 9, 2014, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 11/09/2014 10:14 AM, David G Johnston wrote:
Adrian Klaver-4 wrote
Thank you for all comments and suggestions.
More
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 t...@sss.pgh.pa.us wrote:
Kevin Wooten kd...@me.com writes:
I am assuming I am crazy
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 mag...@hagander.net wrote:
On Sun, Nov 9, 2014 at 11:37 PM,
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
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
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
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?
The
21 matches
Mail list logo
