๊ด€๋ฆฌ ๋ฉ”๋‰ด

data_lab

[๋ฆฌ๋ˆ…์Šค] postgresql ์„ค์น˜ํ•˜๊ธฐ ๋ณธ๋ฌธ

LINUX

[๋ฆฌ๋ˆ…์Šค] postgresql ์„ค์น˜ํ•˜๊ธฐ

๐Ÿฐํžˆํžˆ 2021. 7. 7. 16:05

Linux CentOS 7 v ๊ธฐ์ค€์œผ๋กœ ์ž‘์„ฑ๋˜์—ˆ์Œ

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
yum install postgresql-server postgresql-server postgresql-contrib postgresql-devel
 
postgresql-setup --initdb
systemctl enable postgresql*
systemctl start postgresql*
 
su - postgres
cd /var/lib/pgsql/data/
vi postgresql.conf
listen_address="*"
 
:wq!
 
vi pg_hba.conf
local    all             all                                    trust
host     all             all            0.0.0.0/0               trust
host     all             all            ::/0                    trust
 
:wq!
 
 
systemctl restart postgresql*
systemctl status postgresql*
cs
728x90
๋ฐ˜์‘ํ˜•