Score:0

file system requirements for postgresql and/or mysql

co flag

I'm currently tasked with making postgresql run in kubernetes in azure using a azureFile for storage.

There are numerous posts and github issues stating that postgresql cannot run with azureFile. The biggest show stopper is the permissions requirement for the data directory (for which there are some workarounds)

But even if I work around the permissions problem there's another - hard links. Some github issues and docs (e.g. this, this and this) state that postgresql needs to be able to create hard links and we can see that from the error log in the fist link above.

Azure docs clearly state that hard links are not supported. I've been looking for official postgresql documentation on file system requirements, but I'm not finding any.

Can someone point me to official documentation where it's stated that hard links are required?

I also have to look at mysql as an alternative, but this suggest I'll be having the same issues.

EDIT: A tool which tests postgresql/mysql required file system features would also be very helpful, but I'm not finding any.

p10l avatar
us flag
Is Azure Files a hard requirement? Can't you use [Azure Database for PostgreSQL](https://azure.microsoft.com/en-us/services/postgresql/)? That would be much easier, and probably more cost effective
co flag
it is currently, but im trying to argue against it, that why i need something more official
ua flag
Why doe you need "containers"?
co flag
@RickJames its a client requirement which im trying to argue
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.