> On Oct 24, 2023, at 10:43 AM, M Sarwar <sarwarmd02@xxxxxxxxxxx> 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 > > 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 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.