search

geosolutions-it / C195-azure-workspace

1 stars 2 forks source link

Postgres data persistence #4

Closed lpasquali closed 3 years ago

lpasquali commented 3 years ago

we need to check how to persist data if postgres instance on azure is removed

randomorder commented 3 years ago

please keep us posted about the prorgess and how long it takes close this @lpasquali

lpasquali commented 3 years ago

@randomorder sure, here is the progress:

As already supposed there is no way to add any kind of storage onto an Azure managed PostgreSQL instances besides the actual storage that is not possible to "browse or mount in any way".

I implemented provisioning of postges databases and a toolset of scripts to backup everything on a cronjob basis or on demand and save it on the share mounted on ckan vm, now I'm testing it, everything is parametrized sourcing from the enviroments and there is no need for any knowledge of postgres to run these.

lpasquali commented 3 years ago

at the moment deployment provisions and reaches correctly azure managed postgres on the backend network, and is capable to take full backups on demand or by cron, if needed.

lpasquali commented 3 years ago

provisioning new databases and backup existing ones is now supported and it works.

lpasquali commented 3 years ago

@etj can we close this?