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
Last revision Both sides next revision
doc:installationguide:basic-postgresql [2014/12/13 15:51]
gradator updated pg output
doc:installationguide:basic-postgresql [2016/10/02 19:25]
gradator
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 45: Line 43:
 Then, initialize the database: Then, initialize the database:
  
-  ~/vhffs-4.4# psql vhffs vhffs -h localhost+  ~/vhffs-4.5# psql vhffs vhffs -h localhost
   Password for user vhffs: ​   Password for user vhffs: ​
-  psql (8.4.7)+  psql (9.1.14)
   SSL connection (cipher: DHE-RSA-AES256-SHA,​ bits: 256)   SSL connection (cipher: DHE-RSA-AES256-SHA,​ bits: 256)
   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