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 15:51]
gradator updated pg output
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 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 41: 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
  
Recent changes RSS feed Creative Commons License Donate Minima Template by Wikidesign Driven by DokuWiki