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 1qvaIq-00652N-UP for pgsql-general@arkaria.postgresql.org; Wed, 25 Oct 2023 09:35:53 +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 1qvaIp-001Fgb-L9 for pgsql-general@arkaria.postgresql.org; Wed, 25 Oct 2023 09:35:51 +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 1qvaIp-001FgS-AJ for pgsql-general@lists.postgresql.org; Wed, 25 Oct 2023 09:35:51 +0000 Received: from mail-yb1-xb29.google.com ([2607:f8b0:4864:20::b29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qvaIm-002DYQ-ED for pgsql-general@lists.postgresql.org; Wed, 25 Oct 2023 09:35:50 +0000 Received: by mail-yb1-xb29.google.com with SMTP id 3f1490d57ef6-d9fe0a598d8so2546920276.2 for ; Wed, 25 Oct 2023 02:35:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698226547; x=1698831347; 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=oz1N/MxppJ1q4JpjteUeuINQ4zkcFPrsZt//POEaQcI=; b=cc51M0S1FVllUFvU8CTIGNxB8gwMAHWOdtjO75S3Ys8pKKwo3zvP2trlHWzh0ceIsC o1PJY+kM3/yMjX/RI8WDrfm40nbzRZO23aOvNFmUO0VuHa29GLYS5bFWWngFBLPEhdQu anVpgisXeK3/OQSvmVHi6Ei18Yv2oExPkx8p+diinBth+SwQkbZ9eVAWuUSgbewpytuO u86GpDrcvZn/NUXif1Ld2bHNCqVpSZ08d5UzgWlSoTUkXN19Ub2Z5T5mu6L/Ijs6ekqs GdDYMAxhbSEgo89LIu8oCxl2/9r+tQWlaOwBWJKT44u5deRX4mDyHo8SV0ShGumOTdGO ++HQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698226547; x=1698831347; 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=oz1N/MxppJ1q4JpjteUeuINQ4zkcFPrsZt//POEaQcI=; b=qpxr5eSM9u4IygqWCp/2V/XdpTbLgdEVv3/QvMGreolXUt7vi41SYoOdEQQkRyFcl/ 05hZ5kPci+F/iZd0MEgXpgZcufXQAOhzZt6QUAftYyb3gVkBqnVRSAxmgxhgsaSRkhGd M346MWRqdT9xk/A8egc8gp8c4bPXNHCqxTWeQNUlEmzmKxCcapQ1uRvYDr8UbzCNQLqd 4OxKNb1eIQZ8KU+cuUnlG8c04CyIU8FUqy27pgMaFOTh8hpcQv4iJhmPrKlRpfwC4uMC qPSrzbo0IHuVeYaQ252l9976uwP9BABGMIKZEf6ozpVRDA/REZT6yMeVk2tCKFVo6Lan XcgQ== X-Gm-Message-State: AOJu0Yz0T/KfsImHbJmhFrFbo+/rTPsmKgqbwFFjsfp8ZX2jgkbnROYV HOfUEszsfuT8fmtGuxno5o9OrEdQBrM= X-Google-Smtp-Source: AGHT+IEf7JoCWHAClrlWVYDHIePT/kugxlxHCefDaj+vLSsy5mTm4uoVeaF6XvKYXOl6CqERQDTLXA== X-Received: by 2002:a25:ccd4:0:b0:da0:7106:a159 with SMTP id l203-20020a25ccd4000000b00da07106a159mr1359599ybf.8.1698226547192; Wed, 25 Oct 2023 02:35:47 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:990b:551:8028:180e? ([2600:1700:bd2c:b810:990b:551:8028:180e]) by smtp.googlemail.com with ESMTPSA id w31-20020a25ac1f000000b00d9ab86bdaffsm4310692ybi.12.2023.10.25.02.35.46 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 25 Oct 2023 02:35:46 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------bzp5PcizmxfrFOOlMH5rigmX" Message-ID: <383c243b-9470-4744-96ad-0e42f6e44a99@gmail.com> Date: Wed, 25 Oct 2023 04:35:46 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: setting up streaming replication, part 2 Content-Language: en-US To: "pgsql-generallists.postgresql.org" References: From: Ron 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. --------------bzp5PcizmxfrFOOlMH5rigmX Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 10/24/23 23:47, Brad White wrote: > > On Tue, Oct 24, 2023, 9:02 PM Ron wrote: > > On 10/24/23 19:29, Brad White wrote: > > I have the replication server set up and the streaming is working. > > The latest data show up, as desired. > > > > 3 minor issues. > > > > > 2) I have the connection string set for the replication server to > connect, > >      primary_conninfo = 'host = 192.168.1.112 port = 5433 user = > > {pg_rep_user }password = {password}' > > But the log file shows > >     LOG:  waiting for WAL to become available at 2/A10000B8 > >     FATAL:  could not connect to the primary server: connection to > server > > at "{IP}", port 5433 failed: fe_sendauth: no password supplied > > But you said that streaming is working. > > Yes,  I realized after I posted that this would be confusing. > > I cheated and changed hba from password to trust until I get this > resolved. Not a long term solution. > > Having replication working was more important in the short term. Follow the tecmint link in my original email. https://www.postgresql.org/message-id/7a9570a6-07a9-4b41-b419-b4a0aa67fc53%40gmail.com It worked perfectly for me. -- Born in Arizona, moved to Babylonia. --------------bzp5PcizmxfrFOOlMH5rigmX Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 10/24/23 23:47, Brad White wrote:

On Tue, Oct 24, 2023, 9:02 PM Ron <ronljohnsonjr@gmail.com> wrote:
On 10/24/23 19:29, Brad White wrote:
> I have the replication server set up and the streaming is working.
> The latest data show up, as desired.
>
> 3 minor issues.
>

> 2) I have the connection string set for the replication server to connect,
>      primary_conninfo = 'host = 192.168.1.112 port = 5433 user =
> {pg_rep_user }password = {password}'
> But the log file shows
>     LOG:  waiting for WAL to become available at 2/A10000B8
>     FATAL:  could not connect to the primary server: connection to server
> at "{IP}", port 5433 failed: fe_sendauth: no password supplied

But you said that streaming is working.

Yes,  I realized after I posted that this would be confusing.

I cheated and changed hba from password to trust until I get this resolved. Not a long term solution.

Having replication working was more important in the short term. 

Follow the tecmint link in my original email. https://www.postgresql.org/message-id/7a9570a6-07a9-4b41-b419-b4a0aa67fc53%40gmail.com

It worked perfectly for me.

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