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 1pXUV6-0006Wu-5a for pgsql-admin@arkaria.postgresql.org; Wed, 01 Mar 2023 22:00:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXUV4-0000t6-33 for pgsql-admin@arkaria.postgresql.org; Wed, 01 Mar 2023 22:00:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXUV3-0000sx-My for pgsql-admin@lists.postgresql.org; Wed, 01 Mar 2023 22:00:37 +0000 Received: from mail-qt1-x834.google.com ([2607:f8b0:4864:20::834]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pXUV1-0006K1-3N for pgsql-admin@lists.postgresql.org; Wed, 01 Mar 2023 22:00:37 +0000 Received: by mail-qt1-x834.google.com with SMTP id z6so16176344qtv.0 for ; Wed, 01 Mar 2023 14:00:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding: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=V5qqMhLTipbiupwFnbTy2zL03ublM24iYgD9gN/V4p0=; b=YMek70YB91anInI3bp7osVrtLk4L491a/qqvu1TNXT5pjDQ71Mf3nsM9MPYmxnBhfh /8fsNb/l+ByRoK62RGQFpkHb5ShzpEybVuUmZMwTLhKSgukkyJkTwDRYhTywawqtJbI4 aCDN8GDSmVAB7Y6duoNWuz+VjpNduv32RblAsKhUcMWZ42CZ9pyRlWMgQPC0mAj7WeZf KzIX43JPShEf9GAmST0IjlLTQG+ayvoXAnra+glFGJOul4gZOFnRNSo/qjnKxz03Blj0 DYlwMmU+/2bpTraaVsAj/AVPtKffn7lxTg9ifma3KtP4LTa8tWM7AInfDechgzwN2EWP yuyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding: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=V5qqMhLTipbiupwFnbTy2zL03ublM24iYgD9gN/V4p0=; b=w3tQIl4qAwPEXieA0wZ0SlpjOQY4SzbhI4DuGgYjNbkujKU3DtvByYLqmFoGJYWORg 1NRIJF+oNlMduxMO2uqX0GZ/RHPhrlQK5F98voJZrgoIVDBRQpi+zsfg8BwlBDnlU+b3 1/08BxWqXVKoVOX3em7NXotksG7DreIA/QJ5eHRY6YvElpcWfAlzZLmglk91tAaCSu7C JVr6MiSrtv1sMNBqXI9MWigYTDBe64FfGI7NBmZe/Aoh0SBdW1p1zfD77eqemg3Ko8Ks dosYpUr5A2hAyqd9Z3g/qhlgZZ9CjeqvV8bNaW0RnPP6ZTb+QHKhVmOVRut+xBAyevC+ Z0EA== X-Gm-Message-State: AO0yUKUSobYFS2nUjVQ5uaRGkrGL540m450Xy0qiI59Z+4TvXHkYJjL5 ki4qG3bl5tjzqg7AC84Fn+YQF9Xa9ro= X-Google-Smtp-Source: AK7set9M3bwRlGBkMmDjlhiH8fUuaYqQJ9vVfz60dEbJsusPa3Vmc+Ox9SXlzh4LS0v9rt6gB6KRRg== X-Received: by 2002:ac8:5b01:0:b0:3bf:b896:ff72 with SMTP id m1-20020ac85b01000000b003bfb896ff72mr13874048qtw.68.1677708032900; Wed, 01 Mar 2023 14:00:32 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id 1-20020a370701000000b007426f115a4esm9544277qkh.129.2023.03.01.14.00.32 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 01 Mar 2023 14:00:32 -0800 (PST) Message-ID: <8cf0a0b7-7980-9ad3-5998-07b6a2594797@gmail.com> Date: Wed, 1 Mar 2023 16:00:31 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Create replication read only Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron 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 On 3/1/23 12:27, Erik Serrano wrote: > Dear, > > Have information on how to create a read-only replica ... PDF, video, > etc.  I need to create a server to only make queries. Postgresql doesn't "do" master-master clustering, so it's replication methods are all read only. This is what I used to implement streaming: https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/ -- Born in Arizona, moved to Babylonia.