Re: [ADMIN] psql can't connect to old DB after installing newbinaries

Поиск
Список
Период
Сортировка
От Devrim Gündüz
Тема Re: [ADMIN] psql can't connect to old DB after installing newbinaries
Дата
Msg-id 1507152775.3791.53.camel@gunduz.org
обсуждение исходный текст
Ответ на Re: [ADMIN] psql can't connect to old DB after installing new binaries  (Don Seiler <don@seiler.us>)
Ответы Re: [ADMIN] psql can't connect to old DB after installing new binaries
Re: [ADMIN] psql can't connect to old DB after installing new binaries
Список pgsql-admin
Hi,

On Wed, 2017-10-04 at 15:36 -0500, Don Seiler wrote:
>
> It's pointing to the newly installed version instead of the version it the
> 9.2 lib directory. There isn't any such file under /usr/lib64. So how is it
> even aware of that /usr/pgsql-9.6 version?

There is a file under /etc/ld.so.conf.d directory, which does this magic.

>
> Yep that sounds good for later, although can't really help me in this case.
> I guess I can set unix_socket_directory in 9.2 to use the new location but
> that requires a restart anyway, not ideal.
>
> Would creating a symlink be a workaround? Would that cause issues with
> server restarts?
>
> Mind that this is only to prepare for the upgrade. We aren't planning to
> run both 9.2 and 9.6, and eventually 9.2 would be removed.

What happens when you use 9.2's psql?

/usr/pgsql-9.2/bin/psql

Regards,

--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

В списке pgsql-admin по дате отправления:

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: [ADMIN] psql can't connect to old DB after installing new binaries
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [ADMIN] psql can't connect to old DB after installing new binaries