Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ic9Mu-0007eD-UW for pgsql-admin@arkaria.postgresql.org; Tue, 03 Dec 2019 14:41:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ic9Mt-00084h-Jf for pgsql-admin@arkaria.postgresql.org; Tue, 03 Dec 2019 14:41:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ic9Mt-00084X-4r for pgsql-admin@lists.postgresql.org; Tue, 03 Dec 2019 14:41:35 +0000 Received: from mail-wr1-x42c.google.com ([2a00:1450:4864:20::42c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ic9Mn-0004iG-5v for pgsql-admin@lists.postgresql.org; Tue, 03 Dec 2019 14:41:32 +0000 Received: by mail-wr1-x42c.google.com with SMTP id j42so3914011wrj.12 for ; Tue, 03 Dec 2019 06:41:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zunibal-com.20150623.gappssmtp.com; s=20150623; h=to:from:subject:message-id:date:user-agent:mime-version :content-language; bh=qD75WkdWHBEl3p0yG3BR5gKwJmibiW0eduv35iexygk=; b=GoVYMS7kHtWaPLzT98ULqQqpGg2MbYGO/SE0LulNsZPzgaomJZGc2VqnrAq9WRAfxi cgenYxpU9bAHVOLnz6QGJxJ7JRszdm4uWODp2OmQCjP1Mtt76pEcH1JT5RdScOi/Lh4u SqSBHyXxWxeqZHD57qZLO5GemkLnIR9dd7rrMa3rrhsR0mOP6+FvuYnNtR+iUB8cR89z ifAi1iUMvJmwFTfN3kormbX+gv0XQxNy0M/kJ2SQPdDjzYJp4z0osOCwpfnxDTOAefg+ H1ja2GL1v5/G88ax3rZqESa4bRSipjhZz70D7wv814QnefgkdsvRxyNk7LoqV2GQLiRs AeSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-language; bh=qD75WkdWHBEl3p0yG3BR5gKwJmibiW0eduv35iexygk=; b=IVTzsCq8D/cFi5yexB1iCkh9x69/JvTPYPgp6rqjulDfHdbRX95RAKhlKWy+YNiTfS 6VFvzQPwS3BAGU6ZmV+FOXXmGnb+7UtvoqQeK0LL6YU+aUlTO17iY/nk67mwwylpkRjT KSia6GY9Vox9L9/jBpRKD9piRgE3xG2OGZCiFuGkeThwZk5mIiSBXt+Uh6GScA2Whvmg kjDXZu0urEIA17oEZodFEe72HMbi+CFoEIrkhuLtnwSdkHE/doLE1Fh9gVcMvru1NwGO lLEH0i6hqO3eVlWKw5G2qUxAwVFGDEmla/pxseY79KMLDrtwne6PtIEq+jmXwFR3HJK/ nv5A== X-Gm-Message-State: APjAAAXdKy24MyzydKg7MBU0XYqoU6wo3HNL2nherbb9eczPq61d+3VH 8eeFmPvfBXByOidquez8+UKy6KvMEzU= X-Google-Smtp-Source: APXvYqxiT/V2FaWT6I8RakJYFapgrMh2NPebQZwk86Mxh4GwGhQS2ci/6CKjVWbuNXV/XZ42ut3EJA== X-Received: by 2002:a5d:5284:: with SMTP id c4mr5327649wrv.376.1575384083245; Tue, 03 Dec 2019 06:41:23 -0800 (PST) Received: from [192.168.3.150] ([176.222.91.85]) by smtp.gmail.com with ESMTPSA id n14sm3170189wmi.26.2019.12.03.06.41.22 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 03 Dec 2019 06:41:22 -0800 (PST) To: pgsql-admin@lists.postgresql.org From: Ekaterina Amez Subject: Should I care about this error "failed to link /usr/bin/psql [...] exists and it is not a symlink"? Message-ID: <516a1fbf-2323-4278-86f0-e7e4886f73e5@zunibal.com> Date: Tue, 3 Dec 2019 15:41:21 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.2.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------273AB583DB3E62212A58E5D2" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------273AB583DB3E62212A58E5D2 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Hi all, 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. It's the second machine where I see it, but previous one was a development server and I passed over it. But now I'm trying to make a guide to take this procedure to a Production server. I understand what this error is telling me, what I'm missing is if this has or can have any side effects. The full installation log is (sorry for the parts in Spanish but I guess is more or less legible, if translation needed please ask): *[root@test-replicas ~]#* yum install postgresql96-server [....] Running transaction check Running transaction test Transaction test succeeded Running transaction Instalando : postgresql96-libs-9.6.16-2PGDG.rhel7.x86_64 1/3 Instalando : postgresql96-9.6.16-2PGDG.rhel7.x86_64 2/3 failed to link /usr/bin/psql -> /etc/alternatives/pgsql-psql: /usr/bin/psql exists and it is not a symlink failed to link /usr/bin/clusterdb -> /etc/alternatives/pgsql-clusterdb: /usr/bin/clusterdb exists and it is not a symlink failed to link /usr/bin/createdb -> /etc/alternatives/pgsql-createdb: /usr/bin/createdb exists and it is not a symlink failed to link /usr/bin/createlang -> /etc/alternatives/pgsql-createlang: /usr/bin/createlang exists and it is not a symlink failed to link /usr/bin/createuser -> /etc/alternatives/pgsql-createuser: /usr/bin/createuser exists and it is not a symlink failed to link /usr/bin/dropdb -> /etc/alternatives/pgsql-dropdb: /usr/bin/dropdb exists and it is not a symlink failed to link /usr/bin/droplang -> /etc/alternatives/pgsql-droplang: /usr/bin/droplang exists and it is not a symlink failed to link /usr/bin/dropuser -> /etc/alternatives/pgsql-dropuser: /usr/bin/dropuser exists and it is not a symlink failed to link /usr/bin/pg_basebackup -> /etc/alternatives/pgsql-pg_basebackup: /usr/bin/pg_basebackup exists and it is not a symlink failed to link /usr/bin/pg_dump -> /etc/alternatives/pgsql-pg_dump: /usr/bin/pg_dump exists and it is not a symlink failed to link /usr/bin/pg_dumpall -> /etc/alternatives/pgsql-pg_dumpall: /usr/bin/pg_dumpall exists and it is not a symlink failed to link /usr/bin/pg_restore -> /etc/alternatives/pgsql-pg_restore: /usr/bin/pg_restore exists and it is not a symlink failed to link /usr/bin/reindexdb -> /etc/alternatives/pgsql-reindexdb: /usr/bin/reindexdb exists and it is not a symlink failed to link /usr/bin/vacuumdb -> /etc/alternatives/pgsql-vacuumdb: /usr/bin/vacuumdb exists and it is not a symlink Instalando : postgresql96-server-9.6.16-2PGDG.rhel7.x86_64 3/3 Comprobando : postgresql96-libs-9.6.16-2PGDG.rhel7.x86_64 1/3 Comprobando : postgresql96-server-9.6.16-2PGDG.rhel7.x86_64 2/3 Comprobando : postgresql96-9.6.16-2PGDG.rhel7.x86_64 3/3 Instalado: postgresql96-server.x86_64 0:9.6.16-2PGDG.rhel7 Dependencia(s) instalada(s): postgresql96.x86_64 0:9.6.16-2PGDG.rhel7 postgresql96-libs.x86_64 0:9.6.16-2PGDG.rhel7 ¡Listo! *[root@test-replicas ~]#* ls -l /usr/bin/psql /etc/alternatives/pgsql-psql lrwxrwxrwx. 1 root root 23 dic 3 12:37/etc/alternatives/pgsql-psql ->/usr/pgsql-9.6/bin/psql -rwxr-xr-x. 1 root root 449280 nov 6 2016/usr/bin/psql I've searched this error, but the only thing I've found is something about alternatives system, and the command update-alternatives. But I don't fully understand this system (I'm used to Windows) and this means that when using the command I'm not sure about what I'm doing, and I can't go to a Production environment like this. An alternative to this could be copy all these files to another location and replace them with links to the copies. But this solution looks a bit ugly (don't know how to express better :D). Should I go the easy way (copy files and replace original ones with links), is better the first option (update-alternatives) or is there another solution? Thank you for your time, Ekaterina --------------273AB583DB3E62212A58E5D2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Hi all,

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. It's the second machine where I see it, but previous one was a development server and I passed over it. But now I'm trying to make a guide to take this procedure to a Production server. I understand what this error is telling me, what I'm missing is if this has or can have any side effects.

The full installation log is (sorry for the parts in Spanish but I guess is more or less legible, if translation needed please ask):

[root@test-replicas ~]# yum install postgresql96-server
[....]
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Instalando    : postgresql96-libs-9.6.16-2PGDG.rhel7.x86_64                                                                                                                                            1/3 
  Instalando    : postgresql96-9.6.16-2PGDG.rhel7.x86_64                                                                                                                                                 2/3 
failed to link /usr/bin/psql -> /etc/alternatives/pgsql-psql: /usr/bin/psql exists and it is not a symlink
failed to link /usr/bin/clusterdb -> /etc/alternatives/pgsql-clusterdb: /usr/bin/clusterdb exists and it is not a symlink
failed to link /usr/bin/createdb -> /etc/alternatives/pgsql-createdb: /usr/bin/createdb exists and it is not a symlink
failed to link /usr/bin/createlang -> /etc/alternatives/pgsql-createlang: /usr/bin/createlang exists and it is not a symlink
failed to link /usr/bin/createuser -> /etc/alternatives/pgsql-createuser: /usr/bin/createuser exists and it is not a symlink
failed to link /usr/bin/dropdb -> /etc/alternatives/pgsql-dropdb: /usr/bin/dropdb exists and it is not a symlink
failed to link /usr/bin/droplang -> /etc/alternatives/pgsql-droplang: /usr/bin/droplang exists and it is not a symlink
failed to link /usr/bin/dropuser -> /etc/alternatives/pgsql-dropuser: /usr/bin/dropuser exists and it is not a symlink
failed to link /usr/bin/pg_basebackup -> /etc/alternatives/pgsql-pg_basebackup: /usr/bin/pg_basebackup exists and it is not a symlink
failed to link /usr/bin/pg_dump -> /etc/alternatives/pgsql-pg_dump: /usr/bin/pg_dump exists and it is not a symlink
failed to link /usr/bin/pg_dumpall -> /etc/alternatives/pgsql-pg_dumpall: /usr/bin/pg_dumpall exists and it is not a symlink
failed to link /usr/bin/pg_restore -> /etc/alternatives/pgsql-pg_restore: /usr/bin/pg_restore exists and it is not a symlink
failed to link /usr/bin/reindexdb -> /etc/alternatives/pgsql-reindexdb: /usr/bin/reindexdb exists and it is not a symlink
failed to link /usr/bin/vacuumdb -> /etc/alternatives/pgsql-vacuumdb: /usr/bin/vacuumdb exists and it is not a symlink
  Instalando    : postgresql96-server-9.6.16-2PGDG.rhel7.x86_64                                                                                                                                          3/3 
  Comprobando   : postgresql96-libs-9.6.16-2PGDG.rhel7.x86_64                                                                                                                                            1/3 
  Comprobando   : postgresql96-server-9.6.16-2PGDG.rhel7.x86_64                                                                                                                                          2/3 
  Comprobando   : postgresql96-9.6.16-2PGDG.rhel7.x86_64                                                                                                                                                 3/3 

Instalado:
  postgresql96-server.x86_64 0:9.6.16-2PGDG.rhel7                                                                                                                                                            

Dependencia(s) instalada(s):
  postgresql96.x86_64 0:9.6.16-2PGDG.rhel7                                                           postgresql96-libs.x86_64 0:9.6.16-2PGDG.rhel7                                                          

¡Listo!
[root@test-replicas ~]# ls -l /usr/bin/psql /etc/alternatives/pgsql-psql
lrwxrwxrwx. 1 root root     23 dic  3 12:37 /etc/alternatives/pgsql-psql -> /usr/pgsql-9.6/bin/psql
-rwxr-xr-x. 1 root root 449280 nov  6  2016 /usr/bin/psql

I've searched this error, but the only thing I've found is something about alternatives system, and the command update-alternatives. But I don't fully understand this system (I'm used to Windows) and this means that when using the command I'm not sure about what I'm doing, and I can't go to a Production environment like this. An alternative to this could be copy all these files to another location and replace them with links to the copies. But this solution looks a bit ugly (don't know how to express better :D).

Should I go the easy way (copy files and replace original ones with links), is better the first option (update-alternatives) or is there another solution?

Thank you for your time,

Ekaterina

--------------273AB583DB3E62212A58E5D2--