libtransport.git Files · docs/guide/postgresql.textile

Files @ 0b0e020cdf91

Branch filter:

Location: libtransport.git/docs/guide/postgresql.textile

0b0e020cdf91 911 B text/plain Show Annotation Show as Raw Download as Raw

Jan Kaluza

Add general API to set per user settings using adhoc commands which can be defaulted from config file. Add 'Send messages as headlines' Transport setting


h2. 1. Editing the configuration file

To configure Spectrum 2 to use PostgreSQL database, you have to edit following options in database section:

|_. Section |_. Key |_. Type |_. Change to value |_. Description |
| database| type | string | pqxx | Database type - "none", "mysql", "sqlite3", "pqxx". |
| database| database | string | Name of the already create empty database | Database used to store data. |
| database| server | string | Database server | Database server. |
| database| user | string | PostgreSQL user. | PostgreSQL user. |
| database| password | string | PostgreSQL Password. | PostgreSQL Password. |
| database| prefix | string | | Prefix of tables in database. |

h2. 2. Creating the database

Spectrum 2 will create the database on the first execution. Once the database is created, you can remove the CREATE TABLE permissions to the PostgreSQL database user you use to connect the SQL.