pg_restore: error: could not find header for file "toc.dat" in tar archive , Im getting this error when restore to postgresql using both commandline or pgadmin 4
I have a aws postgres rds, under this have two rds, so I want to export one database table data to another database table mean table to table data transfer, but here problem is facing with error like constraint and fkey error while importing the table data from one table to another. I heard some XML data solution to resolve this issue and may be possible by exporting the XML data and importing the same into another table but not sure about this option,. Can you suggest if you have done something similar for aws postgres rds.
Very informative session. Can you please upload the latest version video's as well.
Thank you for this. It helped tremendously.
I really appreciate this video
Thank you, You helped me
Awesome work sir,
Please upload for upgradation also
Major and minor both.
Hi, You could have show PG_DUMPALL example also to understand clearly.
Please upload that video if possible.
Thanks!
can you share any PDF document related to postgresql database administration
Thankyou sir
thanks!
what if i need to append the data only? because client ask us to restore the database again and again.
then which parameter we must use?
pg_restore: error: could not find header for file "toc.dat" in tar archive , Im getting this error when restore to postgresql using both commandline or pgadmin 4
h ow can i do : pg_restore: [archiver] input file appears to be a text format dump. please use psql.
I have a aws postgres rds, under this have two rds, so I want to export one database table data to another database table mean table to table data transfer, but here problem is facing with error like constraint and fkey error while importing the table data from one table to another. I heard some XML data solution to resolve this issue and may be possible by exporting the XML data and importing the same into another table but not sure about this option,.
Can you suggest if you have done something similar for aws postgres rds.
You can use AWS DMS services to move data to another database system