Postgres

From Bashlinux
Jump to: navigation, search

How to install Postgres

  • Install postgresql packages
CentOS
# yum install postgresql postgresql-server
Ubuntu
# apt-get install postgresql

How to initialize the DB

# mkdir /var/lib/pgsql/data
# chown postgres /var/lib/pgsql/data
# su - postgres
> initdb -D /var/lib/pgsql/data  
  • Start postgres
# pg_ctl -D /usr/local/pgsql/data -l -logfile start