Docker: Wekan to PostgreSQL read-only mirroring

• Wekan kanban board, made with Meteor.js framework, running on Node.js -- GitHub
• MongoDB NoSQL database
• ToroDB: MongoDB to PostgreSQL read-only mirroring, programmed with Java -- GitHub -- Interview at FLOSS Weekly
• LibreOffice 3.5 with native PostgreSQL support

Screenshot

Install

1. Install docker-compose.

2. Clone this repo.

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

3. PostgreSQL database name, username and password is wekan . Change in docker-compose.yml .

4. Write:

docker-compose up

5. Wekan is at http://localhost (port 80)

6. PostgreSQL is at address postgresql://127.0.0.1:15432/wekan or other name database that you changed in step 3), and changed username: wekan, password: wekan too. Do not write to PostgreSQL, as it's readonly mirror. Write to MongoDB or make changes in Wekan.

7. MongoDB is at 127.0.0.1:28017

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

9. Restore your MongoDB data.

Feedback

GitHub issue 787