Subject: Re: Should I care about this error "failed to link /usr/bin/psql
 [...] exists and it is not a symlink"?
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org
References: <516a1fbf-2323-4278-86f0-e7e4886f73e5@zunibal.com>
 <32105.1575386099@sss.pgh.pa.us>
From: Ekaterina Amez <ekaterina.amez@zunibal.com>
Message-ID: <e2c8585d-4f91-8bd3-839d-f91ff644f203@zunibal.com>
Date: Tue, 3 Dec 2019 16:34:04 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.2.1
MIME-Version: 1.0
In-Reply-To: <32105.1575386099@sss.pgh.pa.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

Hi Tom,

El 3/12/19 a las 16:14, Tom Lane escribió:
> Ekaterina Amez <ekaterina.amez@zunibal.com> writes:
>> I'm installing postgres 9.6 in a CentOS 7 computer that already has
>> postgres v9.2 installed (version that comes with CentOS installer) and
>> I've seen the message of this mail's subject.
>> ...
>> failed to link /usr/bin/psql -> /etc/alternatives/pgsql-psql: /usr/bin/psql exists and it is not a symlink
>> ...
> 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?
> --- having them installed
> alongside PGDG postgres packages is going to lead to nothing but grief.
>
> 			regards, tom lane

So what's happening is that I have installed a RH version of Postgres 
instead an official one? Am I right?

Regards,

Ekaterina