PostgreSQL

From FUDforum Wiki
Jump to: navigation, search

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

Supported database types

DB2 | CUBRID | Firebird | MySQL | PostgreSQL | Oracle | SQLite | SQL Server

Also see: FUDforum tables
Languages
Personal tools