Part 21 - PostgreSQL : What is a Pg_base backup.

( 24*7) on Call Support for PostgreSQL/Open Source databases.
***********************************************************************************************
For Self Paced Learning: courses.emultiskills.com/cour... ( Paid one-time subscription )
Online Training: [e-mail] or wa.me/message/VUBG74XTU3DSM1
***********************************************************************************************
PostgreSQL support starting from 100 USD/Hr ( 24*7)
WhatsApp contact: wa.me/message/VUBG74XTU3DSM1
Email: [e-mail]
***********************************************************************************************

[@esaval4419]

Best video ever. Well explained especially for new learners

[@dnyandeep11]

very clear video thanks for clearance

[@fahadkhanchughtai3279]

Loved it! Simple and clear!

[@EMultiSkillsDatabaseServices]

Glad you liked it!!

[@rajkishoreshaw596]

thank you sir

[@saketbhushan5495]

Insightful

[@EMultiSkillsDatabaseServices]

Thank you .

[@durgaprasadpj]

Hi, I have a question i have taken two servers master and slave i have given all the params according to my documentation. but where as in pg_basebackup is not happening. can you provide me any hints to achieve this. thank you

[@smallpotato667]

Hi,
This is working fine in the localhost.
But, when i try to do it for remote server it is throwing some error.
It is asking 'is the server accecpting tcp connections'.
In the pg_hba.confg listener address is set to '*'. Couldn't figure out what exactly is the problem.
Please help

[@EMultiSkillsDatabaseServices]

What command did you use ?

[@user-ih7ot7vl8u]

Thank you for your tutorial and offert ♥️
Could you please demo how restoring after complete backup

[@EMultiSkillsDatabaseServices]

Yes I will

[@user-ih7ot7vl8u]

@@EMultiSkillsDatabaseServices Thank you very much

[@GHEC-ARCHANASV]

Hi, can you make a video to restore the backup files of pg_basebackup(from one system to another system )

[@EMultiSkillsDatabaseServices]

Sure

[@LifeInFrames9]

Hi, I followed your steps but backup was unsuccessful, I am getting errors as below could you please help?
Peer authentication failed for user "replication_user",I am using 11.7 version of postgresql.

[@EMultiSkillsDatabaseServices]

Check the video on postgresql.conf in playlist that has details related to this.

[@nikhamdel5108]

I have accidentally deleted my database .I had a backup but it didn't restore entire data .Could you please tell me what should I do?

[@EMultiSkillsDatabaseServices]

You need to have full database backup with wal logs to restore it

[@nikhamdel5108]

@@EMultiSkillsDatabaseServicesI don't have it. Can any other method be used ?

[@dongaaa456]

Helper restore from pg_basebackup please

[@EMultiSkillsDatabaseServices]

It must be there

[@ensurokka6905]

Sir how to recover delete database from pgadmin please can u tell

[@EMultiSkillsDatabaseServices]

Do you have a backup available ?
pg_dump backup or any other backup ?

[@ensurokka6905]

@@EMultiSkillsDatabaseServices no actually I forget to take backup

[@ensurokka6905]

@@EMultiSkillsDatabaseServices so I accidentally use delete query so how to recovery it sir

[@EMultiSkillsDatabaseServices]

is it managed instance in any cloud ( managed instance )? or it is hosted on a virtual machine in datacenter ( On premises )

[@nikhamdel5108]

@@ensurokka6905 hi did you manage to get database back?