From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Gary Stainburn <gary@ringways.co.uk>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Fwd: [CentOS] Centos 7 LAPP setup Postgresql version and setup
Date: Fri, 06 Apr 2018 10:50:35 +0200
Message-ID: <1523004635.2420.45.camel@cybertec.at> (raw)
In-Reply-To: <201804060915.25099.gary@ringways.co.uk>
References: <201804060915.25099.gary@ringways.co.uk>
On Fri, 2018-04-06 at 09:15 +0100, Gary Stainburn wrote:
> I've got a nice shiny new server which I'm going to build as a LAPP platform.
> [...]
>
> 1) 9.2 vs 9.5
>
> Some of the instruction pages I've found install using the standard
> repositories and install version 9.2 (?) while some others add a postgresql
> repo and install 9.5
>
> What are people's opinions? In the long term, and I going to have more admin
> hassle with one over the other?
>
> Will porting schemas including stored functions in pl/psql from 8.3 be
> easier / better with one version over the other?
Do not install 9.2. It is out of support.
Use v10 or 9.6 (if you lean towards older versions).
Do not use the PostgreSQL that comes with the operating system,
use the binaries provided by the PostgreSQL project.
> 2) network vs sockets
>
> I read somewhere that connecting Apache / PHP to Postgresql is faster if you
> use sockets rather than usling the loopback i/f. Is this correct? If it is
> correct, what is the correct connect string if I use the 9.2 or 9.5 RPM's as
> described above?
>
> There seems to be lots of Google content about sockets not working. Is it
> really that hard?
>
> (I use pg_pconnect() to do the connecting)
Sockets is the way to go on localhost if you can.
Just use "host=/tmp" (or wherever unix_socket_directories points on your server).
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, gary@ringways.co.uk
Subject: Re: Fwd: [CentOS] Centos 7 LAPP setup Postgresql version and setup
In-Reply-To: <1523004635.2420.45.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox