From sw@zpmt.de Mon Oct 21 12:50:24 2019 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 1iMX8v-0006O6-92 for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2019 12:50:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iMX8r-00046C-QG for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2019 12:50:33 +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 1iMX8r-000465-AU for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2019 12:50:33 +0000 Received: from mo6-p01-ob.smtp.rzone.de ([2a01:238:20a:202:5301::10]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iMX8n-0002OH-LM for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2019 12:50:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; t=1571662225; s=strato-dkim-0002; d=zpmt.de; h=Message-ID:Date:Subject:To:From:X-RZG-CLASS-ID:X-RZG-AUTH:From: Subject:Sender; bh=qL/ynhrX6pyPiYduuiN8jVbsZ891mFhNEsYAJMywMAk=; b=mL+BU9k4XCpNyBEkLsLw6JDBNAFY7BDT1TcqLsidOx168Tfr8wBivUsyDvuWkrb4sN LvBt20wfi2LUoO70A85Q/+pyQ0mF2RYGoTYxvLs5seF1Gr6zuxV/CzlxyGrNWzm3ZikE 1sVI9JMcT7Eap124zrrx9FRa57nQm7piPd2fUFdPVCmMuQeicfRRkrKZWIdZNmNTF1G7 m6jkqX+kLlgN1u5p7mJvNk3t+yKFrYxW4O8DDPyHN8giqfsSlg7pTvEyJn920BHnx8S0 jVXpnn67aciNki/wJNSP8DBRvhT0jd2uA4XoMq9IqiKDt6pH1Ba1T8aDVMeaMG086Gmq CRgA== X-RZG-AUTH: ":P3skb1Clb7FflLtjx7SyHqq9vvRtyij2FeY9PjvgVpE8mmdz07+nqRe9cAwvD3gi4Sfj4pEfAkJHXbfrFECxnI60XA==" X-RZG-CLASS-ID: mo00 Received: from SWHP2016 by smtp.strato.de (RZmta 44.28.1 AUTH) with ESMTPSA id L0b091v9LCoPDVX (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (curve secp384r1 with 384 ECDH bits, eq. 7680 bits RSA)) (Client did not present a certificate) for ; Mon, 21 Oct 2019 14:50:25 +0200 (CEST) From: "Stefan Wolf" To: Subject: pgAgent forces postgresql-9.4 Date: Mon, 21 Oct 2019 14:50:24 +0200 Message-ID: <007801d5880e$1bbba660$5332f320$@zpmt.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0079_01D5881E.DF44EB90" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AdWIDMv2XStKal7jTainoZh2xINQLQ== Content-Language: de List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0079_01D5881E.DF44EB90 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I've installed PostgreSQL 12 on a XUbuntu 19.10. After "apt-get install pgagent" there is a PostgreSQL 9.4 installed and running on Port 5433. I've tried "apt-get remove postgresql-9.4" but this is installing "postgresql-9.5" instead. I want to use pgagent with PostgreSQL 12 only - how? Greetings from Berlin -Stefan Wolf- ------=_NextPart_000_0079_01D5881E.DF44EB90 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I’ve = installed PostgreSQL 12 on a XUbuntu 19.10.

 

After =  “apt-get install pgagent”  there is a PostgreSQL = 9.4 installed and running on Port 5433.

 

I’ve = tried  “apt-get remove postgresql-9.4”  but this = is installing “postgresql-9.5” = instead.

 

I want to = use pgagent with PostgreSQL 12 only – how?

 

Greetings = from Berlin

-Stefan = Wolf-

------=_NextPart_000_0079_01D5881E.DF44EB90-- From ihaider@gmx.com Mon Oct 21 13:29:19 2019 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 1iMXkk-0007ls-HU for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2019 13:29:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iMXkj-0007rJ-Ao for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2019 13:29:41 +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 1iMXki-0007rA-UT for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2019 13:29:41 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iMXkg-0007Ox-5Q for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2019 13:29:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1571664570; bh=adiuEZeo7XCS1LqmjomoZW5D5lMzhKwyQQK83QEvuZI=; h=X-UI-Sender-Class:Date:From:To:In-Reply-To:References:Subject; b=UKkry2FpXi8giylfIaJM3CJUeGpaZqpHCwCCrC/vveTQyze0g+5plAr6IGf7bzq2e qOeKg74USVz0A8O/Yi9ABwItC4Ajn5TDign2cfCq2pm/gYkbVJIRL3ysE0i8EWQeap EzMJbiZwjCoPn5fRhGoKxNcnOFg9Ckk31qyMZ2Z8= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [100.71.25.144] ([223.225.78.74]) by mail.gmx.com (mrgmx005 [212.227.17.184]) with ESMTPSA (Nemesis) id 1MBUmD-1iAhEr1hdP-00D0NY; Mon, 21 Oct 2019 15:29:30 +0200 Date: Mon, 21 Oct 2019 18:59:19 +0530 From: ihaider@gmx.com To: pgsql-admin@lists.postgresql.org, Stefan Wolf Message-ID: <84df1acc-dfb5-43d8-8324-abea819b0b66@Spark> In-Reply-To: <007801d5880e$1bbba660$5332f320$@zpmt.de> References: <007801d5880e$1bbba660$5332f320$@zpmt.de> Subject: Re: pgAgent forces postgresql-9.4 X-Readdle-Message-ID: 84df1acc-dfb5-43d8-8324-abea819b0b66@Spark MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="5dadb2b4_2ced0509_737a" X-Provags-ID: V03:K1:vDdQVo7krMhGhh07Fl8Dw6Q33DAPgLUYJ7jCQ9EC7sFou75L7C3 n19wr/w5QtZTDm8r+4Y+KCwb8OFO+IiSJhUmFsw76Wtuy5Nc58dCPd2cHewfA1xGuLP6Nue KfuXDqyCnjz71/6M4KZtpWKJZHItinLOjxebFv5nQUqMWlMjygCYttB6JsqpnAvxl+I7xXn oSPb/5BsmyvNJoHgfNNSg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:96KgB5nakUY=:TargXAuwJsNVdfnvj6QoJa 36wkgcGytVRuODi9BgwgcnhMVlCQc5tNjLF2iWRbQvhfd1dm++5Z8ycLa7PgjaGs8vQFHHkBE V7uPfB+temQLk1giYwweIfhUCGkc7W+6Qv1ef6Jb4rWU2uGrB9Y5+cMubr5BWJLt11CgdzzvQ GgD7nW9GF/0l+/o0nenJVLZxHwplq3GokaJnbliNNAEjNZ2sAJzxJtTAnUzdUTyMoW/cIGwgi Da180wMSL+bcJ9cAmwGuWkyaIFye+wOhiN0afoXPUFWwlx18jgmTGpuZAPm9Wfu1ApcBnJy2f Ds9JwcQfUw5YfuNjNUbuJFlvr+c1zYyOKYc8ZeonPht0yOCuPGCXgxpIS8sOX7JFeDWaY2hAZ ErVv6iuu0zvX52QvtZmDpbI5qpUqMfXgV5T/xhnjFVJ5UsIf6YcsHCXeE5cir/NSEGvgbQS1d GDKPa+iGpFTbgLtuGd2NRSndAgpCQC3HEXITqsSpH/uUXFb+r4GnrM6ZynM8SEMa4MOUn8bfH Ko6FqS7l4Vwna4uAOcx6yXNOnggf40hrWbRqX0iLVJ271nmG0/taJgwoQDkwKMDcwTYBCxMFi tKKJN3sMdiL3kKBtNV9E6IvgEIyqfJTQJrr1NqmgfJljdGvsaZAsBdXD7G2Yjxxx6lfJi7WhK nYAngCogv4HDjyXd14bELAeKmVak/XjT79l5kCWPS1FoDlqxFNjlS0GQIm0ka76eseMVkLoNN zVc2bNv0DTSAKm0d2+d+e5hAiQFAnrUllqV9i0v+4fTRAiDQiN6A3afoTni4zCKm9M6KjHkdM r5RR8qsm38PwxrcQUZ/FBMvXh+vV6qYpsw6NVfbvlgbPrIL6NbwHKuIlEjA310SL9ndtLS2zw PN3+8UBu2Ua6R2NLEozKFeJGwj9J8x5GnV2BWBnui7gu5ABgu6NgkQos88FF0A+c3P0TKg/BU OUsgi40MKpjVUAVzTFRWNFCRGiqNV6CHlclZYT2Izdrbk3FEsGo571jVib3AmOiznhCX+4OFj Ela44IeYmCQFoA4skrTmv7T4Bed5GXLcGfBUEPojU+7hBAg8m8JRG19NBJ1yrLxz3nvF8xE5y 10XUc/smagQTN5M5Ctt8ZBZPXD884xR3IZx5++89O4eAmEjPCpMhDv1VjbGv9L4yQzr8iAXen ls4MW9VEVMZEgKKQsGbxovkpIJ4saIx+bKfs9/2F4YeTfZs9Jzx0vZloPUoyRs14a+iAnLCyn dUa8y6eoGI0s3fwG2LtBmmf4OZntPDyX3DlBENg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5dadb2b4_2ced0509_737a Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Stefan, You'll need to configure Postgresql PPA for Eoan to make this work. So I = suggest you uninstall all packages which are installed from the base repo= and use PPA instead. Regards, Imran Haider On Oct 21, 2019, 18:20 +0530, Stefan Wolf , wrote: > I=E2=80=99ve installed PostgreSQL 12 on a XUbuntu 19.10. > > After =C2=A0=E2=80=9Capt-get install pgagent=E2=80=9D =C2=A0there is a = PostgreSQL 9.4 installed and running on Port 5433. > > I=E2=80=99ve tried =C2=A0=E2=80=9Capt-get remove postgresql-9.4=E2=80=9D= =C2=A0but this is installing =E2=80=9Cpostgresql-9.5=E2=80=9D instead. > > I want to use pgagent with PostgreSQL 12 only =E2=80=93 how=3F > > Greetings from Berlin > -Stefan Wolf- --5dadb2b4_2ced0509_737a Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hi Stefan,

You'll need to configure Postgresql PPA for Eoan to make this work. So I = suggest you uninstall all packages which are installed from the base repo= and use PPA instead.

Regards,
Imran Haider
On Oct 21, 2019, 18:20 +0530, Stefa= n Wolf <sw=40zpmt.de>, wrote:

I=E2=80=99ve installed PostgreSQL 12 on a XUbuntu 19.10.

&=23160;

After &=23160;=E2=80=9Capt-get install pgagent=E2=80=9D &=231= 60;there is a PostgreSQL 9.4 installed and running on Port 5433.

&=23160;

I=E2=80=99ve tried &=23160;=E2=80=9Capt-get remove postgresql= -9.4=E2=80=9D &=23160;but this is installing =E2=80=9Cpostgresql-9.5=E2=80= =9D instead.

&=23160;

I want to use pgagent with PostgreSQL 12 only =E2=80=93 how=3F=

&=23160;

Greetings from Berlin

-Stefan Wolf-

--5dadb2b4_2ced0509_737a-- From ihaider@gmx.com Mon Oct 21 13:51:30 2019 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 1iMY6H-0000AO-JY for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2019 13:51:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iMY6F-0003wg-8u for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2019 13:51:55 +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 1iMY6E-0003wJ-Sn for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2019 13:51:55 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iMY6B-00035I-G4 for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2019 13:51:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1571665901; bh=yg639Hf00RMnBx9d10FHAQN9QX/EmMIw39QdbRGdto8=; h=X-UI-Sender-Class:Date:From:To:In-Reply-To:References:Subject; b=bJ3u2JQDA9pxMoHhOhg3nUcZtSmYogm5HtyYDm6kabZn/zElIknwBph2BJp6wnBq7 Rd//jUZFKpiSeMPWz//1UD6JTOqwvc1Myru+pNjbG5uUTh8pDnwu/GXeXWpRqBtfYZ ltNsbjTz3QQ3SXhcDHPiyep/a6/FQPo1oyca/ARE= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [100.71.25.144] ([223.225.13.242]) by mail.gmx.com (mrgmx104 [212.227.17.174]) with ESMTPSA (Nemesis) id 1MysRu-1i9oL82nfm-00vu5G; Mon, 21 Oct 2019 15:51:41 +0200 Date: Mon, 21 Oct 2019 19:21:30 +0530 From: ihaider@gmx.com To: pgsql-admin@lists.postgresql.org, Stefan Wolf Message-ID: <9ca9f032-cc78-4307-9483-bc199f02e5ac@Spark> In-Reply-To: <84df1acc-dfb5-43d8-8324-abea819b0b66@Spark> References: <007801d5880e$1bbba660$5332f320$@zpmt.de> <84df1acc-dfb5-43d8-8324-abea819b0b66@Spark> Subject: Re: pgAgent forces postgresql-9.4 X-Readdle-Message-ID: 9ca9f032-cc78-4307-9483-bc199f02e5ac@Spark MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="5dadb7e6_163f63da_b54" X-Provags-ID: V03:K1:5pkajb+/WI22ldBV824RSns2Oe81ff7w60ZyxO8zkXEewSttlSc VpUaV/WfUXPytBj/5EoR4TaOCRN+CA7u7uRq3P3bYhtaic+DuAH34B1f738izN6pCc+UiSP hfvpTaHECSCU4+dLYlXdtGW5p/g4c5U4EaNO2kKqJUCPAg+OUdcZpUf5hrOdK6a0rKtFpuo nx8XkoGG0P0mrEsqJbUDg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:Ijkjn9xFQZ0=:9+Y58JAvKoZANX8yRiOuvf LomrbgLBKPNEGJaFam3gems24NDEjDjW2hQf0mj+yRDNj5wRrpjkUmv0wi8Zf52td6aIZFGmG VSbeHloUoPKW44+mKGNfqT5fPye0bcUfC05iy2/DhS1VbGVw+dzSxaFWN23sSVXCSryrsMa2r 3cg7XQtYyRWMp7MCtDIgojN14SUZol2zft9jNAsPFHEl26jSMd3IJ8Du0qjlxY/+6dLobALFo SliF5ZnESO/sSZC3st2OUUg5cghBHq07MyCTe+7TAb0pPENQceuFmOQi+XzQnyi3UQfl8ZSC7 TzSnIHNL1oltPBVrOlNEB/rtaI/kNbzcZ9/hFBDub28DBv5MxCrphqWV/Tlyi/K133yjY76kq Wny0cSH93UsQ4Iz3FxfuU9UdUQOQT3ABoZSYKOfNWYJWvh2nNcwd/E6a3Tm2w23vi6kmNhF7D 5YFk7043HvRrVFGX+nReyxsCvx0gBKRqYIM5tlWD+MHbawMAEDBXMaDQEdntpFryLAgtiTHmL vrppd8mZ2dJC7U95fwkDuBlh7mbzNwin+nnreZniTpZAufvSaZAimbIhY3tmgthk62o/S48yT CYck4nFcYUpq0rGK7sA+lZkOzCjfTezhCIuH+3BxJgNdYlEBUbZUL7Olba3DtrdYOeeq8eVZ+ svFZMnEWjlhuYDD1bv3NT73chimA/8515tsC2H6yEbJ3DqMgohl93lUQa99GQshucsCF4ho6N lss3GSnMKumBSMaFU7Xf8nMKMSrgssWCsmKteW038GgDm+YaqDDsB9ivUpnP5wvFvWI3R45nh OwjPp+wFoND5tWnK9NFP5L+SQjp0wMt7r439X460OXw4bhElm3LS9VDzIZPGzG2YxZBauBkDI Rmdy+1hYxPI5Y4os/B/xGubHkTZGCBA48IiYUfc7/YlhpCnx6Pw+kSyDB0o89E+ps19QgLHhE rmfm2RINFjCSB4AykFVJVn1IFTGxhCWIG8Z24mv1tFO11NGh/wrfCw/r3pAdSo9VcPXuPkys5 rcsscuGyaMmvjE8uWHQerptiH1vmc4fKjqfYBrdBEL4rzNRcQBXGPf7AQpXAmi3XBxPI3o30G p/34yzCpDHQztX/UiJiYHdmLNWqAhV+NFY331eS4hoe2XnpQRds+nK13hLcGcjGQbrVzpz8UT rglP2wy2eVG/TBW53ruosp6FcGLbc9cliJpFW4zuLoEw0NDPw4EUmanP89wPU5houyWkg1DDV R+qw44GdrgG7tBeJ6Q81sSMsHviNMbW3mbmV7BQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5dadb7e6_163f63da_b54 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline My bad it still depends on potsgresql-9.4 to postgresql-11, so it'll pull= postgresql-9.4 as dependency if postgresql-11 isn't already installed. On Oct 21, 2019, 18:59 +0530, ihaider=40gmx.com, wrote: > Hi Stefan, > > You'll need to configure Postgresql PPA for Eoan to make this work. So = I suggest you uninstall all packages which are installed from the base re= po and use PPA instead. > > Regards, > Imran Haider > On Oct 21, 2019, 18:20 +0530, Stefan Wolf , wrote: > > I=E2=80=99ve installed PostgreSQL 12 on a XUbuntu 19.10. > > > > After =C2=A0=E2=80=9Capt-get install pgagent=E2=80=9D =C2=A0there is = a PostgreSQL 9.4 installed and running on Port 5433. > > > > I=E2=80=99ve tried =C2=A0=E2=80=9Capt-get remove postgresql-9.4=E2=80= =9D =C2=A0but this is installing =E2=80=9Cpostgresql-9.5=E2=80=9D instead= . > > > > I want to use pgagent with PostgreSQL 12 only =E2=80=93 how=3F > > > > Greetings from Berlin > > -Stefan Wolf- --5dadb7e6_163f63da_b54 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
My bad it still depends on potsgresql-9.4 to postgresql-11, so it'll= pull postgresql-9.4 as dependency if postgresql-11 isn't already install= ed.
On Oct 21, 2019, 18:59 +0530, ihaid= er=40gmx.com, wrote:
Hi Stefan,

You'll need to configure Postgresql PPA for Eoan to make this work. So I = suggest you uninstall all packages which are installed from the base repo= and use PPA instead.

Regards,
Imran Haider
On Oct 21, 2019, 18:20 +0530, Stefa= n Wolf <sw=40zpmt.de>, wrote:

I=E2=80=99ve installed PostgreSQL 12 on a XUbuntu 19.10.

&=23160;

After &=23160;=E2=80=9Capt-get install pgagent=E2=80=9D &=231= 60;there is a PostgreSQL 9.4 installed and running on Port 5433.

&=23160;

I=E2=80=99ve tried &=23160;=E2=80=9Capt-get remove postgresql= -9.4=E2=80=9D &=23160;but this is installing =E2=80=9Cpostgresql-9.5=E2=80= =9D instead.

&=23160;

I want to use pgagent with PostgreSQL 12 only =E2=80=93 how=3F=

&=23160;

Greetings from Berlin

-Stefan Wolf-

--5dadb7e6_163f63da_b54--