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 1kcUOE-0004HQ-TZ for pgsql-admin@arkaria.postgresql.org; Tue, 10 Nov 2020 14:12:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kcUOC-0004IR-QN for pgsql-admin@arkaria.postgresql.org; Tue, 10 Nov 2020 14:12:52 +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 1kcUOC-0004IK-Ic for pgsql-admin@lists.postgresql.org; Tue, 10 Nov 2020 14:12:52 +0000 Received: from mail-oi1-x22a.google.com ([2607:f8b0:4864:20::22a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kcUOA-0008VS-AM for pgsql-admin@lists.postgresql.org; Tue, 10 Nov 2020 14:12:51 +0000 Received: by mail-oi1-x22a.google.com with SMTP id t16so14426395oie.11 for ; Tue, 10 Nov 2020 06:12:49 -0800 (PST) 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=8VjjWnNj7Ps7G7Q5mY2lqIYvAXl5tbciem6thH0EHQ4=; b=Le4Ry4Q7a6IvjyLF/DqEA9SxxEGFN177qmCZhdP4oAixfyAS+OW9EGG3UtmBYq8V/n 8sxm/Xmg1iCG7kuA4xWTI6qFjzDQvdTvtREdvDTRi76BUY3c4c3S+9ffpcTVM74h7GVw mjY0tcTYaD+JhBmkWFkSyMnjRdVBQLZTy57inctaF1hSV16k1dEM5QL3esz2lu5jB/ga nPlj26+azPkHYgLyY9u4GJI21zbO5xgttN/07u3X9MPcnN+5HNwoqb7h8An0SlpdF22P A4EZDq7DUctwKyON1uMM0F9kTPH/DiKDdXcmfYw+x8q5yKVUfaSvZ8ADcOAOPb9O7+F4 Dqog== 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=8VjjWnNj7Ps7G7Q5mY2lqIYvAXl5tbciem6thH0EHQ4=; b=bAxj81CXrE7WM0XMRGTm0yhV6EtU672DLOfxBRbnTlvwgfK4Mu6FTkjgUTHc/B/ay8 5gwocBJAD/vneXBJYwA+vQrNnmspGiq631MLm+iOVKHnzvIUpT6fqrtumsgYdnL+P1g3 sNShVixbJWrrapPjQeXRoWtmye2qt/hoZNxplg3Gkug1dBzT5iiE/aXsTSA3lRVuUH+V H2wMweMcbXkr0u0bfuCI9qD7VY9Gg/gBU74stTmpfO2YBS1wtTJ7DZ9sdrSEmjD25m58 j7SYl6Fsx0mWafsXaA2NaUKGLhoBuvB84zLwmWIDVMStxv4Y4OdTEzG3NjInp9pzNDDk +B0Q== X-Gm-Message-State: AOAM530c1SBenCvRWrs5Rtbjm8pYbZSvUOksfFTvatc/dNyObNNxymFl AmpQ+TCrS122RTdEsiYkQkRYIHER7HMMnw== X-Google-Smtp-Source: ABdhPJwozdIGKdGJiyYHAyyCaBpByoYPyeBAwLzcr0iD3gU5+qDhdyUd3rKUzi6yTr3oiJX2KHqmHg== X-Received: by 2002:aca:59c3:: with SMTP id n186mr2758596oib.149.1605017568470; Tue, 10 Nov 2020 06:12:48 -0800 (PST) Received: from [192.168.1.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id d26sm3141122ooh.19.2020.11.10.06.12.47 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 10 Nov 2020 06:12:47 -0800 (PST) Subject: Re: Move database To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <5ee9079e-00ee-f959-b4e7-f23c30ba5716@gmail.com> Date: Tue, 10 Nov 2020 08:12:46 -0600 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: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 11/10/20 7:48 AM, Yambu wrote: > Hi > > What is the best way to move a database from one VM to another without > losing records from updating applications? > > regards How much downtime can you suffer? Are you staying at the same version, or upgrading, at the same? -- Angular momentum makes the world go 'round.