Re: pg_restore is not working - Mailing list pgsql-admin

From Ron
Subject Re: pg_restore is not working
Date
Msg-id c09be485-2d50-4362-90dd-94b808eadabb@gmail.com
Whole thread Raw
In response to pg_restore is not working  (M Sarwar <sarwarmd02@outlook.com>)
Responses Re: pg_restore is not working
List pgsql-admin
On 10/24/23 11:43, M Sarwar wrote:
P {margin-top:0;margin-bottom:0;}
 

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.

pgsql-admin by date:

Previous
From: "Wetmore, Matthew (CTR)"
Date:
Subject: RE: pg_restore is not working
Next
From: M Sarwar
Date:
Subject: Re: pg_restore is not working