Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread John Iliffe
On Saturday 08 April 2017 09:20:46 Daniel Verite wrote: > John Iliffe wrote: > > The proper socket does exist: > > > > - > > ls -al /tmp | grep PGSQL > > srwxrwxrwx. 1 postgres postgres0 Apr 7 16:53 .s.PGSQL.5432 > > -rw---. 1 postgres postgres

Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread Joe Conway
On 04/08/2017 01:23 PM, John Iliffe wrote: > On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote: >> So what if you change the connection to use -h localhost? > > Can you please expand on that request? I'm not sure where you want me to > put that directive. I'm using the mod_php module in

Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread John Iliffe
On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote: > On 04/08/2017 06:26 AM, John Iliffe wrote: > > On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote: > >> On 04/07/2017 07:45 PM, Joe Conway wrote: > >>> On 04/07/2017 05:35 PM, Adrian Klaver wrote: > On 04/07/2017 05:03 PM, John

[GENERAL] TimeScaleDB -- Open Source Time Series Database Released (www.i-programmer.info);

2017-04-08 Thread Steve Petrie, P.Eng.
Warm Greetings To pgsql-general@postgresql.org (I am a very newbie user of PG for a pretty trivial PHP / SQL web app. Been lurking with great admiration for a long time, on the pgsql-general@postgresql.org discussion list channel.) I subscribe to a usefully wide-ranging but tightly edited

Re: [GENERAL] keeping WAL after dropping replication slots

2017-04-08 Thread Tom DalPozzo
2017-04-07 15:57 GMT+02:00 Adrian Klaver : > On 04/06/2017 11:18 PM, Tom DalPozzo wrote: > >> >> Hi, >> 2017-04-06 21:51 GMT+02:00 Adrian Klaver > >: >> >> On 04/04/2017 11:52 PM, Tom DalPozzo wrote: >>

Re: [GENERAL] A change in the Debian install

2017-04-08 Thread Daniel Verite
rob stone wrote: > You create a new cluster by running initdb:- > > initdb -D /path/to/my/new/cluster No, if you want to use the infrastructure brought by the debian packages for your cluster, it should be created with: pg_createcluster 9.5 nameofcluster See

Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread John Iliffe
On Friday 07 April 2017 22:45:16 Joe Conway wrote: > On 04/07/2017 05:35 PM, Adrian Klaver wrote: > > On 04/07/2017 05:03 PM, John Iliffe wrote: > Running on Fedora 25 with SELinux in PERMISSIVE mode. The audit > log shows no hits on Postgresql. > >> > >> My going in position was/still

Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread John Iliffe
On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote: > On 04/07/2017 07:45 PM, Joe Conway wrote: > > On 04/07/2017 05:35 PM, Adrian Klaver wrote: > >> On 04/07/2017 05:03 PM, John Iliffe wrote: > > Running on Fedora 25 with SELinux in PERMISSIVE mode. The audit > > log shows no hits on

Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread Daniel Verite
John Iliffe wrote: > The proper socket does exist: > > - > ls -al /tmp | grep PGSQL > srwxrwxrwx. 1 postgres postgres0 Apr 7 16:53 .s.PGSQL.5432 > -rw---. 1 postgres postgres 49 Apr 7 16:53 .s.PGSQL.5432.lock Maybe the httpd service

Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread John Iliffe
On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote: > On 04/07/2017 07:45 PM, Joe Conway wrote: > > On 04/07/2017 05:35 PM, Adrian Klaver wrote: > >> On 04/07/2017 05:03 PM, John Iliffe wrote: > > Running on Fedora 25 with SELinux in PERMISSIVE mode. The audit > > log shows no hits on

Re: [GENERAL] A change in the Debian install

2017-04-08 Thread Adrian Klaver
On 04/07/2017 08:56 PM, rob stone wrote: Hello Adrian, On Thu, 2017-04-06 at 21:24 -0700, Adrian Klaver wrote: On 04/06/2017 08:01 PM, rob stone wrote: That is the default location and is generally the case in a source install. Package maintainers can and do often put them elsewhere.

Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread Adrian Klaver
On 04/08/2017 06:26 AM, John Iliffe wrote: On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote: On 04/07/2017 07:45 PM, Joe Conway wrote: On 04/07/2017 05:35 PM, Adrian Klaver wrote: On 04/07/2017 05:03 PM, John Iliffe wrote: Running on Fedora 25 with SELinux in PERMISSIVE mode. The

Re: [GENERAL] Unable to connect to Postgresql

2017-04-08 Thread Joe Conway
On 04/08/2017 06:31 AM, John Iliffe wrote: > On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote: >> On 04/07/2017 07:45 PM, Joe Conway wrote: >> > On 04/07/2017 05:35 PM, Adrian Klaver wrote: >> >> On 04/07/2017 05:03 PM, John Iliffe wrote: >> > Running on Fedora 25 with SELinux in