• Table of Contents
• Print Version
• Code Documentation
• spunQ Blog
• spunQ.com

Database Creation - PostgreSQL specific

Create a database as PostgreSQL system user – commonly named “pgsql” or “postgres”:

# createdb spunq_db; // or an other database-name according to your setup

For security reasons create two users for backend and frontend. Grant all privileges for the admin user and just SELECT for the web user.

# createuser spunq_adm;
# createuser spunq_web;

Answer the questions for creating of new databases and users with NO!
You need to grant permissions to this users now. For the sample-database dump you find two SQL scripts under backend/install
- pg_perm_spunq_adm.sql
- pg_perm_spunq_web.sql

Run this scripts against your new database:
# psql spunq_db < /YOUR/PATH/backend/db/pg_perm_spunq_adm.sql
# psql spunq_db < /YOUR/PATH/backend/db/pg_perm_spunq_web.sql

Finally, you need to set a password for both users:
#psql spunq_db
spunq_db=# ALTER USER spunq_adm WITH PASSWORD 'your_password';
spunq_db=# ALTER USER spunq_web with password 'your_password';

Note: If you create new tables (classes) in spunQ, permissions are not granted for the web-user. you have do that manually!!

Tags

Related Subjects

Do you need additional information?