pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql.conf file goes missing everytime I restart postgres DB server.
8+ messages / 4 participants
[nested] [flat]
* postgresql.conf file goes missing everytime I restart postgres DB server.
@ 2019-04-09 16:33 arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 16:40 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Alvaro Herrera <alvherre@2ndquadrant.com>
2019-04-09 16:52 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 2 replies; 8+ messages in thread
From: arnab biswas @ 2019-04-09 16:33 UTC (permalink / raw)
To: pgsql-admin; +Cc: vikas@webdataconsulting.in
Hi,
I am trying to setup postgresql bdr 9.4. I have to do regular restart of DB
server after doing changes in postgresql.conf and pg_hba.conf. After
restart the postgresql.conf file does not load. It gives the following
error:
/var/lib/postgresql/9.4/main/postgresql.conf not found
I could not find any solution to this issue. Requesting your kind reply to
this issue.
Regards,
ARNAB BISWAS
MOB: 7064342437
PRN: 18030241056
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgresql.conf file goes missing everytime I restart postgres DB server.
2019-04-09 16:33 postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
@ 2019-04-09 16:40 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2019-04-09 16:50 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 19:02 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Vikas Bodani <vikas@webdataconsulting.in>
1 sibling, 2 replies; 8+ messages in thread
From: Alvaro Herrera @ 2019-04-09 16:40 UTC (permalink / raw)
To: arnab biswas <arnab.biswas@associates.scit.edu>; +Cc: pgsql-admin; vikas@webdataconsulting.in
On 2019-Apr-09, arnab biswas wrote:
> I am trying to setup postgresql bdr 9.4. I have to do regular restart of DB
> server after doing changes in postgresql.conf and pg_hba.conf. After
> restart the postgresql.conf file does not load. It gives the following
> error:
>
> /var/lib/postgresql/9.4/main/postgresql.conf not found
>
> I could not find any solution to this issue. Requesting your kind reply to
> this issue.
So how do you recreate the postgresql.conf file?
Maybe you have some HA tool that starts up another server, and delete
this one's config file in order to prevent split-brain.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgresql.conf file goes missing everytime I restart postgres DB server.
2019-04-09 16:33 postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 16:40 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Alvaro Herrera <alvherre@2ndquadrant.com>
@ 2019-04-09 16:50 ` arnab biswas <arnab.biswas@associates.scit.edu>
1 sibling, 0 replies; 8+ messages in thread
From: arnab biswas @ 2019-04-09 16:50 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@2ndquadrant.com>; +Cc: pgsql-admin; vikas@webdataconsulting.in
Exactly, I am not able to recreate the postgresql.conf file.
I checked every log and I can't find a file that is deleting the
postgres.conf file.
I have to setup everything all over again inside a new VM, which is a
impractical scenario for operations.
Regards,
ARNAB BISWAS
MOB: 7064342437
PRN: 18030241056
On Tue 9 Apr, 2019, 22:10 Alvaro Herrera, <alvherre@2ndquadrant.com> wrote:
> On 2019-Apr-09, arnab biswas wrote:
>
> > I am trying to setup postgresql bdr 9.4. I have to do regular restart of
> DB
> > server after doing changes in postgresql.conf and pg_hba.conf. After
> > restart the postgresql.conf file does not load. It gives the following
> > error:
> >
> > /var/lib/postgresql/9.4/main/postgresql.conf not found
> >
> > I could not find any solution to this issue. Requesting your kind reply
> to
> > this issue.
>
> So how do you recreate the postgresql.conf file?
>
> Maybe you have some HA tool that starts up another server, and delete
> this one's config file in order to prevent split-brain.
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgresql.conf file goes missing everytime I restart postgres DB server.
2019-04-09 16:33 postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 16:40 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Alvaro Herrera <alvherre@2ndquadrant.com>
@ 2019-04-09 19:02 ` Vikas Bodani <vikas@webdataconsulting.in>
2019-04-09 19:09 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Alvaro Herrera <alvherre@2ndquadrant.com>
1 sibling, 1 reply; 8+ messages in thread
From: Vikas Bodani @ 2019-04-09 19:02 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@2ndquadrant.com>; +Cc: arnab biswas <arnab.biswas@associates.scit.edu>; pgsql-admin@postgresql.org, Vikas Bodani <vikas@webdataconsulting.in>
> Maybe you have some HA tool that starts up another server, and delete
this one's config file in order to prevent split-brain.
Thanks Alvaro. Since this happens during the multi-master bdr setup, could
the other postgres instance within bdr, begin up and running while we
restart this one, delete this one's config? What do you mean split-brain?
Thanks
*Vikas Bodani*
www.webdatatechnologies.in
On Tue, Apr 9, 2019 at 10:10 PM Alvaro Herrera <alvherre@2ndquadrant.com>
wrote:
> On 2019-Apr-09, arnab biswas wrote:
>
> > I am trying to setup postgresql bdr 9.4. I have to do regular restart of
> DB
> > server after doing changes in postgresql.conf and pg_hba.conf. After
> > restart the postgresql.conf file does not load. It gives the following
> > error:
> >
> > /var/lib/postgresql/9.4/main/postgresql.conf not found
> >
> > I could not find any solution to this issue. Requesting your kind reply
> to
> > this issue.
>
> So how do you recreate the postgresql.conf file?
>
> Maybe you have some HA tool that starts up another server, and delete
> this one's config file in order to prevent split-brain.
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
--
Disclaimer:
Information contained and transmitted by this e-mail is
confidential and proprietary to Web Data Technologies LLP (Web Data) and
its affiliates and is intended for use only by the recipient. If you are
not the intended recipient, you are hereby notified that any dissemination,
distribution, copying or use of this e-mail is strictly prohibited and you
are requested to delete this e-mail immediately and notify the originator
or admin@webdatatechnologies.in. Web Data does not enter into any agreement
with any party by e-mail. Any views expressed by an individual do not
necessarily reflect the view of Web Data Technologies LLP. Web Data is not
responsible for the consequences of any actions taken on the basis of
information provided, through this email. The contents of an attachment to
this e-mail may contain software viruses, which could damage your own
computer system. While we have taken every reasonable precaution to
minimize this risk, we cannot accept liability for any damage which you
sustain as a result of software viruses. You should carry out your own
virus checks before opening an attachment. To know more about us please
visit www.webdatatechnologies.in <http://www.webdataconsulting.in/;.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgresql.conf file goes missing everytime I restart postgres DB server.
2019-04-09 16:33 postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 16:40 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Alvaro Herrera <alvherre@2ndquadrant.com>
2019-04-09 19:02 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Vikas Bodani <vikas@webdataconsulting.in>
@ 2019-04-09 19:09 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2019-04-10 04:55 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
0 siblings, 1 reply; 8+ messages in thread
From: Alvaro Herrera @ 2019-04-09 19:09 UTC (permalink / raw)
To: Vikas Bodani <vikas@webdataconsulting.in>; +Cc: arnab biswas <arnab.biswas@associates.scit.edu>; pgsql-admin
On 2019-Apr-10, Vikas Bodani wrote:
> > Maybe you have some HA tool that starts up another server, and delete
> > this one's config file in order to prevent split-brain.
>
> Thanks Alvaro. Since this happens during the multi-master bdr setup, could
> the other postgres instance within bdr, begin up and running while we
> restart this one, delete this one's config?
BDR by itself does not do that, to the best of my knowledge. I hope you
didn't install the files twice somehow, so that one node's files
overwrote the other node's; I would be very surprised if it let you do
that anyway.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgresql.conf file goes missing everytime I restart postgres DB server.
2019-04-09 16:33 postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 16:40 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Alvaro Herrera <alvherre@2ndquadrant.com>
2019-04-09 19:02 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Vikas Bodani <vikas@webdataconsulting.in>
2019-04-09 19:09 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Alvaro Herrera <alvherre@2ndquadrant.com>
@ 2019-04-10 04:55 ` arnab biswas <arnab.biswas@associates.scit.edu>
0 siblings, 0 replies; 8+ messages in thread
From: arnab biswas @ 2019-04-10 04:55 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@2ndquadrant.com>; +Cc: Vikas Bodani <vikas@webdataconsulting.in>; arnab biswas <arnab.biswas@associates.scit.edu>; pgsql-admin
PFA the snapshot of the path:
/var/lib/postgresql/9.4/main/
The files postgresql.conf and pg_hba.conf are missing.
On Wed, Apr 10, 2019 at 12:39 AM Alvaro Herrera <alvherre@2ndquadrant.com>
wrote:
> On 2019-Apr-10, Vikas Bodani wrote:
>
> > > Maybe you have some HA tool that starts up another server, and delete
> > > this one's config file in order to prevent split-brain.
> >
> > Thanks Alvaro. Since this happens during the multi-master bdr setup,
> could
> > the other postgres instance within bdr, begin up and running while we
> > restart this one, delete this one's config?
>
> BDR by itself does not do that, to the best of my knowledge. I hope you
> didn't install the files twice somehow, so that one node's files
> overwrote the other node's; I would be very surprised if it let you do
> that anyway.
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
--
Regards,
Arnab Biswas
18030241056
7064342437
Attachments:
post1.png (image/png, 186.4K) download
view image
* Re: postgresql.conf file goes missing everytime I restart postgres DB server.
2019-04-09 16:33 postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
@ 2019-04-09 16:52 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-04-09 17:02 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
1 sibling, 1 reply; 8+ messages in thread
From: Shreeyansh Dba @ 2019-04-09 16:52 UTC (permalink / raw)
To: arnab biswas <arnab.biswas@associates.scit.edu>; +Cc: pgsql-admin; vikas@webdataconsulting.in
Hi ARNAB,
Please check default location of postgresql if you installed through the
apt-get - /etc/postgresql/9.4/main/postgresql.conf.
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
On Tue, Apr 9, 2019 at 10:03 PM arnab biswas <
arnab.biswas@associates.scit.edu> wrote:
> Hi,
>
> I am trying to setup postgresql bdr 9.4. I have to do regular restart of
> DB server after doing changes in postgresql.conf and pg_hba.conf. After
> restart the postgresql.conf file does not load. It gives the following
> error:
>
> /var/lib/postgresql/9.4/main/postgresql.conf not found
>
> I could not find any solution to this issue. Requesting your kind reply to
> this issue.
>
> Regards,
>
> ARNAB BISWAS
> MOB: 7064342437
> PRN: 18030241056
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgresql.conf file goes missing everytime I restart postgres DB server.
2019-04-09 16:33 postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 16:52 ` Re: postgresql.conf file goes missing everytime I restart postgres DB server. Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-04-09 17:02 ` arnab biswas <arnab.biswas@associates.scit.edu>
0 siblings, 0 replies; 8+ messages in thread
From: arnab biswas @ 2019-04-09 17:02 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin; vikas@webdataconsulting.in
Hi Shreeyansh,
I followed these two links for postgresql bdr setup:
https://gist.github.com/RafaelMCarvalho/4d5cce26a45d1d5f87d0643a699d41c2
https://www.2ndquadrant.com/en/resources/bdr/bdr-installation-instructions/
Hence, the default installation directory created was:
/var/lib/postgresql/9.4/main and.
/var/lib/postgresql/9.4-bdr/main
Regards,
ARNAB BISWAS
MOB: 7064342437
PRN: 18030241056
On Tue 9 Apr, 2019, 22:24 Shreeyansh Dba, <shreeyansh2014@gmail.com> wrote:
> Hi ARNAB,
>
> Please check default location of postgresql if you installed through the
> apt-get - /etc/postgresql/9.4/main/postgresql.conf.
>
> Thanks & Regards,
> *Shreeyansh DBA Team*
> www.shreeyansh.com
>
>
> On Tue, Apr 9, 2019 at 10:03 PM arnab biswas <
> arnab.biswas@associates.scit.edu> wrote:
>
>> Hi,
>>
>> I am trying to setup postgresql bdr 9.4. I have to do regular restart of
>> DB server after doing changes in postgresql.conf and pg_hba.conf. After
>> restart the postgresql.conf file does not load. It gives the following
>> error:
>>
>> /var/lib/postgresql/9.4/main/postgresql.conf not found
>>
>> I could not find any solution to this issue. Requesting your kind reply
>> to this issue.
>>
>> Regards,
>>
>> ARNAB BISWAS
>> MOB: 7064342437
>> PRN: 18030241056
>>
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2019-04-10 04:55 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-04-09 16:33 postgresql.conf file goes missing everytime I restart postgres DB server. arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 16:40 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2019-04-09 16:50 ` arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 19:02 ` Vikas Bodani <vikas@webdataconsulting.in>
2019-04-09 19:09 ` Alvaro Herrera <alvherre@2ndquadrant.com>
2019-04-10 04:55 ` arnab biswas <arnab.biswas@associates.scit.edu>
2019-04-09 16:52 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-04-09 17:02 ` arnab biswas <arnab.biswas@associates.scit.edu>
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