Why did you use the file extension .dump for your backup file instead of using .bak or .sql? the .bak extension works for me, but no the .sql extension. I have not yet tried using the .dump. What's the difference?
www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7 I might be wrong, but it seems this article partially answers your question. Physical back up->write ahead log files... But I believe even big companies announce maintenance and they stop servers to back up databases and/or fix problems with the servers... So I think this situation when you cannot stop servers is very unlikely?
Hi Dear, Please assist us obtain step-by-step instructions for migrating the Avantra from AWS to GCP. Source - On AWS: Avantra is running with PostgreSql - onpremise Target- On GCP: Avantra is running with PostgreSQL as SaaS. We wish to move it from AWS to GCP at this time. Please provide us with specific steps.
It's a really good video. On point and fast... Thank you!
On point and fast... Thank you!
Thank you so much! This saved me alot of time, and it was straight to the point. Really glad i found this video. I will recomend it to many others!
Thanks a lot man. You Really helped me with this video. Keep rocking.
Thank you very Much..This was of great help
thank you! this helped me migrate my matrix database to a new host!
Magnificent, thank you!
helped me so much, thanks for the video
Чува-ак! Спасибо тебе, большое!
thanks you save us a huge trouble. THNKS
Thank you. It's work!
Thanks a ton!
Many Many thanks ❤
Why did you use the file extension .dump for your backup file instead of using .bak or .sql?
the .bak extension works for me, but no the .sql extension. I have not yet tried using the .dump. What's the difference?
Thank you
TY a no bs approach
Очень помог, спасибо
Thanks 🙏
Подскажи плиз какой параметр прописать для записи лога файла при восстановлении базы на удаленный сервер? Использую CMD
Assuming that you cannot take the database offline, how do you ensure that the backup is atomic (all transactions complete)?
www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7
I might be wrong, but it seems this article partially answers your question. Physical back up->write ahead log files... But I believe even big companies announce maintenance and they stop servers to back up databases and/or fix problems with the servers... So I think this situation when you cannot stop servers is very unlikely?
How can i handle the password if i need to automate db migration for example with github actions? Some ideas?
thanks
А как их вообще запускать с консоли? Не смотря на то, что у меня установлен потсгрес, пишет, что psql, pg_dump не опознано
Hi Dear,
Please assist us obtain step-by-step instructions for migrating the Avantra from AWS to GCP.
Source - On AWS:
Avantra is running with PostgreSql - onpremise
Target- On GCP:
Avantra is running with PostgreSQL as SaaS.
We wish to move it from AWS to GCP at this time. Please provide us with specific steps.
I would stop at the first error shown like in your case ^^
How to take backup in directory format?
RTFM: "pg_dump --help"
-F, --format=c|d|t|p output file format (custom, directory, tar,
plain text (default))
these two commands also for docker db
docker exec -it pg pg_dump --clean --username=test --dbname=test > dump.sql
cat dump.sql | docker exec -i pg psql --username=test --dbname=test
If I want 3 months backup
так я не понял, почему русский акцент, где индусы?
я спецом поставил плагин чтобы по переводу с англ, сперва нарвался на индуса =) а теперь на русско-говорящего вроде, мой плагин не справляется =)
small d