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: Tue, 03 Dec 2019 11:10:41 -0500
Message-ID: <4347.1575389441@sss.pgh.pa.us> (raw)
In-Reply-To: <e2c8585d-4f91-8bd3-839d-f91ff644f203@zunibal.com>
References: <516a1fbf-2323-4278-86f0-e7e4886f73e5@zunibal.com>
<32105.1575386099@sss.pgh.pa.us>
<e2c8585d-4f91-8bd3-839d-f91ff644f203@zunibal.com>
Ekaterina Amez <ekaterina.amez@zunibal.com> writes:
> El 3/12/19 a las 16:14, Tom Lane escribió:
>> I believe the issue here is that you've got Red Hat's postgresql packages
>> installed,
> As I've mentioned, this Postgres version comes with CentOs installation,
> so I guess you're right.
>> and they're not set up to participate in alternatives
>> switching. I'd suggest removing those packages
> By "removing those packages" you mean uninstall v9.2? This is a test
> computer and it's not a problem, but I'm afraid this is going to happen
> also in production server, by doing this won't be my cluster be unavailable?
Um, wait a minute. Are you actually running a server with that 9.2
installation? And the goal is to upgrade that to 9.6 using PGDG
packages? If so, it's going to take some experimentation. I'm sure
that whatever upgrade script the PGDG packages provide isn't going
to work; you'll have to run pg_upgrade by hand. It's probably possible,
but bleats from yum are the least of your worries.
Once you do get the data converted over, probably the cleanest way to
resolve the installation conflict is to remove both sets of packages
and then reinstall only the PGDG ones.
> So what's happening is that I have installed a RH version of Postgres
> instead an official one? Am I right?
That would depend on what you want to call "official" ;-). But Red Hat's
postgres packages use a much different file layout than the PGDG packages,
so they don't interoperate terribly well.
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: <4347.1575389441@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