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 1tn2D8-001JaZ-SM for pgsql-admin@arkaria.postgresql.org; Tue, 25 Feb 2025 21:11:27 +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 1tn2D6-008omX-M3 for pgsql-admin@arkaria.postgresql.org; Tue, 25 Feb 2025 21:11:24 +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 1tn2D6-008omL-2j for pgsql-admin@lists.postgresql.org; Tue, 25 Feb 2025 21:11:24 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tn2D3-00042T-0E for pgsql-admin@lists.postgresql.org; Tue, 25 Feb 2025 21:11:23 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-6f4434b5305so52150977b3.3 for ; Tue, 25 Feb 2025 13:11:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1740517881; x=1741122681; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:from :content-language:references:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=w64qOxdgQfZCuYeyj+Nq7qHCnZvEF9E3mfAhwYvbe8s=; b=Q/LSpgFFlM2HtHVaBcU3NlPslD6n8gNlT3VOB6xvq7no8QyroRP7LfcsWxri4xyPwB KoYmfTpAxRmKJ/BN2EcLy2y1Gg0Qi0R1dmFZKdgYu5Sn1Q3+AmQDm7k+GOXdkbUuJShp y5Ys7rRVfi2mAKr9yp66f8ill0CbRRHnlmKSS3aXXhJfA5LYMJpIl4yIZOGUoNA279EU VpdnA9L+cqjetTmQfqa6+bHAkze8lgw3371L7FAN/zd+ePbkawHX3E4z6JHc9xIu3UAI Kwgo/kN55i2e+4EDnK0ZJpy1u2diJRwAiUeWHu+xpAJaab67taxWaRuFpXLlA7Gb9gJx d7CA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740517881; x=1741122681; h=content-transfer-encoding:in-reply-to:autocrypt:from :content-language:references:to:subject:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=w64qOxdgQfZCuYeyj+Nq7qHCnZvEF9E3mfAhwYvbe8s=; b=tDBhchJMkgz8UqqJZ0Bn/k464uTI+p83c7w6yofBzvUwop0G1Blv4N5LRFtweKqkKm nWWDz+YRc2aKyrT0QI516qV1RaIwdIfAZZeKGWuWjjWRBf3tF/K4Mx+W6t2geHJIPwe8 xlCTc67uEe0cTWtuRtAGQKIAFhJC8nGXi7GwCCEhW09v0GEK/xk2dBNKin4ftCJCDCWl JHOGFU/nY+zEK3jef6f5y2KtSmVVj/gWPjUC5DvqxUca89ZKot6YZM0SGMmz2AVhWiqv RCtfX7gYtt4QUTZV4OAV1us/CmGs6Rxje1Y2Nhnph+Z5B6xX4zxD7bUhOlynq/2DDiKn vSOQ== X-Forwarded-Encrypted: i=1; AJvYcCUeRQjtLwJ7rlODjGFC0DDxUcHa049PHNFIWfVWD4sXxsUnWnaIrXLgDwcKHa/T7MSFpBBV4lZqXcxu9A==@lists.postgresql.org X-Gm-Message-State: AOJu0Ywu98wOO/LSxeSk8gLZoOm3JYpuvqQkZZuOeRzdNZYVBFAmHdkG EMrD1eMmVmPSU1U8UDV7TyTL1E1o3AVIiOF5CvZ7USX8QaVdIbeyq1xR/KlqB0M= X-Gm-Gg: ASbGncsrzTTzL8kA6yRVfohaZW1JYzvpYkL7deNyA8+NZf1PFssa6I+hzQLyptQjEBA 37fuCwKYSvKFLR9kBPDLETdSs97xczWIxFl6jTugUhkNjjMXm9Isy3ZCe4V8Q1Kgw25vP0Z4at7 HRHgrhZ8jIJHl0LI8mAo39rh9fixn7G/WhsCVSIjZDEjSONNDP1O5qEXQ0KU+jfJY6d8rzsY9dW wt6BXWSTjgh4I3BwR4oOXVZnx9L48MokvPuDhQkyG4+TLBSGM5YtpwlegMvmVPE81tPVqajAk6d ZYpUllfDDMPvudGQt4f2ZJsI/U3tm4qh4F/PtT0gJY77D8vgOvj7m3E1Ro5N3sa2TCjy8cr49PF VLBysdQ== X-Google-Smtp-Source: AGHT+IEAaCYGNAglB2SGTRJzc1NgG1t8Webot5XT6NyREqstiln27A5VYEIKeZf8Qni3eRDkwlLPIQ== X-Received: by 2002:a05:690c:6710:b0:6f9:aeee:8f26 with SMTP id 00721157ae682-6fd1088e94bmr46917867b3.0.1740517881442; Tue, 25 Feb 2025 13:11:21 -0800 (PST) Received: from [192.168.4.41] (162-239-31-113.lightspeed.dybhfl.sbcglobal.net. [162.239.31.113]) by smtp.gmail.com with ESMTPSA id 00721157ae682-6fd116896bdsm6319297b3.41.2025.02.25.13.11.21 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 25 Feb 2025 13:11:21 -0800 (PST) Message-ID: <7225c8db-be2b-4dca-8f1a-ea1cb9a4093d@joeconway.com> Date: Tue, 25 Feb 2025 16:11:20 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Hot Standby setup - collation version mismatch To: Ron Johnson , Pgsql-admin References: <4331b9ed-9d8f-4ce0-9ad1-7d18d0178230@joeconway.com> Content-Language: en-US From: Joe Conway Autocrypt: addr=mail@joeconway.com; keydata= xsFNBEpXMCsBEADDnXUQzjlyi/cX02Gtdy2CLcroE5CsC7DJKdOBDbfgn0kfiIYoV5JniG4l VyzZUodY8yUAagqLYolh0UkBzs9N+qkm7erde4ypw3jzVQ37BuzIvk3nMUbuDZDgxWqX+nVS sKc+BQ5BpzgCHg48leoRO2ohjvYnUhgH3j2rFZCzaj6qQ7mv+XoxOJmUlVQtG06Jwkk7Vu14 7U9nMMM6hyUKzVnmCphnlcMNo26UyVU70MwFfFJgcI0c5fpp8byN56eD6VJVnufO5WAuEhzE qcrSJR2FAlmM90GBY+6vP29twLDCHuSFvrnujNCx/BvCC/a3/gPvyAFp4JtMm9eXAmq3m/Kw 94nTJXVdcbQeQQDp3KIG7MmWS4lnGvPn8v0CjgNaLvZXFLo1FgmUVsyEq1Lww4iRLa6sbpXJ ESx15UEue1k1YZM9C+4F/o3aeKNsAienjw2EXFzcaxIg/C4P493VMi3Qa8ycVxR5iYhUbYdo DFIUQhbFNsYfrtW/qZAELT3FCYFpZYG01e9Hj+cBrXXgyDDkQ5Lq4mlvmkRvuxn61V6Au4HA 0sJiCox5pM1FvzT+aI8HY1BYaiB9Pl4fhpKgmhhlSuglk9v39S4jmlUIb45iLAUVpeNM6Qjm 69pf5da9sm4aGFa7YlDSKf/WcU7z9ITZxsilOi2n7YJiwG7kTQARAQABzSRKb3NlcGggRSBD b253YXkgPG1haWxAam9lY29ud2F5LmNvbT7CwXoEEwEIACQCGwMCHgECF4AFCwkIBwMFFQoJ CAsFFgIDAQAFAlWTVvUCGQEACgkQMyt+aLaZQ0oPCQ/9HyRewMyvAIJRmoXoLAr8AoFLId6R qBJnNX0Lll0RLZui65aQ0+exwX7aH7TxWR16B2gWX3OmLfGT8XITOoG+zt9zsEpLvNkHchkF T/jyAcbuRj5WX9hamZgMbjXAJeCdlhW+fRA9Upb0w4dgBjqK5OgsqMikASL7t2vogHl9H08j vSoQLW+8wTnSBXBeBTBwB7xLIin5WVivzFHUCrnD2UsjeBIW3fmGdpTAjSxRzG+UPYVwXQ8F FLt7DpEytvLWapmZWMRdj0WZ/Q3SOO/Ed0yFqbzuwKaWcFrQBNeS2Sig+FefBNS98f9Hx7ku H3DW34qX/zSSdDh0jLs7X3PkIgF6BZR2TxaCwHPP9ERDiDaUInC9U7We1iZE1DjW8rLMEVJB hY0ClrrF67pnUKTbcU+uajpPn+2Jl74T0Set/XxpHZ4cezcJuqg31R8vHZgd5cf1WKP0D0pc qiuS02BBFkNCs1jQ+raTWcDuE6F1mUO2nvjUBN9r4y5DUbCNSqLKeAe/aA6JaSDkBpoXKdNS +c4rbzbktWkfUW8EhVlCGzNpy4ezEoVsqV2Ex7fNoxsE2vnSylLT9hycAmYf8ryMvniRZqnD T4JgLenIcQlkhB896T7wApOXfD8OJj1/XFxAfPi6vdlsr81uoxuB4euLp8IyduwLORRUogO9 zmAXG5jOwU0ESlcyJwEQAOkTBb9yDhJbMUgvhM11rZwT5tm4Y9TqtEHn0Zy3t9g7bdFFpMva v/KENd3oAtLFpMDf+H3AggFk4ftUwJwiVgJ88ilvCynJUGXiuYIaexY4DLgn4xpnuiEpYEFV dWnlw7dWVTc62exfqIz9bSWRzwfBCY9ruYGEb4RDPDSNSAVyI7sxHzef2asiYxIcxrTrw5Vu gWNlPZcV5/EJ6PUvATjBF2TBkXV7KOciQng2tsQGrGMkY5mduNqwpuh6zfPcVF8LeObe96wv 5ZhPRpO79nef7hnK2lJogp3JIo558Jlbz9WHtQEMZR85+bUhtI825QyNAFz3Jrn7NMgvDikc 2OrWo7YMgMC5hDSWVFqA6/EQCNnDWGABWgeYHZFpnPwsvUWIYdhSilUuj/Tuzvz9ZmucFNbQ bauDQw6VQ38ofGnoYDZFJsGncprB8dBi4tDrIQ+1RlIh6C2Z/eMipqJOT26+spluTjouvnKT 0S5yOgyX0PjbsysgwQdCGNJLHOjhHbSpSmOLaduV3CQo/0+DHT/TBjYfIXjTWouY9TkGxG4e NrxU0u2xAy5bMqOPmsFdjLTWlQUlF/fTMhB54XwI3FHWgnSnXZzStDTmTebLNdT/ftgliAzA 81uMj49j0exv731/v+7udLA1bV8gnZ01zQCASDpWiRQR3fgwcugSUqgRABEBAAHCwV8EGAEI AAkFAkpXMicCGwwACgkQMyt+aLaZQ0pwAQ//bjcWnZg/jjRQ9gbZUGMqniItZYRglBMKIqt4 Fia379JmHwTvavnFkJ8XMZ56UB0FIrgS+sUkRH6cPRQR+7Qi392LD021DXgSsz9CwFHjFyBG HwLEOTRcfYQbtJy0shHDJB4aQTOX3ERDH1PsvJNuevmQMzS0DWFav9+xMz9rKP4N+HffoBIZ E0C1xIE43nD4eLsbycte9sVIrmlNuUti3qUxJAQw8HwfJ6ZbBInHxquApR16uD1u99o6Xlnd FrDlY22tRmHCM0bR81GfGNdcU3Uo+rG/R/k4qa7s9/dgKvMbyH3fHhp/ceKag80Xo8IFurRl 0ZJP3sHJ2QDHCVLat7jRZ+43hi1WlIhFbrgn6IyI0i7XR/W8JjrC5MsKq4TUwGH077sU/kcH YebVJZRbUUst2hAGHDFVBcG12qoKf+ltL9qXJc1y7BGeCoUW6QjOpljpq6ZL4FQUsM0RSRjs 5egE3szPcIf5SyPK6WDOApoAq6M7BBFMGDZwEylYMtr0YekA1u86UA9D2xwLHEbBBp/uiby1 c9JbPJ1Pn8zJP8WZNeRw4Q9TtqVK09+oLirMUSpIDd6KdZ1VgRxOK2re7tjDvkVuYsSrsiJ+ 1iJNEnp9iK0ok0DlJpSCe6KhkxpaTdeoWMXdKuJWec0NIqoAd54ZgBPnr+UPxTixgPq/p6Q= In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk (Please reply-all on these lists per community norms -- i.e. do not remove recipients from the To: or CC:) On 2/25/25 14:46, Ron Johnson wrote: > On Tue, Feb 25, 2025 at 2:17 PM Joe Conway > wrote: > On 2/25/25 12:47, Ron Johnson wrote: > > On Tue, Feb 25, 2025 at 12:43 PM Sbob wrote: > > >     I have 2 aws ec2 nodes and I want to setup a hot standby. > > > >     The master is running amazon linux > He actually said Amazon Linux (based on glibc version I would guess > AL2023) & Alma 8, but the point remains the same. > > Isn't "_el9" in the package names a reference to RHEL9 compatibility? Sort of. The Postgres packages appear to be from CentOS Stream: https://rpmfind.net/linux/RPM/centos-stream/9/appstream/x86_64/postgresql-private-libs-15.2-1.module_el9+264+92dde3f0.x86_64.html I don't have RHEL 9 handy at the moment to check what its repo has for Postgres packages. But the OP clearly stated they were running Amazon Linux on the primary, so perhaps these Postgres packages were downloaded from somewhere that does not match the aforementioned distro -- yet another potential issue for various reasons. Or perhaps they got their own distro wrong ¯\_(ツ)_/¯ -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com