Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.100.2.1.4\))
Subject: Re: pg_restore is not working
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <DM4PR19MB59784C59594057E868659666D3DFA@DM4PR19MB5978.namprd19.prod.outlook.com>
Date: Tue, 24 Oct 2023 10:56:47 -0600
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <7102931C-1588-470F-95D7-39E50320690F@elevated-dev.com>
References: 
 <0100018b62722391-65a890bf-5d6b-415f-8831-bf8ae2a09fde-000000@email.amazonses.com>
 <PH2P110MB0922514D54CCB31B5D85BA55FFDFA@PH2P110MB0922.NAMP110.PROD.OUTLOOK.COM>
 <DM4PR19MB59784C59594057E868659666D3DFA@DM4PR19MB5978.namprd19.prod.outlook.com>
To: M Sarwar <sarwarmd02@outlook.com>
Archived-At: 
 <https://www.postgresql.org/message-id/7102931C-1588-470F-95D7-39E50320690F%40elevated-dev.com>
Precedence: bulk

> On Oct 24, 2023, at 10:43=E2=80=AFAM, M Sarwar =
<sarwarmd02@outlook.com> wrote:
>=20
> =20
> Hi,
>=20
> 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-Err=
ors_20231024-5.DUMP
>=20
> I am using the below command for the restore.
>=20
> 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-Err=
ors_20231024-5.DUMP
> pg_restore: connecting to database for restore
> Password:
> pg_restore: implied data-only restore
> PS H:\>
>=20
> Thanks,
> Sarwar=20

You're missing the -f on the pg_restore to take the dump from a file, so =
it's sitting waiting for SQL to come via stdin.