Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
doc:installationguide:basic-postgresql [2014/12/13 15:51] gradator updated pg output |
doc:installationguide:basic-postgresql [2016/10/02 19:25] gradator |
||
---|---|---|---|
Line 8: | Line 8: | ||
- | == VHFFS user== | + | == Create VHFFS user== |
# su - postgres -c "createuser -P vhffs" | # su - postgres -c "createuser -P vhffs" | ||
Enter password for new role: | Enter password for new role: | ||
Enter it again: | Enter it again: | ||
- | Shall the new role be a superuser? (y/n) n | ||
- | Shall the new role be allowed to create databases? (y/n) n | ||
- | Shall the new role be allowed to create more new roles? (y/n) n | ||
- | == VHFFS database== | + | == Create VHFFS database== |
su - postgres -c "createdb -O vhffs vhffs" | su - postgres -c "createdb -O vhffs vhffs" | ||
Line 27: | Line 24: | ||
postgres@vhffs:~$ psql | postgres@vhffs:~$ psql | ||
postgres=# \l | postgres=# \l | ||
- | List of databases | + | List of databases |
- | Name | Owner | Encoding | Collate | Ctype | Access privileges | + | Name | Owner | Encoding | Collate | Ctype | Access privileges |
- | ----------------+----------------+----------+------------+------------+----------------------- | + | -----------+----------+----------+-------------+-------------+----------------------- |
[...] | [...] | ||
- | vhffs | vhffs | UTF8 | en_US.utf8 | en_US.utf8 | | + | vhffs | vhffs | UTF8 | en_US.UTF-8 | en_US.UTF-8 | |
(4 rows) | (4 rows) | ||
+ | |||
Line 45: | Line 43: | ||
Then, initialize the database: | Then, initialize the database: | ||
- | ~/vhffs-4.4# psql vhffs vhffs -h localhost | + | ~/vhffs-4.5# psql vhffs vhffs -h localhost |
Password for user vhffs: | Password for user vhffs: | ||
- | psql (8.4.7) | + | psql (9.1.14) |
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) | SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) | ||
Type "help" for help. | Type "help" for help. | ||
| | ||
+ | vhffs=> -- if you use packaged version script is in vhffs-common | ||
+ | vhffs=> -- located at /usr/share/vhffs/backend/initdb.sql | ||
vhffs=> \i vhffs-backend/src/pgsql/initdb.sql | vhffs=> \i vhffs-backend/src/pgsql/initdb.sql | ||