Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgresql.conf file goes missing everytime I restart postgres DB server.

postgresql.conf file goes missing everytime I restart postgres DB server.

From
arnab biswas
Date:
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
   

Re: postgresql.conf file goes missing everytime I restart postgresDB server.

From
Alvaro Herrera
Date:
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

Re: postgresql.conf file goes missing everytime I restart postgres DB server.

From
arnab biswas
Date:
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

Re: postgresql.conf file goes missing everytime I restart postgres DB server.

From
Shreeyansh Dba
Date:
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
   

Re: postgresql.conf file goes missing everytime I restart postgres DB server.

From
arnab biswas
Date:
Hi Shreeyansh,

I followed these two links for postgresql bdr setup:



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
   

Re: postgresql.conf file goes missing everytime I restart postgres DB server.

From
Vikas Bodani
Date:
> 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


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.