Skip to content
Docker: Wekan <=> MongoDB <=> ToroDB => PostgreSQL read-only mirroring for reporting with SQL, and accessing with any programming language, reporting package and Office suite that can connect to PostgreSQL.
Branch: master
Clone or download
Latest commit 3b228e0 Jan 19, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
CHANGELOG.md Add latest wekan and torodb Dec 22, 2018
LICENSE
README.md Update readme with correct urls etc info. Dec 22, 2018
docker-compose.yml Add more environment settings and docs to docker-compose.yml Dec 22, 2018

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
  1. 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

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

  3. Write:

docker-compose up -d
  1. Wekan is at http://IPADDRESS or http://example.com (port 80)

  2. PostgreSQL is at address postgresql://127.0.0.1:15432/wekan . or other name database 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

  3. MongoDB is at 127.0.0.1:28017

  4. 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.

  5. Restore your MongoDB data.

Feedback

GitHub issue 787

You can’t perform that action at this time.