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 1lmO2X-0005z2-FC for pgsql-admin@arkaria.postgresql.org; Thu, 27 May 2021 21:59:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmO2W-00008e-FS for pgsql-admin@arkaria.postgresql.org; Thu, 27 May 2021 21:59:40 +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 1lmO1V-00019l-Vo for pgsql-admin@lists.postgresql.org; Thu, 27 May 2021 21:58:37 +0000 Received: from mail-ot1-x333.google.com ([2607:f8b0:4864:20::333]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lmO1Q-0006Ot-Jx for pgsql-admin@lists.postgresql.org; Thu, 27 May 2021 21:58:37 +0000 Received: by mail-ot1-x333.google.com with SMTP id 69-20020a9d0a4b0000b02902ed42f141e1so1677270otg.2 for ; Thu, 27 May 2021 14:58:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=01p1j12Iq8ZM3GToiJHyuPicKZ3wPskzaVX6wI4uGFY=; b=aqRHrBlxCsQFn/ezMx0vpb89tRs3NMgfh5WAZdmz+yVbgnh3fRf7xGB4w8qc9ywX4Y kexKQnef6QwhngTpC8fct8yfCjue3kvfpAWv1o2FoSue0FY+cggNt39vw3K+tCCoU/gK SEzpfV/z1xaPAybaIyTCG5xXZ9QnDnr2DlCDCG6eFpW4Kk0WeNoaAYRifp93EGZLEyvq AyQXKfUHlOOlE99saj9fbu7SqDQ9Go3CDQYHbO42/8id7dOmv3/b3UX2EvKxwjJwXq57 YArATCGtrNR39MOhuONesyuZqyDQgi170i4T8LG6k7xucJWhm0VRt419FYjMhCBq6ncP v8rw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=01p1j12Iq8ZM3GToiJHyuPicKZ3wPskzaVX6wI4uGFY=; b=XVQ+3/nsbrY3A1/bAJcFu6siYAZuzAChQP71zBFoczcAlr6Jg+JB8d1wmExg6fsoY8 8dALidFNV9Yst7eqt6OuG+y77VRQF5bNGVjEMw3RG1HDFBLTyV2tbBegismOkWzKSs9X 2qRKTVewyC+7DiJrdLx7NuOdgXkD78iwUuJCXYAk8fjaz1lKOtRrwkE7E7p7jJYA3qbO nIihFDrPn65yZDG2+8hnmIR50tlnzRbrpZROWePeoisQVp2iwSJwSJwT7Xf3GU/SjdYH uDPYm0FiGEnkv7jUv83rHSSPtEp5LctGhQ24jdrTZRKj12cEyfhTD65edHdzwdeUvpLM buqA== X-Gm-Message-State: AOAM53124eJxTGyvv6K7TjjEgjKT3d0FvRPKeJXpJ+DOxBPzqrVdEyDs wwthK4pxFj0XEujMXBorWEk1OUHHN8u/Mw== X-Google-Smtp-Source: ABdhPJyYxTDVOoCxgMnxACkQgNglMLE5j/ZEWsbwChEmdFECjMCHnysWBjM/afHaNuGSd3FQMWx7LA== X-Received: by 2002:a9d:4a8a:: with SMTP id i10mr4380564otf.282.1622152711515; Thu, 27 May 2021 14:58:31 -0700 (PDT) Received: from [192.168.88.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id h4sm700294ooq.6.2021.05.27.14.58.30 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 27 May 2021 14:58:30 -0700 (PDT) Subject: Re: Migrating local PG instance to AWS RDS? To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: Date: Thu, 27 May 2021 16:58:30 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/27/21 4:49 PM, Wells Oliver wrote: > Anyone have a handy write-up or useful experience to share in migrating > local PG databases to Amazon's RDS? > > I was thinking of making a failover in RDS and promoting it after > replication or something to that effect, but I thought I would see if > there's some more canonical approach. What version? -- Angular momentum makes the world go 'round.