Open link in a new tab

Content

Expand project menu

[Win10-docker desktop] Update but pg_ctl could start server

Hi , I am using Windows 10 + Docker_Desktop in WSL2. 

I have a Version that is May 2022, and Version August 2022. I want to upgrade it latest version.

I have tried to create container and link to previous folder location. but it failed to start. with  following message

-----> Existing PostgreSQL cluster found in /var/openproject/pgdata.
-----> Setting PGVERSION=13 PGBIN=/usr/lib/postgresql/13/bin PGCONF_FILE=/etc/postgresql/13/main/postgresql.conf
-----> Starting the all-in-one OpenProject setup at /app/docker/prod/supervisord...
-----> Database cluster already exists, not modifying.
pg_ctl: could not start server
Examine the log output.
      waiting for server to start.... stopped waiting

Can any expert help me on this ? If i delete the pgdata folder in windows it works it can start but i lost all my data. below is my 

docker run -d -p 8090:80 --name openproject -e SECRET_KEY_BASE=secret \
 -e OPENPROJECT_HOST__NAME=localhost:8090 \
 -e OPENPROJECT_HTTPS=false \
 -v C:/Users/aaa23/docker/openproject12A/pgdata :/var/openproject/pgdata \
 -v C:/Users/aaa23/docker/openproject12A/static :/var/openproject/assets \
 openproject/community:12

Hope someone can help me. thanks

Message actions

Hi Alanwu,

please try reading this article, maybe it helps you, my guess is wrong ownership on the postgres db container:

https://kingsor.github.io/2019/03/23/using-postgres-with-docker-on-windows/

Good luck and best regards Adam

Message actions

Thanks Adam,

I end up backup postgres database from the Old version , and Import to the New version. 

it manage to restore the entries. but i think i lost the pictures . I think i can live with it at the moment. 

Will look in to changing the HOST from windows to linux soon.