Difference between revisions of "Postgres"

Latest revision as of 02:00, 10 June 2015

CentOS

# yum install postgresql postgresql-server

Ubuntu

# apt-get install postgresql

# mkdir /var/lib/pgsql/data
# chown postgres /var/lib/pgsql/data
# su - postgres
> initdb -D /var/lib/pgsql/data

# pg_ctl -D /usr/local/pgsql/data -l -logfile start

@@ Line 1: / Line 1: @@
 __NOTOC__
+=== How to install Postgres ===
-== How to install and initialize postgres ==
 * Install postgresql packages
-CentOS
+: '''CentOS'''<br>
  # yum install postgresql postgresql-server
-Ubuntu
+: '''Ubuntu'''<br>
  # apt-get install postgresql
-* Initialize the DB
+=== How to initialize the DB ===
  # mkdir /var/lib/pgsql/data
  # chown postgres /var/lib/pgsql/data