Lauri Ojansivu 46e976513b Move https://github.com/wekan/wekan-postgresql to 1 month ago
..
CHANGELOG.md 46e976513b Move https://github.com/wekan/wekan-postgresql to 1 month ago
LICENSE 46e976513b Move https://github.com/wekan/wekan-postgresql to 1 month ago
README.md 46e976513b Move https://github.com/wekan/wekan-postgresql to 1 month ago
docker-compose.yml 46e976513b Move https://github.com/wekan/wekan-postgresql to 1 month ago

README.md

Docker: Wekan to PostgreSQL read-only mirroring

Screenshot

Screenshot of PostgreSQL with LibreOffice

Install

1) Install docker-compose.

2) Clone this repo.

git clone https://github.com/wekan/wekan-postgresql.git
cd wekan-postgresql

3) IMPORTANT: In docker-compose.yml, to use Wekan on local network, change ROOT_URL=http://localhost to http://IPADRESS like http://192.168.10.100 or http://example.com

4) OPTIONAL: In docker-compose.yml, change PostgreSQL database name, username and password from wekan to something else.

5) Write:

docker-compose up -d

6) Wekan is at http://IPADDRESS or http://example.com (port 80)

7) PostgreSQL connection URL for LibreOffice is dbname=wekan hostaddr=127.0.0.1 port=15432 user=wekan password=wekan. In some other apps URL could be postgresql://127.0.0.1:15432/wekan , and Username: wekan, Password: wekan , or others if you changed those at docker-compose.yml. Do not write to PostgreSQL, as it's readonly mirror. Write to MongoDB or make changes in Wekan. If server port 15432 open, PostgreSQL can be accessed also remotely at local network at http://IPADDRESS:15432/wekan

8) MongoDB is at 127.0.0.1:28017

9) Wekan and databases bind to address 0.0.0.0 so could be also available to other computers in network. I have not tested this.

10) Restore your MongoDB data.

Feedback

GitHub issue 787