pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMaster server stoped working
8+ messages / 3 participants
[nested] [flat]
* Master server stoped working
@ 2018-09-20 09:11 arvind chikne <arvind.chikne@gmail.com>
2018-09-20 09:23 ` Re: Master server stoped working Thomas Poty <thomas.poty@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: arvind chikne @ 2018-09-20 09:11 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Master server stoped working
2018-09-20 09:11 Master server stoped working arvind chikne <arvind.chikne@gmail.com>
@ 2018-09-20 09:23 ` Thomas Poty <thomas.poty@gmail.com>
2018-09-20 09:31 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Thomas Poty @ 2018-09-20 09:23 UTC (permalink / raw)
To: arvind.chikne@gmail.com; +Cc: pgsql-admin
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> 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
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Master server stoped working
2018-09-20 09:11 Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 09:23 ` Re: Master server stoped working Thomas Poty <thomas.poty@gmail.com>
@ 2018-09-20 09:31 ` arvind chikne <arvind.chikne@gmail.com>
2018-09-20 10:25 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: arvind chikne @ 2018-09-20 09:31 UTC (permalink / raw)
To: thomas.poty@gmail.com; +Cc: pgsql-admin
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> 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> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Master server stoped working
2018-09-20 09:11 Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 09:23 ` Re: Master server stoped working Thomas Poty <thomas.poty@gmail.com>
2018-09-20 09:31 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
@ 2018-09-20 10:25 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-09-20 10:42 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: soumitra bhandary @ 2018-09-20 10:25 UTC (permalink / raw)
To: arvind chikne <arvind.chikne@gmail.com>; thomas.poty@gmail.com <thomas.poty@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Master server stoped working
2018-09-20 09:11 Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 09:23 ` Re: Master server stoped working Thomas Poty <thomas.poty@gmail.com>
2018-09-20 09:31 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 10:25 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2018-09-20 10:42 ` arvind chikne <arvind.chikne@gmail.com>
2018-09-20 11:07 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: arvind chikne @ 2018-09-20 10:42 UTC (permalink / raw)
To: soumitra.bhandary@hotmail.com; +Cc: pgsql-admin
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@hotmail.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.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> 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> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Master server stoped working
2018-09-20 09:11 Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 09:23 ` Re: Master server stoped working Thomas Poty <thomas.poty@gmail.com>
2018-09-20 09:31 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 10:25 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-09-20 10:42 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
@ 2018-09-20 11:07 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-09-20 11:19 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: soumitra bhandary @ 2018-09-20 11:07 UTC (permalink / raw)
To: arvind chikne <arvind.chikne@gmail.com>; +Cc: thomas.poty@gmail.com <thomas.poty@gmail.com>; pgsql-admin
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@gmail.com<mailto:arvind.chikne@gmail.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.bhandary@hotmail.com<mailto:soumitra.bhandary@hotmail.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.chikne@gmail.com<mailto:arvind.chikne@gmail.com>>
Sent: Thursday, September 20, 2018 3:01 PM
To: thomas.poty@gmail.com<mailto: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<mailto: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<mailto:postgresql@9.5-main.service>: Unit entered failed state.
Sep 20 14:33:30 Master systemd[1]: postgresql@9.5-main.service<mailto: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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Master server stoped working
2018-09-20 09:11 Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 09:23 ` Re: Master server stoped working Thomas Poty <thomas.poty@gmail.com>
2018-09-20 09:31 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 10:25 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-09-20 10:42 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 11:07 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2018-09-20 11:19 ` arvind chikne <arvind.chikne@gmail.com>
2018-09-20 11:26 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: arvind chikne @ 2018-09-20 11:19 UTC (permalink / raw)
To: soumitra.bhandary@hotmail.com; +Cc: pgsql-admin
Hi
pg_ctl: command not found
On Thu, Sep 20, 2018 at 4:37 PM soumitra bhandary <
soumitra.bhandary@hotmail.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.chikne@gmail.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.bhandary@hotmail.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.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>
>> 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> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Master server stoped working
2018-09-20 09:11 Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 09:23 ` Re: Master server stoped working Thomas Poty <thomas.poty@gmail.com>
2018-09-20 09:31 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 10:25 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-09-20 10:42 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 11:07 ` Re: Master server stoped working soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-09-20 11:19 ` Re: Master server stoped working arvind chikne <arvind.chikne@gmail.com>
@ 2018-09-20 11:26 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: soumitra bhandary @ 2018-09-20 11:26 UTC (permalink / raw)
To: arvind chikne <arvind.chikne@gmail.com>; +Cc: thomas.poty@gmail.com <thomas.poty@gmail.com>; pgsql-admin
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@gmail.com>
Sent: Thursday, September 20, 2018 4:49 PM
To: soumitra.bhandary@hotmail.com
Cc: thomas.poty@gmail.com; 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@hotmail.com<mailto:soumitra.bhandary@hotmail.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.chikne@gmail.com<mailto:arvind.chikne@gmail.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.bhandary@hotmail.com<mailto:soumitra.bhandary@hotmail.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.chikne@gmail.com<mailto:arvind.chikne@gmail.com>>
Sent: Thursday, September 20, 2018 3:01 PM
To: thomas.poty@gmail.com<mailto: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<mailto: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<mailto:postgresql@9.5-main.service>: Unit entered failed state.
Sep 20 14:33:30 Master systemd[1]: postgresql@9.5-main.service<mailto: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
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2018-09-20 11:26 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-09-20 09:11 Master server stoped working arvind chikne <arvind.chikne@gmail.com>
2018-09-20 09:23 ` Thomas Poty <thomas.poty@gmail.com>
2018-09-20 09:31 ` arvind chikne <arvind.chikne@gmail.com>
2018-09-20 10:25 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-09-20 10:42 ` arvind chikne <arvind.chikne@gmail.com>
2018-09-20 11:07 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-09-20 11:19 ` arvind chikne <arvind.chikne@gmail.com>
2018-09-20 11:26 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
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