Skip to content

jaacoppi/todd-zok

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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


About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C 98.1%
  • C++ 1.1%
  • Other 0.8%