Azure AKS Postgres deployment using Storage Account for database

Richard Duane Wolford Jr 206 Reputation points
2021-09-14T18:36:21.927+00:00

I have a requirement to deploy Postgres to AKS but store the data not on PVC but rather directly in a storage account. My first thought was a file share mounted to the Postgres container, but from what I've read this isn't possible because Postgres requires hard links to the database files.

I also need a second AKS cluster to be able to access the same database file simultaneously, which is why I looked at file shares. Is this a workable scenario? We're not using the PaaS option just to reiterate, deployment to AKS is a requirement for us.

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,200 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,821 questions
Azure Database for PostgreSQL
{count} vote

1 answer

Sort by: Most helpful
  1. deherman-MSFT 34,441 Reputation points Microsoft Employee
    2021-09-15T18:18:50.24+00:00

    @richardwolford-7948
    You would not be able to user Azure Files with SMB due to the limitation mentioned. However you can try this with Azure Files with NFS. This blog post does a good job covering the setup needed.

    Hope this helps! Please try this out and let us know if you run into any issues.

    -------------------------------

    Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    Disclaimer: This response contains a reference to a third-party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there.
    There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.