From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_restore is not working |
Date: | 2023-10-24 17:08:48 |
Message-ID: | c09be485-2d50-4362-90dd-94b808eadabb@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | M Sarwar | 2023-10-24 17:18:27 | Re: pg_restore is not working |
Previous Message | Wetmore, Matthew (CTR) | 2023-10-24 17:05:23 | RE: pg_restore is not working |