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 1sck3g-00A5xR-FO for pgsql-admin@arkaria.postgresql.org; Sat, 10 Aug 2024 11:14:52 +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 1sck3e-008H2q-1U for pgsql-admin@arkaria.postgresql.org; Sat, 10 Aug 2024 11:14:50 +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 1sck3d-008H2i-Lw for pgsql-admin@lists.postgresql.org; Sat, 10 Aug 2024 11:14:49 +0000 Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sck3b-0047SQ-HF for pgsql-admin@postgresql.org; Sat, 10 Aug 2024 11:14:49 +0000 Received: by mail-lf1-x136.google.com with SMTP id 2adb3069b0e04-52f04b4abdcso4170495e87.2 for ; Sat, 10 Aug 2024 04:14:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723288486; x=1723893286; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=j6RUE0j/fxbSsB4wvs5Z7IrqApIhdP4VOh5rnpRDH+0=; b=VAPuGMnDPjsY3j6GoD3IKcHi0ZhQXaxW6B0bd7Ur0LTUjwJ4nTXOLwmQMtoedO75KM xHCSNuZpJhdIWvMhFBMMLIQg9hSbAjiK8oXjMcIN8aqdJtlqpuACcniwMdNjGV8ANaa2 e3DUIeCLOUKKKw0850ArUAtprUjHzptc/Kp3/w3+8xxX53TpjIQ/BURPfiqPzDxhlitC dW2T/NGT0rPIZht8cn1cwaLGo/LywIVLfYsjt+/9Vn9FuC6RAegVybUGCwQx6boqpNpc 58jrQwXfEEIVdwgQUrzXghlzVPhAl2/wJfW2+XhgXcMYbEV1KKfnB5L9Znp+OswQkKpM hf5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723288486; x=1723893286; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=j6RUE0j/fxbSsB4wvs5Z7IrqApIhdP4VOh5rnpRDH+0=; b=NKJ4uxYx2hMA6y5aQCzYu3AS6Sw1+oV0SduWEGg2qxq5YSG/R7U9mKxilzQiRtvrAF hh1Np12XpE374pU5YTdbIm2Acl0E8VZYUnexIwBSUEDU1sqIFQA4uN2tpHeTj26cWfjj aBVSxocHe9S6KiQYrsq7Ni+jrcMxKPy68Z98Km0fQ8kR5VtK2Fk0yZbEP6I9kCSJ6ZlW k4xAO7c6T8TEBAoC/0iz2YCtQBZwmgnxQdakZGBUOQ58a7kZeGey6N9p5kuI8vxYj7Tu t2oc20jLiFz70IqCtolnlYSf4UX6ACKcepj712EGHSyjwPJxTIjbGEJKD5Zhgwihg3v2 ZtbA== X-Forwarded-Encrypted: i=1; AJvYcCXuvqGb8mYBvohOH0u8L/U1WEvLL9GbaMHqUrE82fNqKcPsVgvOweqDMxSEMea+apAaMZAx0E5yc1VAxA==@postgresql.org X-Gm-Message-State: AOJu0YyTE8p8MCR4Rggi272+hhVDkv+NTpqNuoC0eI+rFb1wJG+8z2AS g8x2dpXYd6yTJRXWkSQEt8Hh1MLaXKedyiMneGWIpkUbDOdzg5MQJfbAGQgiloFGUQtF9YCCcON /OfTuT49lEZ8PB+NAFWXmFOAkwH8= X-Google-Smtp-Source: AGHT+IGFcxzhx6OeXguJRqzxvTGQKDrVZUz0RaROd8W0md9XBroZCVXmQQz98c0FFQDZE/qFwtNwe92RbuWUHMg7ll4= X-Received: by 2002:a05:6512:6d2:b0:530:ab68:25e6 with SMTP id 2adb3069b0e04-530ee9f42f5mr2966328e87.48.1723288485206; Sat, 10 Aug 2024 04:14:45 -0700 (PDT) MIME-Version: 1.0 From: Wasim Devale Date: Sat, 10 Aug 2024 16:44:33 +0530 Message-ID: Subject: Migration from CentOS7 to RedHat 9 To: Pgsql-admin , pgsql-admin Content-Type: multipart/alternative; boundary="00000000000001a3ac061f525ef4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000001a3ac061f525ef4 Content-Type: text/plain; charset="UTF-8" Hi All I took dump via pg_dump doing ssh from Red hat it took almost 10 hours for 400GB data including 99GB of BLOBS large objects. ssh postgres@ipaddre "pg_dump -U postgres -d DB1 F c -b -v" > /path/pg.dump Is this normal? Thanks, Wasim --00000000000001a3ac061f525ef4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi All

I too= k dump via pg_dump doing ssh from Red hat it took almost 10 hours for 400GB= data including 99GB of BLOBS large objects.

ssh postgres@ipaddre "pg_dump -U postgres -d DB1 = F c -b -v" > /path/pg.dump

Is this normal?

Thanks,
Wasim=C2=A0
--00000000000001a3ac061f525ef4--