Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMRkO-002QNN-J4 for pgsql-admin@arkaria.postgresql.org; Thu, 20 Jul 2023 11:23:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMRkM-005OIe-1P for pgsql-admin@arkaria.postgresql.org; Thu, 20 Jul 2023 11:23:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMRkL-005OGD-KH for pgsql-admin@lists.postgresql.org; Thu, 20 Jul 2023 11:23:01 +0000 Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qMRkI-000dUV-9e for pgsql-admin@lists.postgresql.org; Thu, 20 Jul 2023 11:23:01 +0000 Received: by mail-lf1-x12b.google.com with SMTP id 2adb3069b0e04-4faaaa476a9so1041492e87.2 for ; Thu, 20 Jul 2023 04:22:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689852177; x=1690456977; h=content-transfer-encoding:disposition-notification-to:subject:from :to:content-language:user-agent:mime-version:date:message-id:from:to :cc:subject:date:message-id:reply-to; bh=GyB8+og6AOU+fQZ1KD+LzEVYu3gJp6FwQp0UK8ogFDI=; b=bUY+J9OK1Ny7Tj2jAVQ488HVUc3AKF+yqZjRP8DKONRHNw9QTDiVwMLs64WTxsip3q 8pb45wHDbETuWzvFodQPOGSYFZ8YSPCLFLKHw0C04zemK+cjcPA9CSWoAc+XNvabCxYq 1SUTwM7AbDPmXm9fiCjs4MQwb69+MqhWYpW0LCNaMBgJq5BXgpv22Dagd4PRhiNJvNtv V5PVVNRFDY3w6MTdIF9jS783CqLYxBSm8OQcB+lGWyAzddflhTZ8x5D4lgDyZHH6DPAb oYJfsdygkOGeAHnCnvWvCj8FHhKOe3PCiTXV2SLvpkRvjOge6xtOWxE2TsTa4KHSlg43 2H9g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689852177; x=1690456977; h=content-transfer-encoding:disposition-notification-to:subject:from :to:content-language:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=GyB8+og6AOU+fQZ1KD+LzEVYu3gJp6FwQp0UK8ogFDI=; b=cObDfgwduN0lT9R5pexfGKR7rV3J+9j3opgxn6ozvLpACFyv3dPgdh/J9i5hk6/jD3 gnkeXLYM+JFDIdEnDvImHk3s6GYKmfTzbRCRave3S9MQuMMxI+VV8KjYSlPxK/Ot/Vgp 78DqaeKHpMDGKtkn6QRVehTIDr4Behs11TSvstBXW+AYhfFFYcUGITpGTO1tUps2qdba yAOm5yXHfVWh6sz4Rk8cdH1oSo3xx+jHA02rMRXPyO6CaviRvbGmUu7wGz8X/pZjeaqd HEcCkgafPyrA+a+zcBnMHmlORGrytOw+alNnxJAra/zyqIucBDJqUv0kzx2GF1XaWUCK ZIMw== X-Gm-Message-State: ABy/qLbD+thtI2x+W+b3lx+22WkKN87VvT5/vPpRKN8ryJjeXPYeUidD Cqf+7z/eJ5b4BTFlj0prwjWa4DNWjuA= X-Google-Smtp-Source: APBJJlHJev65ghAIzqJi5NTp1QoFZmdxIrmbJfLomsgtn0H7oEGtOZLoY5G4ESJ+BekFNClb2ps2dw== X-Received: by 2002:a05:6512:461:b0:4f9:5a0c:85b8 with SMTP id x1-20020a056512046100b004f95a0c85b8mr1515411lfd.36.1689852176832; Thu, 20 Jul 2023 04:22:56 -0700 (PDT) Received: from [10.1.1.193] (94-224-49-27.access.telenet.be. [94.224.49.27]) by smtp.gmail.com with ESMTPSA id 9-20020a05600c248900b003fbb618f7adsm949396wms.15.2023.07.20.04.22.55 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 20 Jul 2023 04:22:56 -0700 (PDT) Message-ID: <3901e0da-819b-5b6d-bb57-c29f6d384725@gmail.com> Date: Thu, 20 Jul 2023 13:22:55 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: nl, en-US, fr To: pgsql-admin@lists.postgresql.org From: Jef Mortelle Subject: Upgrade from PG12 to PG Disposition-Notification-To: Jef Mortelle Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, I want to upgrade from PG12 to P15. I use /usr/lib/postgresql15/bin/pg_upgrade -v -p 5431 -P 5432 I takes a lot of time, more than 6 hours Log file, al lot of  lines pg_restore: executing BLOB 1 Looking at the dump file: man many lines like SELECT pg_catalog.lo_unlink('100000'); I have the same issue with /usr/lib/postgresql15/bin/pg_upgrade -v -p 5431 -P 5432 -k Whats going on ? Kind regards