From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ekaterina Amez <ekaterina.amez@zunibal.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Should I care about this error "failed to link /usr/bin/psql [...] exists and it is not a symlink"?
Date: Wed, 04 Dec 2019 08:39:05 -0500
Message-ID: <14287.1575466745@sss.pgh.pa.us> (raw)
In-Reply-To: <31b43b9f-10a7-f7bf-4a9a-b4f60431d708@zunibal.com>
References: <516a1fbf-2323-4278-86f0-e7e4886f73e5@zunibal.com>
<32105.1575386099@sss.pgh.pa.us>
<e2c8585d-4f91-8bd3-839d-f91ff644f203@zunibal.com>
<4347.1575389441@sss.pgh.pa.us>
<31b43b9f-10a7-f7bf-4a9a-b4f60431d708@zunibal.com>
Ekaterina Amez <ekaterina.amez@zunibal.com> writes:
> When you say "Red Hat's postgres packages use a much different file
> layout than the PGDG packages, so they don't interoperate terribly
> well.", I guess you're talking about the installation, not the structure
> of the database. If I'm right, there shouldn't be problems with
> pg_upgrade (I'm worried about data corruption as I'm not sure how to
> detect it).
Right, I'm just talking about where they put the installed executables
and libraries. The database data per se should be compatible.
> Would it be possible to install another server with same CentOS but with
> PGDG packages of postgres 9.2 and create the replica to this server and
> replaces this one with main server when both are completely synchronized?
Should work, I think, and that's probably a good idea. PGDG's file layout
supports having both 9.2 and 9.6 installed on the same machine much better
than Red Hat's does.
regards, tom lane
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: tgl@sss.pgh.pa.us, ekaterina.amez@zunibal.com, pgsql-admin@lists.postgresql.org
Subject: Re: Should I care about this error "failed to link /usr/bin/psql [...] exists and it is not a symlink"?
In-Reply-To: <14287.1575466745@sss.pgh.pa.us>
* 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