Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eiyr3-0005Cr-Sz for pgsql-admin@arkaria.postgresql.org; Tue, 06 Feb 2018 08:43:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eiyr2-0001Ce-Iz for pgsql-admin@arkaria.postgresql.org; Tue, 06 Feb 2018 08:43:52 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eiyr2-0001CV-8u for pgsql-admin@lists.postgresql.org; Tue, 06 Feb 2018 08:43:52 +0000 Received: from susanne.redcor.ch ([178.63.103.72]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eiyqz-0005oM-9k for pgsql-admin@lists.postgresql.org; Tue, 06 Feb 2018 08:43:51 +0000 Received: from [192.168.0.100] (84-72-41-168.dclient.hispeed.ch [84.72.41.168]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: robert@redcor.ch) by susanne.redcor.ch (Postfix) with ESMTPSA id 55972A0358 for ; Tue, 6 Feb 2018 09:43:46 +0100 (CET) Subject: solution: Re: ubuntu pg_wrapper selects the wrong version for pg_restore To: pgsql-admin@lists.postgresql.org References: <49114390-1ce9-fc64-eb2a-aa7bf141a01c@redcor.ch> From: robert Message-ID: Date: Tue, 6 Feb 2018 09:43:45 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------91E50263B40A27CF35EBABC7" Content-Language: en-GB List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------91E50263B40A27CF35EBABC7 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit thanks, On 06.02.2018 08:39, Shreeyansh Dba wrote: > Hi, > Please find response inline... > I think you need to set your environment variable with the new version in > .bash_profile, this will also help pg_wrapper to pick the correct version you > are looking for. i added the following to: /etc/postgresql-common/user_clusters # USER GROUP VERSION CLUSTER DATABASE * * 10 main * --------------91E50263B40A27CF35EBABC7 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

thanks,
On 06.02.2018 08:39, Shreeyansh Dba wrote:

Hi,

Please find response inline...

I think you need to set your environment variable with the new version in .bash_profile, this will also help pg_wrapper to pick the correct version you are looking for.

i added the following to: /etc/postgresql-common/user_clusters
# USER GROUP VERSION CLUSTER DATABASE
* * 10 main *

--------------91E50263B40A27CF35EBABC7--