Postgres Pro
Downloads
Home   >   mailing lists

Thread: CentOS 6 and Postgresql 9.3.4 from PGDG

CentOS 6 and Postgresql 9.3.4 from PGDG

From
Steve Clark
Date:
Hello,

Don't know if this is better asked on the CentOS ML or here, but...

CentOS 6 supplies 8.4.20 but I want to use hot standby - the issue is that the PGDG
packages don't install into the "usual place" they are installed in version specific directories,
including the data, binaries, libraries etc. How do people deal with this when for years they
have been using postgres and "stuff" is in standard directories not version specific directories?

Thanks for any tips.
Steve

--
Stephen Clark
NetWolves Managed Services, LLC.
Director of Technology
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve.clark@netwolves.com
http://www.netwolves.com

Re: CentOS 6 and Postgresql 9.3.4 from PGDG

From
Moshe Jacobson
Date:

On Mon, Apr 14, 2014 at 8:24 AM, Steve Clark <sclark@netwolves.com> wrote:
CentOS 6 supplies 8.4.20 but I want to use hot standby - the issue is that the PGDG
packages don't install into the "usual place" they are installed in version specific directories,
including the data, binaries, libraries etc. How do people deal with this when for years they
have been using postgres and "stuff" is in standard directories not version specific directories?

It's actually nicer that it uses a version specific directory, IMO, since you can have two versions installed simultaneously for upgrade purposes.
I just create symlinks data/ and backups/ in /var/lib/pgsql to point to the dirs of the same names under the 9.3/ directory.


Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle

Re: CentOS 6 and Postgresql 9.3.4 from PGDG

From
Steve Clark
Date:
On 04/14/2014 09:02 AM, Moshe Jacobson wrote:

On Mon, Apr 14, 2014 at 8:24 AM, Steve Clark <sclark@netwolves.com> wrote:
CentOS 6 supplies 8.4.20 but I want to use hot standby - the issue is that the PGDG
packages don't install into the "usual place" they are installed in version specific directories,
including the data, binaries, libraries etc. How do people deal with this when for years they
have been using postgres and "stuff" is in standard directories not version specific directories?

It's actually nicer that it uses a version specific directory, IMO, since you can have two versions installed simultaneously for upgrade purposes.
I just create symlinks data/ and backups/ in /var/lib/pgsql to point to the dirs of the same names under the 9.3/ directory.

How did you deal with binaries and libraries, as well as third party apps like perl modules or php/apache modules?

--
Stephen Clark
NetWolves Managed Services, LLC.
Director of Technology
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve.clark@netwolves.com
http://www.netwolves.com

Re: CentOS 6 and Postgresql 9.3.4 from PGDG

From
Moshe Jacobson
Date:

On Mon, Apr 14, 2014 at 9:13 AM, Steve Clark <sclark@netwolves.com> wrote:
How did you deal with binaries and libraries, as well as third party apps like perl modules or php/apache modules?

All of this is managed through the /etc/alternatives system. I'm honestly not sure how all of it works, but I know that on my system, all of the postgres binaries and libs are linked through /etc/alternatives.


Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle

Re: CentOS 6 and Postgresql 9.3.4 from PGDG

From
Alan Hodgson
Date:
On Monday, April 14, 2014 09:13:51 AM Steve Clark wrote:
> How did you deal with binaries and libraries, as well as third party apps
> like perl modules or php/apache modules?

The 8.4 library package usually ends up installed to satisfy other package
requirements.

Binaries get handled through the alternatives system.

Re: CentOS 6 and Postgresql 9.3.4 from PGDG

From
Devrim GÜNDÜZ
Date:
Hi,

On Mon, 2014-04-14 at 09:13 -0400, Steve Clark wrote:
> How did you deal with binaries and libraries, as well as third party
> apps like perl modules or php/apache modules?

I added "Provides:" to each package, along with a ldconfig file, so that
the dependencies are satisfied.

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment