Forum OpenACS Development: Re: Docker Images available

Collapse
10: Re: Docker Images available (response to 9)
Posted by Kenneth Wyrick on 07/23/20 06:17 PM
Hi Mate,
Used your .yml to install docker.

Trying to find the path to where the postgres data is stored.

The ENV is set to
PGDATA /var/lib/postgresql/data

Collapse
11: Looking for Postgres Data_Directory of postgres-10-alpine docker container (response to 10)
Posted by Kenneth Wyrick on 08/08/20 04:13 AM
kmw@caltek$ sudo docker run -it postgres:10-alpine /bin/bash
bash-5.0# whoami
root
bash-5.0# su - postgres
b030bcb67163:~$ psql -c "show data_directory"
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
b030bcb67163:~$
Collapse
13: Is the postgres data_directory a named volume on the host? (response to 11)
Posted by Kenneth Wyrick on 08/09/20 01:20 AM
volume name: openacs_db_data
located:
/var/lib/docker/volumes/openacs_db_data/_data
Collapse
15: Re: Is the postgres data_directory a named volume on the host? (response to 13)
Posted by Malte Sussdorff on 08/09/20 08:37 AM
Keep in mind that this finding depends on how docker is handling the volumes on your system. You should normally not access your volume directly from the docker host.
Collapse
16: Re: Looking for Postgres Data_Directory of postgres-10-alpine docker container (response to 11)
Posted by Bianca Mikaela on 01/14/21 02:37 AM
Hi, I'm tried this,

kmw@caltek$ sudo docker run -it postgres:10-alpine /bin/bash
bash-5.0# whoami
root
bash-5.0# su - postgres
b030bcb67163:~$ psql -c "show data_directory"
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
b030bcb67163:~$

but nothing happen here

Collapse
17: Re: Looking for Postgres Data_Directory of postgres-10-alpine docker container (response to 16)
Posted by Gustaf Neumann on 01/17/21 11:15 PM
Dear Binaca,

since nobody else answered so far: i have never used the docker image, so i have to do some guessing here. To me, this looks as if in the docker image, the postgres server was not started and/or it was not initialized (via initdb) yet.

https://wiki.postgresql.org/wiki/First_steps

i would expect that the docker script would do so for you, but maybe something went wrong on this...

-gn

Collapse
14: Re: Docker Images available (response to 10)
Posted by Malte Sussdorff on 08/09/20 08:35 AM
Quick question. If you use the docker-compose.yml then both Postgres and Docker should come up and the OpenACS Database called „openacs“ with user „openacs“ should be initialized. The Root user might not have the access for your commands.

Not sure what you want to achieve though. The PGDATA is a volume, so you can store it within the docker environment and it stays with the same data even if you upgrade the Postgres Environment. This volume is „mounted“ within the Postgres container under /var/lib/postgresql/data. So depending on your *goal* I might actually help.