Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFsXI-00H5o0-2s for pgsql-general@arkaria.postgresql.org; Tue, 26 Nov 2024 10:11:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tFsXG-005pBu-Cf for pgsql-general@arkaria.postgresql.org; Tue, 26 Nov 2024 10:11:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFsXG-005pBl-0P for pgsql-general@lists.postgresql.org; Tue, 26 Nov 2024 10:11:10 +0000 Received: from mail-wm1-x32e.google.com ([2a00:1450:4864:20::32e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tFsX9-003xjB-DS for pgsql-general@lists.postgresql.org; Tue, 26 Nov 2024 10:11:08 +0000 Received: by mail-wm1-x32e.google.com with SMTP id 5b1f17b1804b1-434a1fe2b43so12280775e9.2 for ; Tue, 26 Nov 2024 02:11:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732615862; x=1733220662; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=ykFuEhjnGr5JkOLPO6zvh3j0s5DwGC8fRn3S39M2mGk=; b=esjXKM0LJJ7Vydy8Jt6RJjpc2RVhOljvLvvwEKyHQPcGUxSPasSnW5V/e3qePzcvV+ HIpI06Wm6SY8LS9rU0plhpc0bu9g8Q4G9JXLUy3E7n63SlUennlfERWwyrzmkNYEv9+l uWKVMGKkX5RQIUlnOU9KHHmI8jqztr18vx/uj63h8P5F4cwQ/AlM83PDOhPDXqSLtxog n3oRFiXx9ph1FQ3+EO+aWLJsuGQxeBgv8t1RSWLov2peCDXOJ2Z/IeLN3/ItMrUG4SSH JbZj6E5JDP1Gx/suLi6hfd6DlNnN01QP7lvWcXUZyPb7sN5tvxLt21V06aUhBqXY3Jcf ftcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732615862; x=1733220662; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=ykFuEhjnGr5JkOLPO6zvh3j0s5DwGC8fRn3S39M2mGk=; b=UEwjwwULdRM4thh+fSc+a0/vZlRcg2QIIw1wN2kH+GE4b9d+XewftII+bJ4a0NlQ1z 06tRcluXGdlyWZxopdm3U8KtBGynuG+cOCVmrrohezXENzmPtRSazGMDQck46zgTCmv/ tyJZuwQBLC44v4vd1x/fEQ0s+JtFzBLqMabhpj5KfXXRInTkXTUvPwtdAG/XPkCFLK6Q 2ow15IGpV/K+QIDHiFH4QGoKfAyrKENtHKH5ql3qm79sm7asamapAsKyJCvdxFiFJ/bL W4JKl5HwwHjcWF82n3Ld5D8kfrE5AUJ1+6ql1ziqhsMgguSwONWdHcl7MwVYEyU/y340 y5DA== X-Gm-Message-State: AOJu0YzozSQ7CaIMpmD/GTwo8fFlSzd/joB7mmJAaQ+M73zprwYMshIE WbaHuoojWo5LyHB6YDS+htKyPgd3njBlS+H+rtL/Be7UWhJEA/n2 X-Gm-Gg: ASbGncu6MA/eascfLG9DexkC8FmFtwRYo5676kmx/tYN73epWSd8tfvhv39PB/Vi+on EMCaPZYtuyAyR6bn/cr9Ns+UYr7NHdQGVhor+D4i+CxgRpQJziz/qwJPjI7Q1dsnMBYQ4chw8XS el9MMnMZAxsfxfcPe+65TQwFWQVwEAUhgnrwxr1i8E+U0KyZFVm4LmK6yF1ajtuoo0Gx+SPv28y L4koAz2My9+nSMd70Gk3mxi4TKjNDXiT8TFikZXTSTnFbxYT6OtplDZd6GSEpYwpZahAWbA9poB x7yY8YgYX0N1GQQD90quQP+FNi0= X-Google-Smtp-Source: AGHT+IHAuuhUv0Ix4o4ZySbKF5YiRlJVB649W048cN/15sOIWVp4awmtuGbnj4Vl7R7LSxef4yKxTQ== X-Received: by 2002:a05:600c:154d:b0:434:a815:2b57 with SMTP id 5b1f17b1804b1-434a8152d9dmr6029465e9.20.1732615861648; Tue, 26 Nov 2024 02:11:01 -0800 (PST) Received: from smtpclient.apple (143-45-239-77.dyn.cable.qlnet.ch. [77.239.45.143]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-434a0c889c5sm53141965e9.2.2024.11.26.02.11.00 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 26 Nov 2024 02:11:01 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.200.121\)) Subject: Re: DB Switchover using repmgr--Error From: Paul Foerster In-Reply-To: Date: Tue, 26 Nov 2024 11:10:30 +0100 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: jayakumar s X-Mailer: Apple Mail (2.3826.200.121) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, > [postgres@post1 bin]$ ./repmgr -f /var/lib/pgsql/repmgr.conf primary = register > ERROR: following errors were found in the configuration file: > syntax error in file "/var/lib/pgsql/repmgr.conf" line 3, near token = "data_directory" > syntax error in file "/var/lib/pgsql/repmgr.conf" line 6, near token = "log_file" > [postgres@post1 bin]$ >=20 > Conf file: >=20 > [postgres@post1 data]$ cat /var/lib/pgsql/repmgr.conf > node_id=3D1 > node_name=3Dprimary > conninfo=3D'host=3D192.168.29.193 user=3Drepmgr dbname=3Drepmgr = connect_timeout=3D2' data_directory=3D'/application/pgsql/data' = failover=3Dautomatic > promote_command=3D'/usr/pgsql-16/bin/repmgr standby promote -f = /var/lib/pgsql/repmgr.conf --log-to-file' > follow_command=3D'/usr/pgsql-16/bin/repmgr standby follow -f = /var/lib/pgsql/repmgr.conf --log-to-file --upstream-node-id=3D%n' > pg_bindir=3D'/usr/pgsql-16/bin' log_file=3D'/usr/pgsql-16/repmgr.log' > [postgres@post1 data]$ I'm not a repmgr guru but at first glance I would say that your config = lacks two line breaks. It should probably look like this: node_id=3D1 node_name=3Dprimary conninfo=3D'host=3D192.168.29.193 user=3Drepmgr dbname=3Drepmgr = connect_timeout=3D2' data_directory=3D'/application/pgsql/data' failover=3Dautomatic promote_command=3D'/usr/pgsql-16/bin/repmgr standby promote -f = /var/lib/pgsql/repmgr.conf --log-to-file' follow_command=3D'/usr/pgsql-16/bin/repmgr standby follow -f = /var/lib/pgsql/repmgr.conf --log-to-file --upstream-node-id=3D%n' pg_bindir=3D'/usr/pgsql-16/bin' log_file=3D'/usr/pgsql-16/repmgr.log' Cheers Paul=