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 1s3LkG-00C7ir-KK for pgsql-general@arkaria.postgresql.org; Sat, 04 May 2024 20:12:32 +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 1s3LkD-001vm7-RA for pgsql-general@arkaria.postgresql.org; Sat, 04 May 2024 20:12:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s2rlX-008kQe-Ro for pgsql-general@lists.postgresql.org; Fri, 03 May 2024 12:11:52 +0000 Received: from mail-pg1-x529.google.com ([2607:f8b0:4864:20::529]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s2rlW-001L5H-CL for pgsql-general@lists.postgresql.org; Fri, 03 May 2024 12:11:52 +0000 Received: by mail-pg1-x529.google.com with SMTP id 41be03b00d2f7-61eba9f9c5dso142739a12.0 for ; Fri, 03 May 2024 05:11:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1714738308; x=1715343108; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=UFTHJYThHlwOBSxcirGM7ibIn5vx8y6VcAk9r24ZxQk=; b=hP2TzSUZiFmxoTTv2vfH8kTqtMhYJWleNSUStvnr825b6U5+kAlI5jgYKMfenlM2TE n9zrasinjhVb6IQIvLkolLhvanDFd0wDKTP4Ron8b61lAkatJENAPM/SqN7qVtFK+Lq5 Llc0XXNzWDlDAWOmy8hyVQ8C5wloDoqNUna5iTIc48BQB1X/ALiMd410eO3wj6qQEU7H DmrxgK01CFyXAKAMbg4/1VIxcm3H/hs/xvd1HS3PqVKQdw5zL+UdNBBjzhpgFmjbTaR0 +wI7khI0aYxOBv6ITWG//l5bcHLb8TI1nSwuOvNUzembOQV2SPM3Dq9akJVXM/8EZUfA RIhQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1714738308; x=1715343108; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=UFTHJYThHlwOBSxcirGM7ibIn5vx8y6VcAk9r24ZxQk=; b=ELQq887PcfMuttVMiBR682C1Auw4M50dmBAGHGtsskp5YLZO+tzDFwZy8VYC22FfkM TLVxj5qomBd0CAA7kM7WNMG2Snf9Wez5lRGMMS0i4/6rDwlbRKzY9nrv+xj6SkP/O/Tc J64jFYgkoq9XnP//QMeI9YRpR+aeUb9JWHs2eFuYBcwfV/N2qWoyQXg23dIKJCl+yHd5 Ugb40wM8ucm986daHWwE2avRCBucQ5zO3B0aNPC9rHwgmh4NPI+j4Rn687JeeQmyJbEz gtDVPww0hOQrUUvs6BJOKaNyK0p8lm/E3WdrUpagq8tS7RLw1Tjoc6LLTgyUsfxDYPLZ 6Zeg== X-Gm-Message-State: AOJu0Yx+x4II/2XLW2jjGvpOO98yTjUbFpPD98eATyjZf91ICyplQ9ga o3hXcNWwYQ5c9xJM14NZMRZoVZlY1DCJXVReddVQU/p91o2XsJVrhiZYoyikW+YvTfN2ExBehHW usn3EvKy0mA+YQpriw7kuqDnxIf75uwM7pXyz5Hgd X-Google-Smtp-Source: AGHT+IHw4zfZbRL190oowTv7eFjwaawZ2sQsxDO/cZcwdTWPgAOM97Wz4KUDI9Ba785bb9DSDEXKsr9GOBoe2hXyhDY= X-Received: by 2002:a17:90a:fc95:b0:2b2:a04b:cf4a with SMTP id ci21-20020a17090afc9500b002b2a04bcf4amr2213946pjb.25.1714738307934; Fri, 03 May 2024 05:11:47 -0700 (PDT) MIME-Version: 1.0 From: Iman Bakhtiari Date: Fri, 3 May 2024 15:41:36 +0330 Message-ID: Subject: I have ansible for postgres-etcd-patroni To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000ba32f406178b9f0b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ba32f406178b9f0b Content-Type: text/plain; charset="UTF-8" Hi i have written this ansible with https://github/sudoix together https://github.com/imanbakhtiari/postgres-ansible.git This ansible needs 5 virtual machine in 3 of them it install postgresql with patroni replication and in two of them it install haproxy and keepalived finally it became so stable idea for database with a SQL and also etcd NOSQL with this single command ansible-playbook -i inventory/db-servers.ini postgres.yml --become --become-method=sudo --tags "preinstall,postgres,haproxy" --ask-become-pass i just want to share this with others and your community and also i am living in Iran right now and eager to accept job offer for emigration or any job recommendations Here is my resume https://gitea.com/imanbakhtiari/resume Thank you --000000000000ba32f406178b9f0b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
This ansibl= e needs 5=C2=A0 virtual machine
in 3 of them it install postg= resql with patroni replication
and in two of them it install = haproxy and keepalived
finally it became so stable idea for d= atabase with a SQL and also etcd NOSQL

with this single comma= nd
ansible-playbook -i inventory/db-servers.ini postgres.yml --become --= become-method=3Dsudo --tags "preinstall,postgres,haproxy" --ask-b= ecome-pass

i just want to share this with others and your comm= unity
and also i am living in Iran right now and eager to accept j= ob offer for emigration or any job recommendations
Here is my resu= me
https://gitea.com= /imanbakhtiari/resume
Thank you
--000000000000ba32f406178b9f0b--