Re: postgres and initdb not working inside docker

Only in an ideal world are all standards observed...

Docker has different standards inside.

$ ls -l /home/neo/
drwxr-xr-x 2 pgsql pgsql 8192 May 27 10:37 data
drwxr-sr-x 2 pgsql pgsql 4096 May 24 09:35 data2

/home/pgsql/data - mounted volume.

Therefore, the permissions have changed to drwxr-xr-x

$ mkdir /home/pgsql/data/pgtest
$ ls -l /home/pgsql/data
drwxr-xr-x 2 pgsql pgsql 0 May 27 11:08 pgtest

$ chmod 700 /home/pgsql/data/pgtest
$ ls -l /home/pgsql/data
drwxr-xr-x 2 pgsql pgsql 0 May 27 11:08 pgtest

Oops...

If it's a regular "data2" folder and there is no "read_only: true" flag
for the container:
$ mkdir /home/pgsql/data2/pgtest
$ chmod 700 /home/pgsql/data2/pgtest
$ ls -l /home/pgsql/data2
drwx------ 2 pgsql pgsql 4096 May 27 11:19 pgtest

> Roffild writes:
>> postgres and initdb not working inside docker.
>> chmod 755 always for a mounted volume inside docker.
>
> This patch will never be accepted. You don't need it if you take the
> standard advice[1] that the Postgres data directory should not itself
> be a mount point. Instead, make a subdirectory in the mounted volume,
> and that can have the ownership and permissions that the server expects.
>
> regards, tom lane
>
> [1] https://www.postgresql.org/message-id/12168.1312921709%40sss.pgh.pa.us