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 1lmSV4-0007SV-Mo for pgsql-admin@arkaria.postgresql.org; Fri, 28 May 2021 02:45:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmSV1-0001i2-M5 for pgsql-admin@arkaria.postgresql.org; Fri, 28 May 2021 02:45:23 +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 1lmSV1-0001hq-7b for pgsql-admin@lists.postgresql.org; Fri, 28 May 2021 02:45:23 +0000 Received: from mail-wm1-x331.google.com ([2a00:1450:4864:20::331]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lmSUy-000213-6e for pgsql-admin@postgresql.org; Fri, 28 May 2021 02:45:22 +0000 Received: by mail-wm1-x331.google.com with SMTP id z130so1278013wmg.2 for ; Thu, 27 May 2021 19:45:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=ayege60LJTJZ7vU8lqVy/0a+ynJRH+zM14rlEUTzytI=; b=A/mn6sn0NNta7Etb47hF0EDftQAEtS/0fSYdeKvRnjcT1xGH410nBw0rBbuvaLPHxX lMpCybyvzNalNO5xXOSuJW2obEPilED763irD+ZHX7axpdndJxljXV15EYFWPf3jk625 VduOrhH6LSzUgTM/1Gomz8SGlzPgvkMiwfqktw04d5LQFpyagWX4AjBDmNEtfqMhlByd Ai2AXrXJRNMQwB0SQ/ha7AVRB1DPMHSar5yc2Yd2vybstWKBTAMkbY9LLJ+0I5nMpu/T FQP6vU4yCUubPPg89ZcrvQS5LQ4NiuzuEXrrj1izuFR9LugAU3pw5Y9ikOnnm+CDXJ54 duKQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=ayege60LJTJZ7vU8lqVy/0a+ynJRH+zM14rlEUTzytI=; b=fPjVww0sio42tKVag5F5/bv6i/mnnFiQqhKhmv/2Pwc7G+55kCFBksnlWvizb14Rzb DhXXk6WjBGhbdmJrgMpmBJnUmpeD6uAtibwt4FXiNgbazYiF2R7YvG7b/jJV/nrEmS7K o3W/z9d8++QhuzukbVoOg2WKDpun2pLpREY8crHvbivkt/ntRf+b7tcMEu4FxJ7dEhrz Qo7xlC2iykGy4cCfY+51dMB86TDBOdUQlkPWWdFVJw3hlmh14mWvbsiM1ylO9MilVeGr 2yyYbrZf/RljUgdkULYBQ2c7o/s4LZtLlW/G0/NqXjMBZStLtyQXGFE7u5W9X5SOnL9f kEDw== X-Gm-Message-State: AOAM531RXSj2PujLwh2xbKP96+VcC0a8my2mLfCll/Ig1NMW4aBGezx1 laesivqBqQ39t1jpaE1OPLMcyw== X-Google-Smtp-Source: ABdhPJyXnjjgBeqRtH9EFy3KSWxXkOdx3zI/n/VgvjPjgwkszrJFj+XcQjEMu1laYrMxAblzSKVBfg== X-Received: by 2002:a1c:e156:: with SMTP id y83mr10526825wmg.89.1622169918284; Thu, 27 May 2021 19:45:18 -0700 (PDT) Received: from localhost.localdomain (178-190-178-253.adsl.highway.telekom.at. [178.190.178.253]) by smtp.gmail.com with ESMTPSA id r7sm11966213wmq.3.2021.05.27.19.45.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 May 2021 19:45:18 -0700 (PDT) Message-ID: Subject: Re: Migrating local PG instance to AWS RDS? From: Laurenz Albe To: Wells Oliver , pgsql-admin Date: Fri, 28 May 2021 04:45:17 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2021-05-27 at 14:49 -0700, Wells Oliver wrote: > Anyone have a handy write-up or useful experience to share in migrating local PG databases to Amazon's RDS? Kind of a general remark: Hosting providers make it easy to move the database to their services. The real trouble starts once you decide you want to get your database out again. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com