62 - pgbackrest : PostgreSQL backup and restore

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

[@user-ih7ot7vl8u]

Thank you very much..!!
Always your channel provide su a new gold infomative ♥️
Please continue on this,! 💯

[@EMultiSkillsDatabaseServices]

Thank you, I will

[@rajkishoreshaw596]

thank you

[@mudasir2168]

well explained !

[@gthamu]

Thanks awesome!!!

[@EMultiSkillsDatabaseServices]

Thank you

[@hashimraza422]

Great Boss, Need a help, that Created backup with pg_dumpall, now need to validate backup file, that it is in good or non-corrupted, how can we do it.

[@MegaDinesh92]

When i execute 'yum install pgbackrest' i get below error. Any idea abt this?
Error: Package: pgbackrest-2.37-1.rhel.x86_64 (pgdg-common)
Requires: libzstd.so.1() (64bit)

[@user-bj8jf8jp2q]

Thank you very much :)

[@hasanfurkancoskun6638]

That's interest but what you done is not working!! before restoring I drop tables and even after the restoring tables don't come back

[@EMultiSkillsDatabaseServices]

It works perfectly if the setup is fine .
Not sure if you missed any step.

[@hasanfurkancoskun6638]

@@EMultiSkillsDatabaseServices after taking backup. Firstly I drop tables in db then I delete /var/lib/pgsql/14/data/* then I restore my backup. /var/lib/pgsql/14/data/* is coming back. There is no problem with that but the interesting part is that my tables don't come back

[@EMultiSkillsDatabaseServices]

I will give a temp access to the portal for few min .
Signup on courses.emultiskills.com

[@hasanfurkancoskun6638]

@@EMultiSkillsDatabaseServices thanks for help and I solve the problem adding restore command --type=immediate

[@user-jw6xc1hw7t]

Could you please share the document , if possible.?

[@EMultiSkillsDatabaseServices]

I have mentioned the details how to get the script which is now in a course

[@umarqasim4759]

How to pgbackrest configure on standby database. while creating stanza below error appeared
pgbackrest stanza-create --stanza=pgems --log-level-console=info
P00 INFO: stanza-create command begin 2.37: --backup-standby --exec-id=3700096-a12cd2d8 --log-level-console=info -- --stanza=pgems
ERROR: [056]: unable to find primary cluster - cannot proceed
INFO: stanza-create command end: aborted with exception [056]
archive mode and archive command also not set in standby. Please help.

[@zelihaseker3971]

could you solve that problem? because ı get the same error

[@jithinb360]

Hi
Can we restore production backup to staging area using pgbackrest

[@EMultiSkillsDatabaseServices]

Yes you can

[@jithinb360]

We are planning to use PostgreSQL backup solution as pgbackrest. In the testing face we are not able to restore the backup of test area a backup to test area b.
We have 2 PostgreSQL instances in seperate server's i have installed pgbackrest in both servers and created different stanza. I'm trying to restore test area a backup to test area b. By copying the pgbackup to test area b

[@jithinb360]

Is this possible to do

[@rosireddy3800]

Can we restore prod to QA using pgbackrest
Note : both env's we are using different tables pace path, password and permissions not same

[@rosireddy3800]

​@@jithinb360 hi can I get the mail id to discuss

[@taimurmalik280]

what is postgres-pgo?
anyone knows please help

[@EMultiSkillsDatabaseServices]

Just a name