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 1qvKtj-004at6-Nw for pgsql-admin@arkaria.postgresql.org; Tue, 24 Oct 2023 17:08:55 +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 1qvKth-00AJr6-KQ for pgsql-admin@arkaria.postgresql.org; Tue, 24 Oct 2023 17:08: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 1qvKth-00AJqt-9K for pgsql-admin@lists.postgresql.org; Tue, 24 Oct 2023 17:08:53 +0000 Received: from mail-yb1-xb2e.google.com ([2607:f8b0:4864:20::b2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qvKtf-002UqH-Cw for pgsql-admin@lists.postgresql.org; Tue, 24 Oct 2023 17:08:53 +0000 Received: by mail-yb1-xb2e.google.com with SMTP id 3f1490d57ef6-d9ac9573274so4325305276.0 for ; Tue, 24 Oct 2023 10:08:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698167329; x=1698772129; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=9epi1tYvqeiZ9We2FmR7ZaD1kU/gwkCfwLgGHuRCZqY=; b=kONYCBcC85nF0+aqZ4DRic45QNSzP2fKfsk4AfbRfby5HVcSDBaEvmIid8bKJIqXF5 Rlzz8NOP1bTtEWBGsGvp99JQWMbft21wiOkZ9L7+YDcVoNoCpLPaLi0VXiOIIJnxwTaf a54qnfRVx1ZE0t4Dh+OHY5QCuVNc5BfVToyr8rgsdYuxY1Grehk4YB2DcwJEtwd+mWB1 5EMu5mOU3uycRgQ3ezuKEOE24+GgKPwPV+sJwk87bhFrvSN29SI3ST8YzjE7+fVRBvPX D8FKxHhjfxel/pLDvO7f7YI303uc9vAHXh0le7vMqAXZJ4jOSj+SJy2HhFXX01KVOdYY TsVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698167329; x=1698772129; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=9epi1tYvqeiZ9We2FmR7ZaD1kU/gwkCfwLgGHuRCZqY=; b=sKS9opsrDSbc8IK8iX5CKMe4PLZgYtP5V6tRxKJ/s0i2qGRJwc2ZjrRlqqcCF7ZwBw +VgIRqK1JsD8Klhs7fZKhmn23rvOIoM1iqovcb0IT/KTvfloLj/Gm0n/XdqyyQkWMPyD lZymPCGXhgI1sAdjk48f/yYbxMKfY0UP+k6lUaosAmiR1VhaIVy4uKQZY5xE9doNalo/ pz2y1fnvE4om07ZZiYBxF2GZmqgatsk9sdke+hLSPRxGMv9NpdM/TzBrd9HYWo1M1VKb qp+otNJRIOgqCJ4ZKA65pgPYueEbbqObqBNCJwfeYU5J1LZqWu5/zWbCj7jwxwMqszjC 5mtg== X-Gm-Message-State: AOJu0YyrYRv7s6Wc56yVS/q0S3HSWQo8/QsUIIjamj3R+Ay9OjdOoZNz rA56VOfrxhehRQb1SM7sHdq6MvTceYo= X-Google-Smtp-Source: AGHT+IFum4bTJ97lcPL6ucCcbDafMR91I77I6q2EfviUgvpEWFQFDBmUpZX5BT+yIYtwuLY7WS3jsw== X-Received: by 2002:a25:ab45:0:b0:d9c:28df:87e3 with SMTP id u63-20020a25ab45000000b00d9c28df87e3mr14968129ybi.35.1698167329504; Tue, 24 Oct 2023 10:08:49 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:990b:551:8028:180e? ([2600:1700:bd2c:b810:990b:551:8028:180e]) by smtp.googlemail.com with ESMTPSA id u98-20020a25ab6b000000b00da0501b497asm409298ybi.18.2023.10.24.10.08.49 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 24 Oct 2023 10:08:49 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------M4PijKTPGYDGj4GMUU3t3yak" Message-ID: Date: Tue, 24 Oct 2023 12:08:48 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_restore is not working Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <0100018b62722391-65a890bf-5d6b-415f-8831-bf8ae2a09fde-000000@email.amazonses.com> From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------M4PijKTPGYDGj4GMUU3t3yak Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 10/24/23 11:43, M Sarwar wrote: > > Hi, > > Restore is having no errors but it is not restoring any data. > I have used the below command pg_dump > pg_dump -F t -v -h bronxdb1.c52p1yyyjuib.us-xxx-west-1.rds.amazonaws.com > -U db_sarwar -d NGBRDVDB -t 'bronxdev.errors' -f > C:\Mohammed\Work\NGC\Apps\Bronx\Backups\Dumps\data\backup_Dev_Bronxdev-Errors_20231024-5.DUMP > Why "-Ft" instead of "-Fc" for a .dump file? > I am using the below command for the restore. > > PS H:\> pg_restore -F t -v -h > bronxdb1.c52p1fyyyuib.us-xxx-west-1.rds.amazonaws.com -U db_sarwar -d > bronxdb1 -t 'bronxdev.errors' > C:\Mohammed\Work\NGC\Apps\Bronx\Backups\Dumps\data\backup_Dev_Bronxdev-Errors_20231024-5.DUMP > pg_restore: connecting to database for restore > Password: > pg_restore: implied data-only restore > PS H:\> > > Thanks, > Sarwar > -- Born in Arizona, moved to Babylonia. --------------M4PijKTPGYDGj4GMUU3t3yak Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 10/24/23 11:43, M Sarwar wrote:
 

Hi,

Restore is having no errors but it is not restoring any data.
I have used the below command pg_dump
pg_dump -F t -v -h bronxdb1.c52p1yyyjuib.us-xxx-west-1.rds.amazonaws.com -U db_sarwar -d NGBRDVDB -t 'bronxdev.errors' -f C:\Mohammed\Work\NGC\Apps\Bronx\Backups\Dumps\data\backup_Dev_Bronxdev-Errors_20231024-5.DUMP


Why "-Ft" instead of "-Fc" for a .dump file?

I am using the below command for the restore.

PS H:\> pg_restore -F t -v -h bronxdb1.c52p1fyyyuib.us-xxx-west-1.rds.amazonaws.com -U db_sarwar -d bronxdb1 -t 'bronxdev.errors' C:\Mohammed\Work\NGC\Apps\Bronx\Backups\Dumps\data\backup_Dev_Bronxdev-Errors_20231024-5.DUMP
pg_restore: connecting to database for restore
Password:
pg_restore: implied data-only restore
PS H:\>

Thanks,
Sarwar

 


--
Born in Arizona, moved to Babylonia.
--------------M4PijKTPGYDGj4GMUU3t3yak--