Postgres: Difference between revisions
From Bashlinux
Jump to navigationJump to search
Content deleted Content added
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
__NOTOC__ |
__NOTOC__ |
||
| ⚫ | |||
| ⚫ | |||
* Install postgresql packages |
* Install postgresql packages |
||
CentOS |
: '''CentOS'''<br> |
||
# yum install postgresql postgresql-server |
# yum install postgresql postgresql-server |
||
Ubuntu |
: '''Ubuntu'''<br> |
||
# apt-get install postgresql |
# apt-get install postgresql |
||
=== How to initialize the DB === |
|||
# mkdir /var/lib/pgsql/data |
# mkdir /var/lib/pgsql/data |
||
# chown postgres /var/lib/pgsql/data |
# chown postgres /var/lib/pgsql/data |
||
Latest revision as of 02:00, 10 June 2015
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