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 1h6BcI-0005b2-3c for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 19 Mar 2019 10:05:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6BcG-0001HA-Nf for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 19 Mar 2019 10:05:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6BcG-0001H3-Id for pgsql-pkg-debian@lists.postgresql.org; Tue, 19 Mar 2019 10:05:04 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6BcA-00080Z-Gs for pgsql-pkg-debian@postgresql.org; Tue, 19 Mar 2019 10:05:04 +0000 Received: from msg.df7cb.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 44NpZK3Sh7z3F0h; Tue, 19 Mar 2019 11:04:57 +0100 (CET) Date: Tue, 19 Mar 2019 11:04:57 +0100 From: Christoph Berg To: Vijaykumar Jain Cc: pgsql-pkg-debian@postgresql.org Subject: Re: postgresql-11 installation errors via deb package on ubuntu 16 Message-ID: <20190319100457.GC23312@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Vijaykumar Jain , pgsql-pkg-debian@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Vijaykumar Jain 2019-03-18 > Hey Guys, > > I hope this is the right dist. Hi, it is, thanks for the report. > we are having issues reported similar to > https://stackoverflow.com/questions/2748607/how-to-thoroughly-purge-and-reinstall-postgresql-on-ubuntu > which was ages back :) , but it is repeated. > Setting up postgresql-11 (11.2-1.pgdg16.04+1) ... > Unescaped left brace in regex is deprecated, passed through in regex; > marked by <-- HERE in m/(? /usr/sbin/pam_getenv line 78. (This is a bug in the pam package, not in postgresql-*.) > Configuring already existing cluster (configuration: > /etc/postgresql/11/main, data: /var/lib/postgresql/11/main, owner: > 112:118) > Error: move_conffile: required configuration file > /var/lib/postgresql/11/main/postgresql.conf does not exist > Error: could not create default cluster. Please create it manually with > > pg_createcluster 11 main --start This happens when you didn't fully remove the old cluster and /var/lib/postgresql/11/main is still present: $ sudo pg_createcluster 11 foo $ sudo rm -rf /etc/postgresql/11/foo/ $ sudo pg_createcluster 11 foo Configuring already existing cluster (configuration: /etc/postgresql/11/foo, data: /var/lib/postgresql/11/foo, owner: 111:118) Error: move_conffile: required configuration file /var/lib/postgresql/11/foo/postgresql.conf does not exist To fix, simply delete the data directory. Christoph