| From: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | pg_restore is not working |
| Date: | 2023-10-24 16:43:18 |
| Message-ID: | DM4PR19MB59784C59594057E868659666D3DFA@DM4PR19MB5978.namprd19.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2023-10-24 16:56:47 | Re: pg_restore is not working |
| Previous Message | Dan Smith | 2023-10-24 13:34:10 | Re: User/Roles, Owner, and privileges migration strategy |