Let’s look into the steps to set up Nextcloud and Postgres using Docker. At Bobcares, with our Docker Hosting Support Services, we can handle your Docker-related issues.

How to set up Nextcloud and Postgres using Docker?

The steps to install Nextcloud with OnlyOffice and Postgres are as follows:

• Repository Downloading
• Container Set-up
• Starting
• Reverse Proxy Set-up
• Postgres DB Selection
• OnlyOffice Set-up
• Stack Upgrading

Let’s look into the details of each step one by one.

Repository Downloading

We can use the below code to download the repository. We must remember the name of a directory as we may need it later.

cd /home/user
git clone https://github.com/onlyoffice/docker-onlyoffice-nextcloud
mv docker-onlyoffice-nextcloud nextcloud
cd nextcloud

Container Set-up

We must now make a DB container using the below code:

sudo docker pull postgres:12.5-alpine

sudo docker run --name postgres12 \
-v /YOUR/NEXTCLOUD/LOCATION/postgres:/var/lib/postgresql/data \
-e POSTGRES_PASSWORD=password --rm -d postgres:12.5-alpine

sudo docker exec -it postgres12 psql -U postgres
> CREATE USER nextcloud WITH PASSWORD 'password' CREATEDB;
> exit

sudo docker stop postgres12

In the two codes above, please use a different password, and change the location to the folder containing docker-compose.yml.

Starting

We must make changes to the docker-compose.yml. Then add the DB section near the top:

db:
restart: always
image: postgres:12.5-alpine
shm_size: 256mb
healthcheck:
test: ["CMD", "pg_isready", "-U", "postgres"]
volumes:
- ./postgres:/var/lib/postgresql/data

Although a relative path like this one works well, the volume path above must match the one in the docker run above. Make the DB service depend on the app service as well:

app:
# contaner_name: app-server
# ...
depends_on:
- db

Now start the script:

sudo docker-compose up -d

Reverse Proxy Set-up

We can set up a reverse proxy however we like. The Nextcloud is listening on port 8081 in this instance.

Postgres DB Selection

Enter the admin username and password to access the website. The Data folder path shouldn’t be changed. Then pick a PostgreSQL DB and enter the details below:

Now hit the “Finish” at the bottom.

OnlyOffice Set-up

In order to set up the OnlyOffice, we can run the set_configuration.sh script from the repository.

sudo set_configuration.sh

We can use the web interface after setting up the reverse proxy.

Stack Upgrading

Now we can upgrade the stack by using the below code:

docker-compose pull

Lastly, restart the composition using the code:

docker-compose down && docker-compose up -d

[Looking for a solution to another query? We are just a click away.]

Conclusion

The article provides a step-by-step description from our Support team to set up Nextcloud and Postgres using Docker.