From: soumitra bhandary <soumitra.bhandary@hotmail.com>
To: arvind chikne <arvind.chikne@gmail.com>
To: thomas.poty@gmail.com <thomas.poty@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Master server stoped working
Date: Thu, 20 Sep 2018 10:25:33 +0000
Message-ID: <MA1PR0101MB16879B4DBDDB2E085D9EDDD9E0130@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAHVLh7TuV4r=fH5mS1cZpxH=ra0uvGVp-FC0L9x3CzxWDtar0A@mail.gmail.com>
References: <CAHVLh7ROyAX9qh3gRMQBWnMNiW3Xm95eQgYQhFfSnb_aeOxTjw@mail.gmail.com>
<CAN_ctniR-7aXrJ5aMzRHGOzhM--nL=uyBcAfk9pYAQsvP=zuvg@mail.gmail.com>
<CAHVLh7TuV4r=fH5mS1cZpxH=ra0uvGVp-FC0L9x3CzxWDtar0A@mail.gmail.com>
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.chikne@gmail.com>
Sent: Thursday, September 20, 2018 3:01 PM
To: thomas.poty@gmail.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@Master:~# tail -f /var/log/postgresql/postgresql-9.5-main.log
2018-09-19 17:32:41 IST [325-9] dhis@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@dhis WARNING: terminating connection because of crash of another server process
2018-09-19 17:32:41 IST [31038-2] dhis@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@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@up WARNING: terminating connection because of crash of another server process
2018-09-19 17:32:41 IST [324-50] dhis@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@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@up WARNING: terminating connection because of crash of another server process
2018-09-19 17:32:41 IST [27616-4] dhis@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@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.poty@gmail.com<mailto:thomas.poty@gmail.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.chikne@gmail.com<mailto:arvind.chikne@gmail.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@9.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@9.5-main.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@9.5-main.service: Unit entered failed state.
Sep 20 14:33:30 Master systemd[1]: postgresql@9.5-main.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: soumitra.bhandary@hotmail.com, arvind.chikne@gmail.com, thomas.poty@gmail.com
Subject: Re: Master server stoped working
In-Reply-To: <MA1PR0101MB16879B4DBDDB2E085D9EDDD9E0130@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox