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:
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 по дате отправления: