Re: Master server stoped working

Hi

pg_ctl: command not found

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

> Hi Arvind ,
>
> Ok .. can you execute and share the output
>
> Pg_ctl start -D {PGDATA}
>
> Sent from my iPhone
>
> On 20-Sep-2018, at 4:12 PM, arvind chikne <arvind(dot)chikne(at)gmail(dot)com> wrote:
>
> 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
>
>

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