chmod: changing permissions of '/var/lib/postgresql/data/pgdata': Operation not permitted

[YataoWang]

I‘m using the latest tag of postgres. The docker is running in WSL2 of windows 11.
Note: Following snapshots about container is from portainer

Here is the windows information,

Here is the WSL information,

Here is the image's information,

After adding volume for the pgdata path, the container fails. Here is the mapping of volumes,

Adding the privilege mode does not work,

I know thos docker will use postgres:postgres user-group to start the container, but I already give the 777 permission for the folder in my WSL, it does not work too,

Here is the full error message,

chmod: changing permissions of '/var/lib/postgresql/data/pgdata': Operation not permitted
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
initdb: error: could not change permissions of directory "/var/lib/postgresql/data/pgdata": Operation not permitted
fixing permissions on existing directory /var/lib/postgresql/data/pgdata ... �Zchmod: changing permissions of '/var/lib/postgresql/data/pgdata': Operation not permitted
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
initdb: error: could not change permissions of directory "/var/lib/postgresql/data/pgdata": Operation not permitted
fixing permissions on existing directory /var/lib/postgresql/data/pgdata ... �Zchmod: changing permissions of '/var/lib/postgresql/data/pgdata': Operation not permitted
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
initdb: error: could not change permissions of directory "/var/lib/postgresql/data/pgdata": Operation not permitted
fixing permissions on existing directory /var/lib/postgresql/data/pgdata ... 

[tianon]

Unfortunately, the (filesystem) needs of databases typically do not handle filesystems like those provided by Windows / "VM file sharing" very well, so I'd suggest moving your database files into the Linux filesystem instead (and if you need to access them from Windows for some reason, share the other direction instead, but I can't imagine why you'd need to access the underlying storage of the database from Windows 🙈).

[YataoWang]

but I can't imagine why you'd need to access the underlying storage of the database from Windows

Just in case, sometimes the docker container or WSL may be bad. Recreating the docker container will lose the data, so, mount the database data in Windows. If there is a way to restore the previous database data after recreating the container, it's no need to mount the database data to windows anymore.