This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
wiki:advanced:multi-node:x2goserver-pgsql [2013/09/23 19:20] sunweaver |
wiki:advanced:multi-node:x2goserver-pgsql [2016/03/29 19:40] (current) stefanbaur [X2Go Server with PostgreSQL database backend] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== X2Go Server with PostgreSQL database backend ====== | ====== X2Go Server with PostgreSQL database backend ====== | ||
- | **Note:** This wiki page explains how you can configure X2Go with PostgreSQL as database backend. However, this is only recommended for sites that run more than one X2Go Server (X2Go multi-node farms). | + | **Note:** This wiki page explains how you can configure X2Go with PostgreSQL as database backend. However, for small setups, this is unneccessary. If you have one standalone X2Go server and only a small number of users, then you can use the SQLite database backend (which is the default after installation of the '' |
- | If you have one standalone X2Go server then please use the SQLite database backend (which is the default after installation of the '' | ||
With X2Go Server v3.0.99.0 the whole session database backend code had been fully rewritten due to a serious security issue that had been brought up by Morty, Reinhard and Arw. Sind then, the '' | With X2Go Server v3.0.99.0 the whole session database backend code had been fully rewritten due to a serious security issue that had been brought up by Morty, Reinhard and Arw. Sind then, the '' | ||
Line 119: | Line 118: | ||
===== Database Structure and Troubleshooting ===== | ===== Database Structure and Troubleshooting ===== | ||
- | In case it becomes | + | In hopefully rare cases it may become |
==== Connect to the database ==== | ==== Connect to the database ==== | ||
+ | |||
+ | In case it becomes necessary to edit the X2Go session database on the PostgreSQL server by hand, connect to the DB with this command: | ||
< | < |