Re: Master server stoped working

Hi Soumitra,

I think that's not the issue all the files are at the right place, it was
working fine till yesterday

On Thu, Sep 20, 2018 at 3:55 PM soumitra bhandary <
soumitra(dot)bhandary(at)hotmail(dot)com> wrote:

> 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> 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
>
>

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