Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgresql.conf file not found after database restart.

Postgresql.conf file not found after database restart.

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
   

Re: Postgresql.conf file not found after database restart.

From
Scott Whitney
Date:

Can you provide the output of:


ls -al /var/lib/postgresql/9.4/main/postgresql.conf





From: arnab biswas <arnab.biswas@associates.scit.edu>
Sent: Tuesday, April 9, 2019 11:31 AM
To: pgsql-admin@postgresql.org
Subject: Postgresql.conf file not found after database restart.
 
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
   


 

Scott Whitney
Director of IT

scott@journyx.com | +1 (800) 755-9878

7600 Burnet Road, Ste. 300
Austin, TX 78757

Visit us at www.journyx.com



To unsubscribe from Journyx promotional emails, click here or visit http://journyx.com/communication-preferences.

Re: Postgresql.conf file not found after database restart.

From
arnab biswas
Date:
Hi Scott,

PFA the snapshot of the path:

/var/lib/postgresql/9.4/main/

The files postgresql.conf and pg_hba.conf are missing.

On Tue, Apr 9, 2019 at 10:37 PM Scott Whitney <scott@journyx.com> wrote:

Can you provide the output of:


ls -al /var/lib/postgresql/9.4/main/postgresql.conf





From: arnab biswas <arnab.biswas@associates.scit.edu>
Sent: Tuesday, April 9, 2019 11:31 AM
To: pgsql-admin@postgresql.org
Subject: Postgresql.conf file not found after database restart.
 
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
   


 

Scott Whitney
Director of IT

scott@journyx.com | +1 (800) 755-9878

7600 Burnet Road, Ste. 300
Austin, TX 78757

Visit us at www.journyx.com



To unsubscribe from Journyx promotional emails, click here or visit http://journyx.com/communication-preferences.


--
Regards,

Arnab Biswas
18030241056
7064342437
Attachment

Re: Postgresql.conf file not found after database restart.

From
Stéphane Dunand
Date:
Le 10/04/2019 à 07:01, arnab biswas a écrit :
> Hi Scott,
>
> PFA the snapshot of the path:
>
> /var/lib/postgresql/9.4/main/
>
> The files postgresql.conf and pg_hba.conf are missing.

Your postgresql.conf is in $HOME/9.4/main ? Check in this file 
data_directory parameter.

Stéphane

Re: Postgresql.conf file not found after database restart.

From
Julien Rouhaud
Date:
On Wed, Apr 10, 2019 at 7:01 AM arnab biswas
<arnab.biswas@associates.scit.edu> wrote:
>
> Hi Scott,
>
> PFA the snapshot of the path:
>
> /var/lib/postgresql/9.4/main/
>
> The files postgresql.conf and pg_hba.conf are missing.

Debian and ubuntu have the configuration stored in /etc/postgresql/,
not /var/lib/postgresql.  You should use the pg_ctlcluster command
instead of pg_ctl.  See
http://manpages.ubuntu.com/manpages/trusty/man8/pg_ctlcluster.8.html
and related commands.