Re: Fwd: [CentOS] Centos 7 LAPP setup Postgresql version and setup

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