Forum Widgets
Latest Discussions
Backup and restore postgres to blob
The company is developing a client app using postgresql 14 flexible server for the backend. There will be a few db's for various management/control purposes but the main db is multi-tenant and being designed as "tenant per schema". Backup and restore of the whole flexible server is nicely taken care of, but there will undoubtedly come a time when a particular tenant (schema) needs a restore. The recovery process, as I understand it, would be: Spin up a new Temp postgresql flexible server Do a point in time restore of the Live backup onto Temp Get the specific bits from Temp and restore to Live For 3, my plan is to use pg_dump to backup just the one schema in Temp to a blob and then pg_restore it into Live. Is anyone doing this kind of thing? I'm a seasoned MS SQL dba but very new to Postgresql and Azure. What tools are there to implement this - Logic Apps? This blog (Backup Azure Database for PostgreSQL to a Blob Storage - Microsoft Tech Community) shows a one-off way of backing up to Azure fileshare but isn't really suitable for a production environment. It also doesn't address how you'd restore from blob either. Any general or specific help/guidance will be very gratefully received. ThanksSolvedSimonWrightJul 06, 2022Copper Contributor5.4KViews0likes3Comments
PL Extensions
Hi, my name is Dirk, i am a first timer here, so i am not fully sure this post/question is right here. If not please let me know of a better place to ask this question. Thank you 🙂 Here the question: we are planning to use PostgreSQL on Azure. We expect to do a bit of scripting in trigger functions as part of an ELT process. Was thinking about Perl since some functions require string Base64 encoding and XML parsing. In the documentation about Postgres on Azure I could see only PL/SQL as a supported extension, nothing about PL/Perl. Is this correct? Would be great if someone could confirm this (or better yet, tell me that Perl is actually supported)! Thank you, DirkSolveddirkmanuelJun 09, 2022Copper Contributor1.6KViews0likes2Comments
Resources
Tags
- PostgreSQL3 Topics
- Azure Database for PostgreSQL2 Topics
- Open Source2 Topics
- Citus2 Topics
- community1 Topic
- azure1 Topic
- Azure Data1 Topic
- azure cosmos db1 Topic
- DNS1 Topic
- database1 Topic
