Re: Master server stoped working

Actually its seems that there is no activity captured in the
/var/log/postgresql/postgresql-9.5-main.log
pls see below the log
root(at)Master:~# tail -f /var/log/postgresql/postgresql-9.5-main.log
2018-09-19 17:32:41 IST [325-9] dhis(at)up HINT: In a moment you should be
able to reconnect to the database and repeat your command.
2018-09-19 17:32:41 IST [31038-1] dhis(at)dhis WARNING: terminating
connection because of crash of another server process
2018-09-19 17:32:41 IST [31038-2] dhis(at)dhis DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server process exited abnormally and possibly
corrupted shared memory.
2018-09-19 17:32:41 IST [31038-3] dhis(at)dhis HINT: In a moment you should
be able to reconnect to the database and repeat your command.
2018-09-19 17:32:41 IST [324-49] dhis(at)up WARNING: terminating connection
because of crash of another server process
2018-09-19 17:32:41 IST [324-50] dhis(at)up DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server process exited abnormally and possibly
corrupted shared memory.
2018-09-19 17:32:41 IST [324-51] dhis(at)up HINT: In a moment you should be
able to reconnect to the database and repeat your command.
2018-09-19 17:32:41 IST [27616-3] dhis(at)up WARNING: terminating connection
because of crash of another server process
2018-09-19 17:32:41 IST [27616-4] dhis(at)up DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server process exited abnormally and possibly
corrupted shared memory.
2018-09-19 17:32:41 IST [27616-5] dhis(at)up HINT: In a moment you should be
able to reconnect to the database and repeat your command.

On Thu, Sep 20, 2018 at 2:53 PM Thomas Poty <thomas(dot)poty(at)gmail(dot)com> wrote:

> Hi,
> Could you share your log in /var/log/postgresql/postgresql-9.5-main.log
> from server start
> to the end ?
>
> Le jeu. 20 sept. 2018 à 11:11, arvind chikne <arvind(dot)chikne(at)gmail(dot)com> a
> écrit :
>
>> Hi
>> All of sudden my master server goes down pls see the error below when
>> tried to start it
>>
>> Sep 20 14:33:30 Master postgresql(at)9(dot)5-main[2162]: Error: could not exec
>> /usr/lib/postgresql/9.5/bin/pg_ctl /usr/lib/postgresql/9.5/bin/pg_ctl start
>> -D /var/lib/postgresql/9.5/main -l
>> /var/log/postgresql/postgresql-9.5-main.log -s -o -c
>> config_file="/etc/postgresql/9.5/main/postgresql.conf" :
>> Sep 20 14:33:30 Master systemd[1]: postgresql(at)9(dot)5-main(dot)service: Control
>> process exited, code=exited status=1
>> Sep 20 14:33:30 Master systemd[1]: Failed to start PostgreSQL Cluster
>> 9.5-main.
>> Sep 20 14:33:30 Master systemd[1]: postgresql(at)9(dot)5-main(dot)service: Unit
>> entered failed state.
>> Sep 20 14:33:30 Master systemd[1]: postgresql(at)9(dot)5-main(dot)service: Failed
>> with result 'exit-code'.
>>
>>
>> --
>> *Thanks & Regards*
>> Arvind rao chikne
>> 9818979986
>> *Think Green!!!* Please consider your environmental responsibility
>> before printing this e-mail
>>
>>

--
*Thanks & Regards*
Arvind rao chikne
9818979986
*Think Green!!!* Please consider your environmental responsibility before
printing this e-mail