forked from zokier/todd-zok
-
Notifications
You must be signed in to change notification settings - Fork 0
/
README
49 lines (39 loc) · 1.06 KB
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
dependencies:
zeromq python bindings
PostgreSQL
libpq
gettext
pgcrypto module for PostgreSQL
ncurses
### postgreSQL installation ###
# yum group install "PostgreSQL Database"
# yum install postrgesql-contrib
...
# postgresql-setup initdb
Initializing database ... OK
# service postgresql start
### create the database user ###
# sudo -u postgres createuser todd
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
### create the database ###
# sudo -u postgres createdb -O todd todd
# sudo -u postgres psql todd
psql (9.1.3)
Type "help" for help.
### enable the cryptocraphic extension as the postgresql superuser ###
todd=# create extension pgcrypto;
CREATE EXTENSION
todd=# \q
# vi /var/lib/pgsql/data/pg_hba.conf
...
local sameuser todd trust
...
# service postgresql restart
$ psql todd todd
psql (9.1.3)
Type "help" for help.
### FAQ ###
error: Postgres init error: ERROR: function crypt(text, text) does not exist
solution: enable pgcrypto