Re: Master server stoped working

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux