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 [2012/04/30 12:23] gradator |
doc:installationguide:basic-postgresql [2016/10/03 23:03] 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 28: | Line 25: | ||
postgres=# \l | postgres=# \l | ||
List of databases | List of databases | ||
- | Name | Owner | Encoding | Collation | Ctype | Access privileges | + | Name | Owner | Encoding | Collate | Ctype | Access privileges |
-----------+----------+----------+-------------+-------------+----------------------- | -----------+----------+----------+-------------+-------------+----------------------- | ||
[...] | [...] | ||
- | vhffs | vhffs | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | + | vhffs | vhffs | UTF8 | en_US.UTF-8 | en_US.UTF-8 | |
(4 rows) | (4 rows) | ||
+ | |||
+ | |||
If not, you have to create a new PostgreSQL cluster with the UTF-8 encoding. If the VHFFS database was the only database of the previous cluster not using UTF8, you can of course destroy the cluster. | If not, you have to create a new PostgreSQL cluster with the UTF-8 encoding. If the VHFFS database was the only database of the previous cluster not using UTF8, you can of course destroy the cluster. | ||
Line 40: | 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.4# psql vhffs vhffs -h localhost | + | ~/vhffs-4.6# psql vhffs vhffs -h localhost |
Password for user vhffs: | Password for user vhffs: | ||
- | psql (8.4.7) | + | 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. | ||
| | ||
+ | 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 | ||
<note important> | <note important> | ||
- | Don't be dumb! This is //initdb.sql//, **NOT** //initdb.sql**.in**//, this is not a typo, //initdb.sql.in// is processed by autotools to create //initdb.sql// which contains autogenerated stuff like the minimal uid or gid number. If you don't have //initdb.sql// just run the //./configure// script. | + | Don't be dumb! This is //initdb.sql//, **NOT** //initdb.sql**.in**//, this is not a typo, //initdb.sql.in// is processed by autotools to create //initdb.sql// which contains autogenerated stuff like the minimal uid or gid number. If you don't have //initdb.sql// then just run the //./configure// script. |
</note> | </note> |