SQL adaptation guide For PostgreSQL 8.x.y, 9.x.y / Installation (Runtime Configuration) |
If you are tasked with installing and configuring the database, here is a list of steps to be taken:
$ createdb -h hostname dbname --encoding encoding
$ createlang -h hostname plpgsql dbname
dbname=# CREATE USER appadmin PASSWORD 'password';
CREATE USER
dbname=# GRANT ALL PRIVILEGES ON DATABASE dbname TO appadmin;
GRANT
dbname=# \q