Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
doc:installationguide:basic-postgresql [2012/03/03 19:43]
gradator
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 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>​
 +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>​
Recent changes RSS feed Creative Commons License Donate Minima Template by Wikidesign Driven by DokuWiki