Postgres: Difference between revisions

Content deleted Content added

Inline

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 ===
-= PostgreSQL =
+* Install postgresql packages
-== Setup ==
+: '''CentOS'''<br>
-# Install postgresql packages
+ # yum install postgresql postgresql-server
+: '''Ubuntu'''<br>
-<pre><nowiki>
- yum install postgresql postgresql-server
+ # apt-get install postgresql
- </nowiki></pre>
+=== How to initialize the DB ===
-# Initialize DB
+ # mkdir /var/lib/pgsql/data
+ # chown postgres /var/lib/pgsql/data
-<pre><nowiki>
+ # su - postgres
- mkdir /var/lib/pgsql/data
- chown postgres /var/lib/pgsql/data
+ > initdb -D /var/lib/pgsql/data
- su - postgres
- initdb -D /var/lib/pgsql/data
- </nowiki></pre>
-# Start postgres
+* Start postgres
+ # pg_ctl -D /usr/local/pgsql/data -l -logfile start
-<pre><nowiki>
- pg_ctl -D /usr/local/pgsql/data -l -logfile start
- </nowiki></pre>