Re: [GENERAL] Cannot start the PostgreSQL service

On 1/30/2016 12:06 PM, Adrian Klaver wrote: On 01/30/2016 11:01 AM, David Unsworth wrote: Ccing list, so more eyes can see. Assuming this is a Windows machine, what version of the OS? Windows 7 Home Premium Did you check the Windows Event Viewer? When a service fails to start you should

Re: [GENERAL] Cannot start the PostgreSQL service

On 01/30/2016 12:33 PM, Igal @ Lucee.org wrote: On 1/30/2016 12:10 PM, Igal @ Lucee.org wrote: Did you check the Windows Event Viewer? When a service fails to start you should see the details there in the Application log errors. Sorry, I just realized that you had this: 2016-01-25 18:45:19

Re: [GENERAL] Cannot start the PostgreSQL service

On 1/30/2016 12:10 PM, Igal @ Lucee.org wrote: Did you check the Windows Event Viewer? When a service fails to start you should see the details there in the Application log errors. Sorry, I just realized that you had this: 2016-01-25 18:45:19 GMTFATAL: the database system is starting up

Re: [GENERAL] Cannot start the PostgreSQL service

On 01/30/2016 11:01 AM, David Unsworth wrote: Ccing list, so more eyes can see. Hello. Thanks for the reply. Here is some more info. Assuming this is a Windows machine, what version of the OS? Windows 7 Home Premium How did you install Postgres on this machine? With Hold'em Manager software

Re: [GENERAL] Cannot start the PostgreSQL service

David Unsworth wrote: > > This was working until recently. In Services I right clicked on properties > and > I think I changed the METHOD in pg_hba.conf from md5 to trust. > I think after making this change the problems started. > > In Services I cannot start the

Re: [GENERAL] Cannot start the PostgreSQL service

On 01/30/2016 08:24 AM, David Unsworth wrote: Hello. Sorry if I have sent this to too may mail boxes. I hope one of them is correct. Please forward this on if not. For future reference, sending to --general would be sufficient. This was working until recently. In Services I right

[GENERAL] Cannot start the PostgreSQL service

Hello. Sorry if I have sent this to too may mail boxes. I hope one of them is correct. Please forward this on if not. This was working until recently. In Services I right clicked on properties and I think I changed the METHOD in pg_hba.conf from md5 to trust. I think after making this

Re: [GENERAL] BRIN indexes

Felipe Santos wrote: > brin_db=# EXPLAIN ANALYSE SELECT count(*) FROM orders WHERE order_date > BETWEEN '2012-01-04 09:00:00' and '2014-01-04 14:30:00'; > > QUERY PLAN > >

Re: [GENERAL] [ADMIN] Cannot start the PostgreSQL service

The settings in you pg_hba.conf aren't really correct. The second line won't work at all. The max value after the "/" is 32. This is not for the port number. You might wish to search setting a CIDR value, but if you want to allow: Just 192.168.1.1 then host all all

Re: [GENERAL] BRIN indexes

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Felipe Santos Sent: Thursday, January 28, 2016 1:17 PM To: Joshua D. Drake Cc: Melvin Davidson ; David Rowley ;

Re: [GENERAL] Transaction check error installing PostGIS

Hi John, you were right. The one in use was 5.6.27-76.0 Percona Server. How did you guess that this one wasn't being use? On Fri, Jan 29, 2016 at 10:14 PM, Augori wrote: > Okay thanks, John. I will inquire about that. > > On Fri, Jan 29, 2016 at 10:11 PM, John R Pierce

Re: [GENERAL] BDR replication

On 29 January 2016 at 18:27, Nikhil wrote: > Is there any way to specify priority for replication. or any parameter > which guarantees something about replication (speed at which it replicates, > number of minimum replicas to write). > Not yet. Not in core PostgreSQL

[GENERAL] Is PRIMARY KEY the same as UNIQUE NOT NULL?

Apologies in advance if this is not the best list for this. Appreciate a redirection if there is something more appropriate. In the document is mentions that: "Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT NULL" I wanted to clarify if that was, technically, true. I had a