Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hDtnW-00078A-01 for pgsql-admin@arkaria.postgresql.org; Tue, 09 Apr 2019 16:40:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hDtnT-0007Ag-3h for pgsql-admin@arkaria.postgresql.org; Tue, 09 Apr 2019 16:40:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hDtnS-0007AZ-N3 for pgsql-admin@lists.postgresql.org; Tue, 09 Apr 2019 16:40:30 +0000 Received: from mail-wr1-x442.google.com ([2a00:1450:4864:20::442]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hDtnP-0008Df-Fd for pgsql-admin@postgresql.org; Tue, 09 Apr 2019 16:40:29 +0000 Received: by mail-wr1-x442.google.com with SMTP id r4so21759952wrq.8 for ; Tue, 09 Apr 2019 09:40:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=BGU0b5eea4dT5+TZuHIlWDy5aeDNn/dDTGf3XEZYTLE=; b=etXQyTnYxp9+zPUAN47iq79t6l0uEc6SBjBRXZi2oUpZ5khVY44nE77NX7Y5+Zv1TT 4ZEbMZjj9hwAxp1Yc9kYVEjRJvarSRBFQt5VGZGWdTcdNsTRQ1YhDP7ki32y5gMdiYI0 ipIvXA1lQPkHhcK8a3kw9Q48S5lYxvEJKBPy63EvoymLGEKsuPed8iVUlbK50qazHQYN zcrRcPSYp7r4TMCan9wzV2nRDZFQ1GavfTFF8kh/bZhTJn0coTK+hKcvth//4DbATx2+ 44JgKM95Rxw02kJQpWRX0nz4mlfJYVVlI5/778vdAB8EuWkHGTnJFxQXHdnj7i0E0znP a3fg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=BGU0b5eea4dT5+TZuHIlWDy5aeDNn/dDTGf3XEZYTLE=; b=sjywy1iHTwbVC6XxxxYUVsb9v+RRF7VlToOR83UjtIxQxBhQYIvLgwJMsGNEs5jZfA 2kh8XfzPo8SwOO2lgvobxSxO1sNZNH6p1NwtLXssotmD5UPkGkHAIhVjO7jqIVHvVmdw vvG4r9BxSd4hjLJ9WX1ybNPlyeZNatk887LDKV6N+zx1gyIcNwiu7R++6+cePRqEEmfV Cs3SUSQdgvikFeVBzqyJbRRd8oP2ZGEk+CyZPv6HG8pWjTrQ9sk/MBNyU37VO19HEzht QHSw0ulozgy0ZdYIEwDbqc4ZufgTKAydMX7spLP9ZmFGbLkBAgHUXrnsrtnf8dN6+s4d kqxQ== X-Gm-Message-State: APjAAAXaW20g6RhJ+HuccLGwsQg4ruwH/T0DsaGzwtPVUjoafUZvLR06 5RirZ70Y4yTPPclI1M+EpZKcig== X-Google-Smtp-Source: APXvYqzYBPYbGikOtDDqFLMgbbNH0ZfQk9STAzPzp4NkV+zkyS0R3NF/tJ4xXMybR1P5H5kOtyX+BA== X-Received: by 2002:a5d:6b04:: with SMTP id v4mr21371485wrw.69.1554828025893; Tue, 09 Apr 2019 09:40:25 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id j22sm101829108wrd.91.2019.04.09.09.40.24 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Tue, 09 Apr 2019 09:40:25 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id AEDF8121023; Tue, 9 Apr 2019 12:40:21 -0400 (-04) Date: Tue, 9 Apr 2019 12:40:21 -0400 From: Alvaro Herrera To: arnab biswas Cc: pgsql-admin@postgresql.org, vikas@webdataconsulting.in Subject: Re: postgresql.conf file goes missing everytime I restart postgres DB server. Message-ID: <20190409164021.GA7490@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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