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)
@@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
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.
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
Thank you very much..!!
Always your channel provide su a new gold infomative ♥️
Please continue on this,! 💯
Thank you, I will
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)
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.
well explained !
Could you please share the document , if possible.?
I have mentioned the details how to get the script which is now in a course
thank you
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
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
Thank you very much :)
Thanks awesome!!!
Thank you
what is postgres-pgo?
anyone knows please help
Just a name