Re: Master server stoped working

Hi Arvind ,

Can you please check the location of postgresql.conf file ? It looks like , it is in different location than what you have given in the command i.e. ( -D /var/lib/postgresql/9.5/main)

Thanks ,
Soumitra
________________________________
From: arvind chikne <arvind(dot)chikne(at)gmail(dot)com>
Sent: Thursday, September 20, 2018 3:01 PM
To: thomas(dot)poty(at)gmail(dot)com
Cc: pgsql-admin
Subject: 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<mailto: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<mailto: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