Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade - Mailing list pgsql-general

From Ken Beck
Subject Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade
Date
Msg-id 2571f3d1-3a84-bbec-f692-7e0495f9dc09@gmail.com
Whole thread Raw
In response to Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Responses Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Thanks for both responses -- the file contents I sent were from file
named postgresql-9.3-main.log.1, and I am assuming this means from the
9.3, not 9.6. Sorry I did not include that earlier. Starting to sousnds
like I need to consult Ubuntu user groups.

Ken Beck
Liberty, Utah, USA

On 03/28/2018 10:46 AM, Moreno Andreo wrote:
> Il 28/03/2018 18:28, Adrian Klaver ha scritto:
>> On 03/28/2018 09:24 AM, Moreno Andreo wrote:
>>> Il 27/03/2018 22:57, Adrian Klaver ha scritto:
>>>> On 03/27/2018 01:46 PM, Ken Beck wrote:
>>>>> I am working on two systems, one running in Oracle VirtualBox on my
>>>>> laptop, the other in a DigitalOcean droplet. I know on one of them I
>>>>> tried to remove the postgres-9.6, and it must have been my laptop,
>>>>> here
>>>>> is the output from pg_lsclusters:
>>>>>
>>>>> Ver Cluster Port Status Owner    Data directory Log file
>>>>> 9.3 main    5432 down   postgres /var/lib/postgresql/9.3/main
>>>>> /var/log/postgresql/postgresql-9.3-main.log
>>>>
>>>> What happens if you do?:
>>>>
>>>> sudo pg_ctlcluster 9.3 main start 
>>> If possible, I'll take a look at
>>> /var/log/postgresql/postgresql-9.3-main.log.
>>> That may give us a big help to uncover what's goin'on.
>>
>> See this post:
>> https://www.postgresql.org/message-id/5bad1f01-d06a-1526-96d2-c9cfd6062a11%40gmail.com
>>
> Yes I saw it, but I can't say if that log was from 9.3 or 9.6
> cluster... as you can see above he wrote that he had a 9.6, that he
> tried to remove, and a 9.3, which was not starting. So it's not clear
> to me if the log he sent was from one version or the another...
>
>>
>>>
>>> Cheers
>>>
>>> Moreno.-
>>>
>>>
>>>
>>
>>
>
>
>



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query Crashes PG 10.3 using partitions, works on 9.6
Next
From: Adrian Klaver
Date:
Subject: Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade