pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Fwd: [CentOS] Centos 7 LAPP setup Postgresql version and setup 2+ messages / 2 participants [nested] [flat]
* Fwd: [CentOS] Centos 7 LAPP setup Postgresql version and setup @ 2018-04-06 08:15 Gary Stainburn <gary@ringways.co.uk> 0 siblings, 1 reply; 2+ messages in thread From: Gary Stainburn @ 2018-04-06 08:15 UTC (permalink / raw) To: pgsql-admin Morning all, I posted this to the Centos list yesterday asking for opinions. As a group with better knowledge of the situation, I thought I may get better responses from this group. Gary ---------- Forwarded Message ---------- Hi all, I've got a nice shiny new server which I'm going to build as a LAPP platform. I've just had a quick look for suitable instructions on the best way to configure it and I have a few questions. There are many hits, some better than others. (It is replacing a Fedora 9 server so I'm expecting to have lots of *fun*) 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? 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) ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Fwd: [CentOS] Centos 7 LAPP setup Postgresql version and setup @ 2018-04-06 08:50 Laurenz Albe <laurenz.albe@cybertec.at> parent: Gary Stainburn <gary@ringways.co.uk> 0 siblings, 0 replies; 2+ messages in thread From: Laurenz Albe @ 2018-04-06 08:50 UTC (permalink / raw) To: Gary Stainburn <gary@ringways.co.uk>; pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-04-06 08:50 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-04-06 08:15 Fwd: [CentOS] Centos 7 LAPP setup Postgresql version and setup Gary Stainburn <gary@ringways.co.uk> 2018-04-06 08:50 ` Laurenz Albe <laurenz.albe@cybertec.at>
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