Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
doc:installationguide:basic-postgresql [2016/07/21 08:55] beuss Path to initdb.sql in packaged version |
doc:installationguide:basic-postgresql [2016/10/03 23:03] (current) gradator posgtresql 8.4 -> 9.4, vhffs 4.5 -> 4.6 |
||
---|---|---|---|
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 42: | Line 39: | ||
</note> | </note> | ||
- | Configure the file ''/etc/postgresql/8.4/main/pg_hba.conf'' to allow the **vhffs** user to access the **vhffs** database. By default localhost is allowed to connect to all databases using a password auth. | + | Configure the file ''/etc/postgresql/9.4/main/pg_hba.conf'' to allow the **vhffs** user to access the **vhffs** database. By default localhost is allowed to connect to all databases using a password auth. |
Then, initialize the database: | Then, initialize the database: | ||
- | ~/vhffs-4.5# psql vhffs vhffs -h localhost | + | ~/vhffs-4.6# psql vhffs vhffs -h localhost |
Password for user vhffs: | Password for user vhffs: | ||
- | psql (9.1.14) | + | psql (9.4.9) |
- | SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) | + | SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) |
Type "help" for help. | Type "help" for help. | ||
| |