From lists@insyde.com.br Wed Apr 2 20:21:24 2003 X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D36A9475CBC for ; Wed, 2 Apr 2003 15:21:24 -0500 (EST) Received: from ivoti.terra.com.br (ivoti.terra.com.br [200.176.3.20]) by postgresql.org (Postfix) with ESMTP id B738D474E44 for ; Wed, 2 Apr 2003 15:21:23 -0500 (EST) Received: from canela.terra.com.br (canela.terra.com.br [200.176.3.79]) by ivoti.terra.com.br (Postfix) with ESMTP id C5CFD408EEC for ; Wed, 2 Apr 2003 17:21:23 -0300 (BRT) Received: from insyde (200-171-250-50.customer.telesp.net.br [200.171.250.50]) (authenticated user insyde09) by canela.terra.com.br (Postfix) with ESMTP id 64881114034 for ; Wed, 2 Apr 2003 17:21:23 -0300 (BRT) Message-ID: <012f01c2f955$a2c74560$32faabc8@insyde> From: "lists" To: Subject: restore time Date: Wed, 2 Apr 2003 17:22:50 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_012C_01C2F93C.7CE2FD80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Status: No, hits=-0.7 required=5.0 tests=BAYES_30,HTML_40_50,RCVD_IN_OSIRUSOFT_COM version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/25 X-Sequence-Number: 8180 This is a multi-part message in MIME format. ------=_NextPart_000_012C_01C2F93C.7CE2FD80 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi, I'm trying to restore a database, btu I couldn't so far. It's taking more than 14 hours to complete, and we make=20 a valuation of more than 22 hours to complete restore a 1,5 Gb database, from a 60 mb dump. This only happen when I use the binary mode (-Fc) with plain text it takes at most 3 hours. I need this mode because of the lo types. Is anyone having this kind of problem? How long your dump/restore=20 takes to complete? What's the size of the DB? Is there any workaround? TIA, Ricardo. ------=_NextPart_000_012C_01C2F93C.7CE2FD80 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi, I'm trying to restore a database, btu = I=20 couldn't so far.
It's taking more than 14 hours to complete= ,=20 and we make
a valuation of more than 22 hours to compl= ete=20 restore a 1,5 Gb
database, from a 60 mb dump.
 
This only happen when I use the binary mod= e (-Fc)=20 with plain text
it takes at most 3 hours. I need this mode= because=20 of the lo types.
 
Is anyone having this kind of problem? How= =20 long your dump/restore
takes to complete? What's the size of the= =20 DB?
 
Is there any workaround?
 
