Re: Name of main process differs between servers (postmaster vs postgres)

Поиск
Список
Период
Сортировка
От Jonathan Lemig
Тема Re: Name of main process differs between servers (postmaster vs postgres)
Дата
Msg-id CABR8q_8ZgS6qLJ5R_rLE47W52M8RPcPoNAn3MV7mJUPrTPwo6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Name of main process differs between servers (postmaster vs postgres)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
​Best guess, one of the servers has upgrades from previous versions applied to it while the other started with a newer release.  The upgraded server didn't mess with a pre-existing launch script that was using postmaster while the new one made use of the likely newer script that calls postgres.

I bet it does have something to do with that.  I had to migrate one of our Postgres server from Fedora Core 24/Postgres 9.5 to CentOS 7/Postgres 9.6.  I'm new to Postgres and was playing around with different methods and settled on using pglogical.  I refined (that's being generous) the migration process and migrated DEV and then PROD. Perhaps I should have had our SA re-do the VMs after the refinements, but before doing the final migrations, to make sure everything was apples-to-apples.

Thanks!

Jon

On Tue, Jun 26, 2018 at 5:04 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Jun 26, 2018 at 2:51 PM, Jonathan Lemig <jtlemig@gmail.com> wrote:
From what I can tell, things are running fine on both servers, I guess I just don't like there is a difference/inconsistency.  Can anyone please explain this?


​Best guess, one of the servers has upgrades from previous versions applied to it while the other started with a newer release.  The upgraded server didn't mess with a pre-existing launch script that was using postmaster while the new one made use of the likely newer script that calls postgres.

Dave


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

Предыдущее
От: Yugo Nagata
Дата:
Сообщение: Forbid referencing columns by names in ALTER INDEX ... SETSTATISTICS
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: effect of JIT tuple deform?