Postgres data inaccessible - self-hosted

Hi there, I'm trying to persist data with the default docker-compose setup. I un-commented

- ./volumes/db/data:/var/lib/postgresql/data

- ./volumes/db/data:/var/lib/postgresql/data

. However when I down/up the project

supabase-db

supabase-db

refuses to start with

2022-10-06 12:19:52.986 UTC [1] FATAL:  data directory "/var/lib/postgresql/data" has wrong ownership

2022-10-06 12:19:52.986 UTC [1] FATAL:  data directory "/var/lib/postgresql/data" has wrong ownership

...

The server must be started by the user that owns the data directory.

The server must be started by the user that owns the data directory.

However I'm not sure what UID the container is using. As a last resort I tried

chmod -R 777 docker/volumes/db/data

chmod -R 777 docker/volumes/db/data

to no avail

Supabase•4y ago•

5 replies

Hi there, I'm trying to persist data with the default docker-compose setup. I un-commented

- ./volumes/db/data:/var/lib/postgresql/data

- ./volumes/db/data:/var/lib/postgresql/data

. However when I down/up the project

supabase-db

supabase-db

refuses to start with

2022-10-06 12:19:52.986 UTC [1] FATAL:  data directory "/var/lib/postgresql/data" has wrong ownership

2022-10-06 12:19:52.986 UTC [1] FATAL:  data directory "/var/lib/postgresql/data" has wrong ownership

...

The server must be started by the user that owns the data directory.

The server must be started by the user that owns the data directory.

However I'm not sure what UID the container is using. As a last resort I tried

chmod -R 777 docker/volumes/db/data

chmod -R 777 docker/volumes/db/data

to no avail