Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1otKg2-00065B-Qg for pgsql-general@arkaria.postgresql.org; Fri, 11 Nov 2022 03:25:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1otKg1-0005p1-Lu for pgsql-general@arkaria.postgresql.org; Fri, 11 Nov 2022 03:25:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1otKg1-0005os-79 for pgsql-general@lists.postgresql.org; Fri, 11 Nov 2022 03:25:57 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1otKfy-0000ha-QH for pgsql-general@lists.postgresql.org; Fri, 11 Nov 2022 03:25:56 +0000 Received: by mail-oo1-xc36.google.com with SMTP id x6-20020a4ac586000000b0047f8cc6dbe4so510261oop.3 for ; Thu, 10 Nov 2022 19:25:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=6B3/8pNehtR3CBMeBYaqrblGBwvC/Owx4IgZHLaruE8=; b=QhB0Kc6Rv7IG4rclUX0W/ny7DutI44icNGyf3zYHiieEHgZnOJnGcMgJKR12CO9z51 jhvOB5RkcySa8GLb+3ucypdMu3Qr1mROqc/mpZisJbP77kIB2IJ/PPLWCRIA63OXzI4N agXApGJIoq5cBayZSB0WhsGwJyoJiobqLFhfCdLEEljRLNWZKTzv4SGY14Vsv2Hwd9By zMndrzUmmdxPMEv0z0BLquYVA/R32AJM85W9JLnaYLRBvG2qjKInlbo2q8eauKm5YzY0 2+IaQ7a0+WhcEkqf+e8+NaIcrrcEvfQzE0TFZiB2TgQh2SsN1S+avSk0SBsSzcI0xBDS DvsQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:cc: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=6B3/8pNehtR3CBMeBYaqrblGBwvC/Owx4IgZHLaruE8=; b=hwFy8IqQEtPynydBTr4mGn+l9jKj/7ZN9TQ6FZcA9EbDeo/V22xvVzF1yNOsU50/Vd ZO/nHSboeOgoU1UPomy4z+SPNe26ASmidbE7lMLLAcIBh3GfQcAPjFmzpLPCbrR7kS9y 94jh4y7BLmWxfpNiALu4NlM1pr6cipbRPAfsa2ouJ4R5+NfbUBDg3UaZBO6h567kdL9w 105Dq7coAjCL05It/DhekxmydZGB8EvBVgUeIGmLIU1Y/wxj7ZrJQlvwrwfTJeXMUTbw tdiddlD7f9GzrzVEO1k5C1lfSkgPJjH/GgnsGJkDy1I3fOnFxbwtgmCtVQ3tu5N2wbWp TO4A== X-Gm-Message-State: ANoB5pkwR2t0iCpFoRE7Hn9Rs/yrnk6+lrfckToqIVY8RrYbNWtJyArl ymcOyPnDTfCnKPT6nYmFVuHvYAFcJ5U= X-Google-Smtp-Source: AA0mqf57iMLU/z3ShV9qY6llxBRieqhO9gc71MtODxtjc/Yvel6SRkIr9RhPTo53wypSLVJLGLe3pg== X-Received: by 2002:a4a:e2c3:0:b0:480:7fd1:1875 with SMTP id l3-20020a4ae2c3000000b004807fd11875mr86021oot.24.1668137153603; Thu, 10 Nov 2022 19:25:53 -0800 (PST) Received: from [192.168.254.71] (h244.184.30.69.dynamic.ip.windstream.net. [69.30.184.244]) by smtp.gmail.com with ESMTPSA id bu7-20020a0568300d0700b0066cf6a14d1asm584358otb.23.2022.11.10.19.25.52 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 10 Nov 2022 19:25:53 -0800 (PST) Content-Type: multipart/alternative; boundary="------------JD7AACQFgFDSkXOwIiNlVQKe" Message-ID: <1995501f-a7f3-9459-2412-dcfdafe9ac41@gmail.com> Date: Thu, 10 Nov 2022 21:25:53 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.0.2 Subject: Re: Setting up replication on Windows, v9.4 Content-Language: en-US To: Ian Lawrence Barwick Cc: pgsql-general@lists.postgresql.org References: From: Brad White In-Reply-To: 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. --------------JD7AACQFgFDSkXOwIiNlVQKe Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit From the error log:      FATAL:  hot standby is not possible because wal_level was not set to "hot_standby" or higher on the master server      HINT:  Either set wal_level to "hot_standby" on the master, or turn off hot_standby here. I tried setting hot_standby to off, but that didn't help. I set the wal_level to "hot_standby" and hot_standby to on, and now it appears to have made progress. The service starts up without failing. > check if there's an entry in pg_stat_replication on the primary. No. No entries. There is now an entry on the primary. But still can't connect from Navicat on the primary server and the log says     FATAL:  could not receive data from WAL stream: server closed the connection unexpectedly     This probably means the server terminated abnormally     before or while processing the request.     LOG:  record with zero length at 6B/63000090     FATAL:  could not connect to the primary server: FATAL:  the database system is starting up     LOG:  started streaming WAL from primary at 6B/63000000 on timeline 1     LOG:  startup process (PID 3368) exited with exit code 1     LOG:  terminating any other active server processes ¯\_(ツ)_/¯ --------------JD7AACQFgFDSkXOwIiNlVQKe Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
From the error log:
     FATAL:  hot standby is not possible because wal_level was not set to "hot_standby" or higher on the master server
     HINT:  Either set wal_level to "hot_standby" on the master, or turn off hot_standby here.
I tried setting hot_standby to off, but that didn't help.
I set the wal_level to "hot_standby" and hot_standby to on, and now it appears to have made progress.
The service starts up without failing.

> check if there's an entry in pg_stat_replication on the primary.
No. No entries.
There is now an entry on the primary.
 
But still can't connect from Navicat on the primary server and the log says

    FATAL:  could not receive data from WAL stream: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

    LOG:  record with zero length at 6B/63000090
    FATAL:  could not connect to the primary server: FATAL:  the database system is starting up

    LOG:  started streaming WAL from primary at 6B/63000000 on timeline 1
    LOG:  startup process (PID 3368) exited with exit code 1
    LOG:  terminating any other active server processes

¯\_(ツ)_/¯
--------------JD7AACQFgFDSkXOwIiNlVQKe--