TIA,
Ricardo.
------=_NextPart_000_012C_01C2F93C.7CE2FD80-- From rajeshkumar.dba09@gmail.com Mon Mar 31 13:42:35 2025 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 1tzFPk-00HF0Y-1W for pgsql-admin@arkaria.postgresql.org; Mon, 31 Mar 2025 13:42:56 +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 1tzFPi-005yyA-Cl for pgsql-admin@arkaria.postgresql.org; Mon, 31 Mar 2025 13:42:54 +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 1tzFPi-005yy1-1u for pgsql-admin@lists.postgresql.org; Mon, 31 Mar 2025 13:42:54 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tzFPf-002EfX-2V for pgsql-admin@lists.postgresql.org; Mon, 31 Mar 2025 13:42:53 +0000 Received: by mail-lj1-x234.google.com with SMTP id 38308e7fff4ca-307bc125e2eso40060181fa.3 for ; Mon, 31 Mar 2025 06:42:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743428570; x=1744033370; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=oiRvN+vP2rvUhRINYTumBskbCgAArj9rx1FSRX8460I=; b=D5LTLl/Ja/MItLt/WMeFYYPnfgGsPHuQWU+obVKqeL+NaVGY6V5Vp1F2ya2T8RPLcD csEk6zX7AV1cPnttyHBzvATGNeXsY+nC4rj3g4f7JLYNV8DZ85vhkPbkKa2NbOCoU+Qi 45Y8NfvoMuaC87zs1/EI/oBMGxSyZn2ptxaKMu2H2y3VUtNjdUVWjnhF5+/JzNe5maOX LNrHnx2RpNarQoQ8GaU1HQd24gdJHScv6kEFzWYELk93uuAdY9jOG72qX8moVtqU3swj QjRfpEltl0DE7AXQ/Y8mvpENiQvyUnD8vivO7mAT7ubb+osHxfuVJWgD51tvIWatuh+8 vdnw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743428570; x=1744033370; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=oiRvN+vP2rvUhRINYTumBskbCgAArj9rx1FSRX8460I=; b=UyzxbFTXLEa0Qw4fYvQh9KOEBc8QwVrbPbyg7Xppt0FrPzoUJfR75frM1R3wCArlvX 5oCfsyUkHT25Bgv2yQEadaligx12XC1JE7Dg0Reiaft9HeiVptESNHXuROW/1ObJnGmD EAUtYdn3kwpLYyYzx3Dlfm7mftGOBXOOR1xRJQ3S542OKYA1QFVe3qLxTZvwZmaLVm0m XQHp4rhqc+mIIHb6qxSJ8Vm7LuNjwDub80u7F+ILgKuDlFU2p0YzP1kGehAxUw1vn8ZS tZlCHUmHWSiA9rrDS7bUjg53fZQ0zLK8Q9M2gTsZgF4dPPnYNl5OWl9oiXHj5U3YEnwJ qqNQ== X-Gm-Message-State: AOJu0YwYx9CaZd5vmK7hchxixv7jOM+mOcUs1LtrPm8fo8KMcVrRY0a2 pVQVwTckYDS3unZuN+Zf8DFU+WflzHGA61ExQNoicrnI6QgXvenS7ES86QpHiCCAH0vuenUlFiy 20533TAA9MSYCoMBd24lcZD3sHCs57A== X-Gm-Gg: ASbGncukljCJXWnMoCWiMMf4CSN6e5V1Y4rXwldfKLP1w7Foidsi/LDeCMoSyNXcwao YdWm9UukZ5h6Fvmad8xrQGfAzdCvueXc9HPFPc71Q/jV6PtaPMgwNHJGvvKcMLG3v8ybl6fy+ol kCyzjaEErgSjwpgLOLbfX5Z+o0FA7JMni72Yt8IToaF6F7DtY/uvK6FxrtUKs= X-Google-Smtp-Source: AGHT+IG8YiP6NlpHjCi367FiiWtxB5/JkDLtpF9f0TxDHXJTwCGqoXvMvNWmYTd7GaOy9hqoMYuPKx6eXQ2jIEQucUU= X-Received: by 2002:a05:651c:1547:b0:307:dc1f:e465 with SMTP id 38308e7fff4ca-30de0279ef2mr29678051fa.22.1743428569374; Mon, 31 Mar 2025 06:42:49 -0700 (PDT) MIME-Version: 1.0 From: Raj Date: Mon, 31 Mar 2025 19:12:35 +0530 X-Gm-Features: AQ5f1JrN6DLrysOk1l8QyRmB4CeoRqG5CQWQJ2XfRD0y2PAuxXGRCqjAG6P6pyU Message-ID: Subject: Restore time To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000091b3580631a398f1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000091b3580631a398f1 Content-Type: text/plain; charset="UTF-8" I have openshift, postgres 15.6, I set up DR (repo based dr - s3). Once I take a backup from openshift cluster1 to repo2 s3 bucket, I want to use that backup and set up DR in openshift cluster2. Now, my question is, if the size of db is 300gb, will it take time to restore it or It can immediate start as standby ? --00000000000091b3580631a398f1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I have openshift, postgres 15.6, I set up DR (repo based = dr - s3).=C2=A0 Once I take a backup from openshift cluster1 to repo2 s3 bu= cket, I want to use that backup and set up DR in openshift cluster2.

Now, my question is, if the size of = db is 300gb, will it take time to restore it or It can immediate start=C2= =A0 as standby ?=C2=A0=C2=A0
--00000000000091b3580631a398f1--