Files
@ 8d9a5fe3d8e3
Branch filter:
Location: libtransport.git/docs/guide/postgresql.textile - annotation
8d9a5fe3d8e3
1.6 KiB
text/plain
add new repo for yowsup
Changed yowsup repo to maintained one
Changed yowsup repo to maintained one
5e9d48751cd5 5e9d48751cd5 5e9d48751cd5 6334c256f4fd 5e9d48751cd5 5e9d48751cd5 5e9d48751cd5 5e9d48751cd5 5e9d48751cd5 6334c256f4fd 5e9d48751cd5 5e9d48751cd5 5e9d48751cd5 6334c256f4fd 5e9d48751cd5 5e9d48751cd5 5e9d48751cd5 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd 6334c256f4fd |
h2. 1. Editing the configuration file
To configure Spectrum 2 to use PostgreSQL database, you have to edit some or more of the following options in database section. Please note that connectionstring overrides everything else (aside from type).
|_. 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| port | string | Database port | Database port. |
| database| user | string | PostgreSQL user. | PostgreSQL user. |
| database| password | string | PostgreSQL Password. | PostgreSQL Password. |
| database| prefix | string | | Prefix of tables in database. |
| database| connectionstring | string | Postgres connection string | If you set this, it will ignore all other options above aside from type and prefix. This allows you to set any typical postgres connection string option, separated by spaces (no semicolons). |
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.
h2. 3. Some examples
Using connectionstring:
[database]
type=pqxx
connectionstring=host=localhost database=spectrum2 user=myuser password=whatever
Using traditional options:
[database]
type=pqxx
server=localhost
database=spectrum2
user=myuser
password=whatever
|