From: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: pg_restore is not working |
Date: | 2023-10-24 19:55:11 |
Message-ID: | DM4PR19MB5978D87984405FA500DECB9BD3DFA@DM4PR19MB5978.namprd19.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
In both pg_dump and pg_restore commands, I am always using -v option which verbose mode. Without that I will not be able to know any status.
All of my commands are using -v clause.
Thanks,
Sarwar
________________________________
From: Ron <ronljohnsonjr(at)gmail(dot)com>
Sent: Tuesday, October 24, 2023 3:43 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_restore is not working
You're still doing something wrong. And "pg_restore --verbose" does throw errors.
On 10/24/23 14:13, M Sarwar wrote:
Here is my update.
I was using pg_restore with -t 'schema-name.tablename'.
After reading the document, https://www.postgresql.org/docs/16/app-pgrestore.html, I tried to avoid using the clause of -t in pg-restore command. I just restored the entire which has just 1 table dump.
In my opinion if there is any issue with -t clause in pg_restore, it should through an error instead of it is simply coming out without throwing any error.
Thanks,
Sarwar
________________________________
From: Ron <ronljohnsonjr(at)gmail(dot)com><mailto:ronljohnsonjr(at)gmail(dot)com>
Sent: Tuesday, October 24, 2023 1:56 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org> <pgsql-admin(at)lists(dot)postgresql(dot)org><mailto:pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_restore is not working
On 10/24/23 12:24, M Sarwar wrote:
Hi Ron,
I did try using -Fc clause. pg_dump is running fine but pg_restore is having the same issue.
I tried once again now after seeing your email and getting the same scenario.
Pg_Dump:-
PS H:\> pg_dump -Fc -v -h sharded -U db_sarwar -d NGBRDVDB -t 'bronxdev.errors' -f C:\Mohammed\Work\NGC\Apps\Bronx\Backups\Dumps\data\backup_Dev_Bronxdev-Errors_20231024-6.DUMP
Password:
Pg_dump ran fine.
Pg_Restore:-
PS H:\> pg_restore -v -h sharded -U db_sarwar -d bronxdb1 -t 'bronxdev.errors' C:\Mohammed\Work\NGC\Apps\Bronx\Backups\Dumps\data\backup_Dev_Bronxdev-Errors_20231024-6.DUMP
pg_restore: connecting to database for restore
Password:
pg_restore: implied data-only restore
PS H:\> pg_restore -Fc -v -h sharded -U db_sarwar -d bronxdb1 -t 'bronxdev.errors' C:\Mohammed\Work\NGC\Apps\Bronx\Backups\Dumps\data\backup_Dev_Bronxdev-Errors_20231024-6.DUMP
pg_restore: connecting to database for restore
Password:
pg_restore: implied data-only restore
PS H:\>
It has no errors but it did not restore the data.
This works for me. I just tested it. You'll have to convert from bash to Windows.
SrcHost=somehost
DescHost=anotherhost
SrcDir=/var/lib/pgsql/backups/test
SrcDB=somedb
DestDB=anotherdb
Tbl=public.job
pg_dump --host=$SrcHost -Fc -t $Tbl -v -d ${SrcDB} -f $SrcDir/${Tbl}.dump
pg_restore --host=$DestHost -v -d ${DestDB} ${SrcDir}/${Tbl}.dump
Thanks,
Sarwar
________________________________
From: Ron <ronljohnsonjr(at)gmail(dot)com><mailto:ronljohnsonjr(at)gmail(dot)com>
Sent: Tuesday, October 24, 2023 1:08 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org> <pgsql-admin(at)lists(dot)postgresql(dot)org><mailto:pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_restore is not working
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.
--
Born in Arizona, moved to Babylonia.
--
Born in Arizona, moved to Babylonia.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2023-10-24 20:03:45 | Re: pg_restore is not working |
Previous Message | Alex Williams | 2023-10-24 19:45:29 | Re: postgresql14-contrib does not install with libpython 3.7 |