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 [2014/12/13 16:40]
gradator updated pg initdb
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 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.
   ​   ​
 +  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
  
Recent changes RSS feed Creative Commons License Donate Minima Template by Wikidesign Driven by DokuWiki