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. This user must also own the server process. Value: "-D /var/lib/postgresql/data/pgdata"Īnd it results in this: The files belonging to this database system will be owned by user "postgres". Initdb: error: directory "/var/lib/postgresql/data" exists but is not empty If you want to create a new database system, either remove or empty the directory "/var/lib/postgresql/data" or run initdb with an argument other than "/var/lib/postgresql/data".Īnd it results in this: chmod: changing permissions of '/var/lib/postgresql/data': Operation not permitted The default text search configuration will be set to "english". The default database encoding has accordingly been set to "UTF8". The database cluster will be initialized with locale "en_US.utf8". Results in the following error: The files belonging to this database system will be owned by user "postgres". It doesn't really matter, you still get the same type of error by doing any the following. RUN /bin/bash -c 'chmod 777 /var/lib/postgresql/data/pgdata' RUN /bin/bash -c 'chmod 777 /var/lib/postgresql/data' So with either of that as the Dockerfile: FROM postgres:11-alpine You get the error: chmod: changing permissions of '/var/lib/postgresql/data/pgdata': Operation not permitted MountPath: /var/lib/postgresql/data/pgdata # I don't know, someone suggested this, but doesn't work apparently Because the variable is used by the postgres server binary (see the PostgreSQL docs), the entrypoint script takes it into account.īased on that, I have my postgres.yaml setup This is an environment variable that is not Docker specific. Initdb recommends a subdirectory (for example /var/lib/postgresql/data/pgdata ) be created to contain the data. The default is /var/lib/postgresql/data, but if the data volume you're using is a filesystem mountpoint (like with GCE persistent disks), Postgres
This optional variable can be used to define another location - like a subdirectory - for the database files. Basically what is outlined in the documentation:Ĭhanged the mountPath per the Postgres image documentation: These are pretty much the steps I have followed in order.
0 kommentar(er)
