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 1qnh0Z-00BgQD-Es for pgsql-general@arkaria.postgresql.org; Tue, 03 Oct 2023 15:08:23 +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 1qnh0X-006cEI-M7 for pgsql-general@arkaria.postgresql.org; Tue, 03 Oct 2023 15:08:21 +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 1qnh0X-006cDq-AS for pgsql-general@lists.postgresql.org; Tue, 03 Oct 2023 15:08:21 +0000 Received: from mail-yw1-x1130.google.com ([2607:f8b0:4864:20::1130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qnh0V-007zsB-1a for pgsql-general@lists.postgresql.org; Tue, 03 Oct 2023 15:08:20 +0000 Received: by mail-yw1-x1130.google.com with SMTP id 00721157ae682-5a4e29928c3so8376737b3.1 for ; Tue, 03 Oct 2023 08:08:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1696345698; x=1696950498; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=VPubqNKgfo0muzibXljAtjfV6elY3/hqNnwawfwUVgk=; b=GbKQ/l000rT4SqLXvSOxAvr4LypRnzf+Se1/jbXEefhauu1c3Ahhl34LBP5wthgrLy Nova4wLnwmviT1AkSEEAnmYYuvWe5BsZWXP0qJgNh4HF9PGfZ0jkFf1AQyIcyxyxDHyw FFg9SQ0LwGSg3bbQlpeMd8k/GIwIjWXv7S8sv39I22mh/pWTNVEpHMXm8UmPq/uFSX8h 7R7e9BEh5DLunaPbINKqi8nSeVamlOchjDSbuAueRqMC1ZLEzL176kxFv9hgrjPsdPFD hQLzPkd2nPPA+wtdywoH644GAs3kwrgFb76+/uiYGt2BXfNfTGa/nWoG+ep7lr1n55L0 GBvg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696345698; x=1696950498; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=VPubqNKgfo0muzibXljAtjfV6elY3/hqNnwawfwUVgk=; b=EH27TkIb6MfgkYleuloOkK9j8ugiWyR+VpALz9MjclElupYuWs5q7DZ0Yvn+zoyR2T rmTbmz6nGL5uwg7IdL+JPbLo/hQbNxylaX/tTu7diGo8QBPyL6YjxKIni4B8XhbCxrLq a0JpnWjQByz0lhVa2z+hh210tTTutRqvyFNLnK1TXuW1hPzsQw+BzktQtcnG/OrOd7te E7Ae92QVvjB9KNiaRL2quD7fBiqom4vgu7x/wUXjwpwxNUIlfzHdVVGFJZM8O91INUXJ UutXvsg71uZ2hYtMeMNTW6YdoBJdyK5jRbKG74FJxO+q+gbvVNTG82/oOYUK30Ue8SNb MQew== X-Gm-Message-State: AOJu0YxuLzWknx8+JqVbsxsKThD/Y+S6ffmZWj53AiuXJ+OGWy8pLlHE XSVRjrbvxBYnMwVtJaP+3o8gP021R/A= X-Google-Smtp-Source: AGHT+IFJU7h7wGcgvmByvjijKVjQCZ2e/DheKa4L/miEpuhiKlOzsdh8HyPYq6wLCwsgu/nBkdOWDw== X-Received: by 2002:a81:ab46:0:b0:589:f445:19e with SMTP id d6-20020a81ab46000000b00589f445019emr14832007ywk.27.1696345697946; Tue, 03 Oct 2023 08:08:17 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:a9ff:8e0:a7ce:5aa0? ([2600:1700:bd2c:b810:a9ff:8e0:a7ce:5aa0]) by smtp.googlemail.com with ESMTPSA id w9-20020a0dd409000000b0059511008958sm433376ywd.76.2023.10.03.08.08.17 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 03 Oct 2023 08:08:17 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------LQRymUGN9stivSqpCAXJ6MGr" Message-ID: <5f7267fe-de7f-7e94-eed3-88d385099cea@gmail.com> Date: Tue, 3 Oct 2023 10:08:17 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Problems starting slave Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <1134928812.1852960.1696343838608.ref@mail.yahoo.com> <1134928812.1852960.1696343838608@mail.yahoo.com> From: Ron In-Reply-To: <1134928812.1852960.1696343838608@mail.yahoo.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------LQRymUGN9stivSqpCAXJ6MGr Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 10/3/23 09:37, Douglas Reed wrote: > Hi the full pg_basebackup command was; > >     pg_basebackup -h 172.110.6.5 -D /var/lib/pgsql/12/data -R -U postgres > --wal-method=stream I get consistently successful results in v15 using this set of commands (where the service options reference the primary server in .pg_service_conf): psql service=primary -c "select pg_drop_replication_slot(slot_name) from pg_replication_slots where slot_name = 'pgstandby1';" /usr/bin/rm -r $PGDATA/* pg_basebackup --dbname=service=basebackup -D $PGDATA --progress --checkpoint=fast -v \         --write-recovery-conf --wal-method=stream --create-slot --slot=pgstandby1 --compress=server-zstd pg_ctl start -wt90 zstd compression might not be supported by v12. -- Born in Arizona, moved to Babylonia. --------------LQRymUGN9stivSqpCAXJ6MGr Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 10/3/23 09:37, Douglas Reed wrote:
Hi the full pg_basebackup command was;

    pg_basebackup -h 172.110.6.5 -D /var/lib/pgsql/12/data -R -U postgres --wal-method=stream

I get consistently successful results in v15 using this set of commands (where the service options reference the primary server in .pg_service_conf):

psql service=primary -c "select pg_drop_replication_slot(slot_name) from pg_replication_slots where slot_name = 'pgstandby1';"

/usr/bin/rm -r $PGDATA/*

pg_basebackup --dbname=service=basebackup -D $PGDATA --progress --checkpoint=fast -v \
        --write-recovery-conf --wal-method=stream --create-slot --slot=pgstandby1 --compress=server-zstd

pg_ctl start -wt90

zstd compression might not be supported by v12.

--
Born in Arizona, moved to Babylonia.
--------------LQRymUGN9stivSqpCAXJ6MGr--