Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fXwbD-0003ra-Sf for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jun 2018 22:38:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fXwbB-0003qQ-2J for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jun 2018 22:38:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fXwbA-0003qD-GA for pgsql-admin@lists.postgresql.org; Tue, 26 Jun 2018 22:38:08 +0000 Received: from mail-qk0-x244.google.com ([2607:f8b0:400d:c09::244]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fXwb3-00028Q-Ju for pgsql-admin@lists.postgresql.org; Tue, 26 Jun 2018 22:38:06 +0000 Received: by mail-qk0-x244.google.com with SMTP id b129-v6so28998qke.7 for ; Tue, 26 Jun 2018 15:38:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:date:subject:message-id :to; bh=dv9OqLnoUNt78MEw3Vjy60qwZJnKmcuO6QEbPAx77Ic=; b=LA5qbI/obPFRfu2Qm9M44rWX2G6pFt3oI3ZsY20WHUXsKHTN3JVhtSwsG68PHR5+N8 TmiupPaPdgrSDNqCQ0S0uQ2oac0as66cE7mHlVwzxLFeFvcc7Fg8ZdndkEGwagj6Cbuh rD5mVaQGDNuq+S3udnuMofJAP6b40CA21CBtX2jM93pO7afDLkGlPMNoDoqScZ2eA0fc vY0tfZsTB1Maz6OFZ6g0/Qm1bq5iPIQqK3WhppHP3A+jxlrnbKj/Sqj+/FB40HSWsp1C XYb7CIiMkDjq/LCls25b6teEdJxEZu5aXIR9l2dPLg62WlM4SK83rDhDmp+FHPfaEXuF rU/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version:date :subject:message-id:to; bh=dv9OqLnoUNt78MEw3Vjy60qwZJnKmcuO6QEbPAx77Ic=; b=pxYiQEejX8eRZ12we60rvnp5hMxXP0PZVmZQfO3QwX4fJdv5TAhwCSEWZgyGicV15p 6G7idJRx5qNAwjASiVzfFwD+TIpAoN70F2wCoZB1FFEKMkvfiQwR0iFla11mMHvSwH+X gyPvMLqY+F9oTEPx1YiDTYkuLBrjVtoHBqUDNk3TNHKJ+oj4pnLFUezVjz1CJ+8Xx+sA rZvniKwW4/g2kC1m8YJZ0YXEppr1gKHFif9GRGzNxe1PfWhewUl0WXO1q1j2oJjaExys pg4Q70KeIFVUCr4Q7AjBkNs+ykLBXUQhEYQxBlSObgL+2qubLd5jdZX+lEIILnuIPA1i NoVg== X-Gm-Message-State: APt69E3Xr0h5Yzea/djdhik8ZVMle/q+2Wbe0s4vxrl78qwZINC7mXDu FZey58U2NXhPsVDulAAVbPhnEll+ X-Google-Smtp-Source: AAOMgpdcs67mnxj3A8VgFvZC2+bT2RiMF5fVQ36M/IJ7wafEMUjSmvJkRQ74hn75e7+xyH3ozi07pw== X-Received: by 2002:a37:e103:: with SMTP id c3-v6mr3069191qkm.33.1530052680226; Tue, 26 Jun 2018 15:38:00 -0700 (PDT) Received: from [192.168.1.152] (pool-100-16-117-12.bltmmd.fios.verizon.net. [100.16.117.12]) by smtp.gmail.com with ESMTPSA id 43-v6sm2688168qtx.12.2018.06.26.15.37.59 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 26 Jun 2018 15:37:59 -0700 (PDT) From: John Scalia Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (1.0) Date: Tue, 26 Jun 2018 18:37:58 -0400 Subject: Upgrading 9.6.9 to 10.4 Message-Id: <8D4726EE-74E8-494B-9ED1-817EF2BB5E4B@gmail.com> To: pgsql-admin@lists.postgresql.org X-Mailer: iPad Mail (15F79) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi all, My employer is in the process of upgrading PostgreSQL, and they would like m= e to make this happen without any real interruption of service. As I underst= and it, 9.6 does not support the publish/subscribe model like 10.4 does, but= logical replication is the basis of that model. So, does anyone have any su= ggestions for how to implement the receiver side on a 10.4 server? Or could y= ou at least point me to some sort of how-to page? TIA, Jay Sent from my iPad=