Re: Master server stoped working

[soumitra bhandary <soumitra.bhandary@xxxxxxxxxxx>]

It's my bad . 

Have you been executed from /usr/lib/postgresql/9.5/bin directory where pg_ctl utility is present . 

or you can execute /usr/lib/postgresql/9.5/bin/Pg_ctl start -D {PGDATA}

{PGDATA} :: To be replaced with data directory where configuration file is present and Log in user must be postgres .

Thanks, 

Soumitra 

---

From: arvind chikne <arvind.chikne@xxxxxxxxx>
Sent: Thursday, September 20, 2018 4:49 PM
To: soumitra.bhandary@xxxxxxxxxxx
Cc: thomas.poty@xxxxxxxxx; pgsql-admin
Subject: Re: Master server stoped working

 

Hi 

pg_ctl: command not found

On Thu, Sep 20, 2018 at 4:37 PM soumitra bhandary <soumitra.bhandary@xxxxxxxxxxx> 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.chikne@xxxxxxxxx> 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.bhandary@xxxxxxxxxxx> 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.chikne@xxxxxxxxx>
Sent: Thursday, September 20, 2018 3:01 PM
To: thomas.poty@xxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxx> 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

--

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