๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
  • A space that records me :)

CentOS71

[PostgresSQL] ์™ธ๋ถ€์ ‘์† ํ—ˆ์šฉ (Linux CentOS7) 1. ์‚ฌ์ „ ์ž‘์—… ๋ฐ ํ™•์ธ PostgresSQL ์„ค์น˜ PGDATA ๋””๋ ‰ํ† ๋ฆฌ ๊ฒฝ๋กœ ํ™•์ธ CentOS default : /var/lib/pgsql/{version}/data 2. postgresql.conf ์„ค์ • postgresql.conf์—์„œ listen_addresses='localhost' ์ฃผ์„ ์ œ๊ฑฐ ํ›„ '*'๋กœ ๊ฐ’์„ ๋ฐ”๊พธ๊ณ  port=5432 ๋ผ์ธ ์ฃผ์„ํ•ด์ œ ํ•œ๋‹ค. vi /var/lib/pgsql/{version}/data/postgresql.conf listen_address='*' port=5432 3. pg_hba.conf ์„ค์ • ์•„๋ž˜ ๋ช…๋ น์–ด๋ฅผ ์‹คํ–‰ํ•˜์—ฌ pg_hba.conf์— ์ ‘์† ํ—ˆ์šฉ ๊ทœ์น™์„ ์ถ”๊ฐ€ํ•œ๋‹ค. echo "host all all 0.0.0.0/0 md5" >> /var/lib/pgsql/{ve.. 2023. 9. 27.

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”