From: | Jonathan Lemig <jtlemig(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Name of main process differs between servers (postmaster vs postgres) |
Date: | 2018-06-27 14:09:46 |
Message-ID: | CABR8q_8ZgS6qLJ5R_rLE47W52M8RPcPoNAn3MV7mJUPrTPwo6Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Tue, Jun 26, 2018 at 2:51 PM, Jonathan Lemig <jtlemig(at)gmail(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2018-06-27 15:19:11 | Re: effect of JIT tuple deform? |
Previous Message | Yugo Nagata | 2018-06-27 13:22:29 | Forbid referencing columns by names in ALTER INDEX ... SET STATISTICS |