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 1hItgv-0000jm-RN for pgsql-admin@arkaria.postgresql.org; Tue, 23 Apr 2019 11:34:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hItgt-00067b-8u for pgsql-admin@arkaria.postgresql.org; Tue, 23 Apr 2019 11:34:23 +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 1hItgt-00067U-02 for pgsql-admin@lists.postgresql.org; Tue, 23 Apr 2019 11:34:23 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hItgp-0002Pj-HE for pgsql-admin@postgresql.org; Tue, 23 Apr 2019 11:34:22 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 814C1137C19A2 for ; Tue, 23 Apr 2019 04:34:17 -0700 (MST) Date: Tue, 23 Apr 2019 04:34:17 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1556019257527-0.post@n3.nabble.com> Subject: Problem in starting pgagent after installation in ubuntu MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Community, The below is the link I'm following to install pgagent. My doubt is does pgagent look for an already installed pgadmin? Else can it be installed separately? Link: "https://www.tutorialdba.com/2017/09/how-to-schedule-postgresql-jobs-using.html" The below is the error I'm facing while trying to run the pgAgent daemon. --While I have given hostaddr as localhost root@pgdbsrv2:~/backups# pgagent hostaddr=localhost dbname=postgres user=postgres root@pgdbsrv2:~/backups# Tue Apr 23 15:28:38 2019 WARNING: Couldn't create the primary connection [Attempt #1] Tue Apr 23 15:28:43 2019 WARNING: Couldn't create the primary connection [Attempt #2] Tue Apr 23 15:28:48 2019 WARNING: Couldn't create the primary connection [Attempt #3] Tue Apr 23 15:28:53 2019 WARNING: Couldn't create the primary connection [Attempt #4] Tue Apr 23 15:28:58 2019 WARNING: Couldn't create the primary connection [Attempt #5] Tue Apr 23 15:29:03 2019 WARNING: Couldn't create the primary connection [Attempt #6] Tue Apr 23 15:29:08 2019 WARNING: Couldn't create the primary connection [Attempt #7] Tue Apr 23 15:29:13 2019 WARNING: Couldn't create the primary connection [Attempt #8] Tue Apr 23 15:29:18 2019 WARNING: Couldn't create the primary connection [Attempt #9] Tue Apr 23 15:29:23 2019 WARNING: Couldn't create the primary connection [Attempt #10] Tue Apr 23 15:29:23 2019 ERROR: Stopping pgAgent: Couldn't establish the primary connection with the database server. --While I given hostaddr as "127.0.0.1" root@pgdbsrv2:~/backups# pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres root@pgdbsrv2:~/backups# Tue Apr 23 15:29:40 2019 ERROR: Unsupported schema version: 3. Version 4 is required - please run pgagent_upgrade.sql. And when I type "which pgagent" it is showing as /usr/bin/pgagent Could you please help me where I'm heading wrong? Looking forward to hear from you. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html