PostgreSQL

FUDforum provides out of the box support for PostgreSQL databases.

One of the following PHP drivers must be implemented to enable Postgres support:

• pgsql
• pdo_mysql (Portable Data Objects interface)

Create a database

Manual command line example to create a database for your forum:

$ ./psql -U postgres 
Password for user postgres: 
psql.bin (10.3)
Type "help" for help.

postgres=# create database fudforum;
CREATE DATABASE
postgres=# create user fudforum;
CREATE ROLE
postgres=# alter role fudforum with password 'your_secret_password';
ALTER ROLE
postgres=# grant all privileges on database fudforum to fudforum;
GRANT
postgres=# alter database fudforum owner to fudforum;
ALTER DATABASE

External links

• Official
• http://en.wikipedia.org/wiki/PostgreSQL