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 1ncPIy-0004n3-Pr for pgsql-admin@arkaria.postgresql.org; Thu, 07 Apr 2022 10:23:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ncPIx-0007gH-M7 for pgsql-admin@arkaria.postgresql.org; Thu, 07 Apr 2022 10:23:55 +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 1ncPIx-0007g6-78 for pgsql-admin@lists.postgresql.org; Thu, 07 Apr 2022 10:23:55 +0000 Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ncPIu-0008TS-5L for pgsql-admin@lists.postgresql.org; Thu, 07 Apr 2022 10:23:54 +0000 Received: by mail-ej1-x634.google.com with SMTP id n6so9768517ejc.13 for ; Thu, 07 Apr 2022 03:23:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=XB2NEvYZ3vNBi3yRcJ1jJryIqDOkm1eb2LHUjl5l2XI=; b=T0P7VEjk8O3tuoRRUXBtWw66qXiMKsOyjMh/iyz3rTvkH5G7hhZjxgin4bUaUXb/IK iSd+D1YT4iEKgFdsXDC3eqrQGadpav8Ea/HiaiVBZXtvaRmLGwN+jcAooleaLsRFgeg2 rscZU0DSgXm9VKiaqEb27iR47kagXxw+sD7Oud0pHjV0X87tJ4ds0nV8EW+bglBLljnW psvM0/OqbdKk0ggJHFfo+EfR0LxGOeD1WjIEi00Lif5W8UXNzhH0BLoedkloIx33Xc5v GPef3SfwQjlv/jGJiWfqKcogU1ehsc5xWltzMAiBij8KlZWv4/a3IBqB2m2803ca9L9Q mYpg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=XB2NEvYZ3vNBi3yRcJ1jJryIqDOkm1eb2LHUjl5l2XI=; b=FV0uz6QmdiBhxFGGcIJDZTJbBj2JaNxCuv74L/bzJlyGgHEsoIc4RdxigT32MLRKpk ovPunzj1wIgYK75Bz5OqRnGH9PzrYE/sM4HsWa3giSeRxV6ZJheCiTMBQSu5LHx+eYTp USGBuwNbSiiIouc8OLM/jgznF8biTaVpHGwxbjKTrDfVibo3VedXpnrBWvTvkSOlw52T pun+adXMpDWuXHRYn7sGj8sNcfFWkXeXe7ebDNK1Facln+gliHZUmoMQSqCvjbmbbSNq MVkAwn/+kZzsLWbyIx/GFbOUa7tdB6SPXrUyxMkuSrMHfmwknX2cSUO8e7dpNoVAlV6G jDjQ== X-Gm-Message-State: AOAM533dMRoUApGiDP62P5ikWr8Fsu/ZeotMcPfRBHvRxSi2GEjJqO4J N+2wSw+k8GuNMX1+1kly0uB/fBde5aZlxQ== X-Google-Smtp-Source: ABdhPJwVslt8TKof5iRcyqcqut+LWZkX+G2jcVmfXhHQf+jgvrqb8hYVT84mCO5XKSmjxaZbd8cXqQ== X-Received: by 2002:a17:907:7f87:b0:6e8:354c:d440 with SMTP id qk7-20020a1709077f8700b006e8354cd440mr2397494ejc.761.1649327029991; Thu, 07 Apr 2022 03:23:49 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:1de5:397:ed65:99b:afff]) by smtp.gmail.com with ESMTPSA id v8-20020a50d848000000b0041cb912717asm6969129edj.91.2022.04.07.03.23.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 07 Apr 2022 03:23:49 -0700 (PDT) Message-ID: <9d8700e532a744abd3117801b4585a1ba990dbf9.camel@cybertec.at> Subject: Re: Migration data from Postgres on Windows to Postgres on Linux From: Laurenz Albe To: Dennis , pgsql-admin@lists.postgresql.org Date: Thu, 07 Apr 2022 12:23:48 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-3.fc34) 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, 2022-04-07 at 13:15 +0300, Dennis wrote: > How to migrate data from Postgres on Windows to Postgres on Linux ? I want to do the move in zero time. > Postgres version won't change. only the OS version will change. > Are there any step by step documentation about migration ? Logical replication. Yours, Laurenz Albe