Azure Container Instance and storage for PostgreSQL

Adam Erot 51

Hello there,

Is it possible to start PostgreSQL server on Azure Container Instance (ACI) where database will be storing in Azure Files?

In my experience, Azure Files isn't good choice for databases, because it mostly does not work at all. Finally, I launched sqlite3 database (after some troubleshooting), but PSQL deployment stuck with failure. This is not only my problem ( E.g.: https://stackoverflow.com/a/63821879 )

Is someone who already has some experience in this case?

Best Regards,
Adam Erot

Roderick Bant 2,046 Reputation points

2022-05-21T11:02:44.907+00:00

Hi, I can't help you with any previous experience of my own on running PostgreSQL on ACI. I have previously considered it but chose to use Azure's Database for PostgreSQL PaaS service instead. Mainly because I did not like the idea of running a database over an SMB fileshare. Especially so when considering the database will need consistent backup and restore capabilities. The PaaS DB offering just takes a lot of the burden of solving those issues away with platform features that are easy to use, audit and control.
Adam Erot 51 Reputation points

2022-05-22T11:29:42.977+00:00

@Roderick Bant - Thank you for sharing :)