62 - pgbackrest : PostgreSQL backup and restore
Вставка
- Опубліковано 5 вер 2024
- ( 24*7) on Call Support for PostgreSQL/Open Source databases.
***********************************************************************************************
For Self Paced Learning: courses.emulti... ( Paid one-time subscription )
Online Training: contact@emultiskills.com or wa.me/message/...
***********************************************************************************************
PostgreSQL support starting from 100 USD/Hr ( 24*7)
WhatsApp contact: wa.me/message/...
Email: contact@emultiskills.com
***********************************************************************************************
Thank you very much..!!
Always your channel provide su a new gold infomative ♥️
Please continue on this,! 💯
Thank you, I will
thank you
well explained !
Thanks awesome!!!
Thank you
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.
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)
Thank you very much :)
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
It works perfectly if the setup is fine .
Not sure if you missed any step.
@@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
I will give a temp access to the portal for few min .
Signup on courses.emultiskills.com
@@EMultiSkillsDatabaseServices thanks for help and I solve the problem adding restore command --type=immediate
Could you please share the document , if possible.?
I have mentioned the details how to get the script which is now in a course
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.
could you solve that problem? because ı get the same error
Hi
Can we restore production backup to staging area using pgbackrest
Yes you can
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
Is this possible to do
Can we restore prod to QA using pgbackrest
Note : both env's we are using different tables pace path, password and permissions not same
@@jithinb360 hi can I get the mail id to discuss
what is postgres-pgo?
anyone knows please help
Just a name