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

PostgreSQL ์™ธ๋ถ€์ ‘์†2

[PostgreSQL] PostgreSQL docker ์„ค์น˜ ๋ฐ ์™ธ๋ถ€์ ‘์† ํ™˜๊ฒฝ Linux, Centos7 docker PostgreSQL v.14 ํšŒ์‚ฌ์—์„œ ๊ณง ์ง„ํ–‰ํ•  ํ”„๋กœ์ ํŠธ์˜ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„œ๋ฒ„ ํ™˜๊ฒฝ ๊ตฌ์„ฑ์„ ๋‚ด๊ฐ€ ๋‹ด๋‹นํ•˜๊ฒŒ ๋˜์—ˆ๋‹ค. ๋„ˆ๋ฌด ์ข‹์•˜๋‹ค!! ํ•ญ์ƒ ํ”„๋กœ์ ํŠธ์— ํˆฌ์ž…๋  ๋•Œ ํŒ€์žฅ๋‹˜์ด๋‚˜ ๋Œ€๋ฆฌ๋‹˜์ด ๊ตฌ์„ฑํ•œ ์„œ๋ฒ„ ์œ„์—์„œ ์ž‘์—…์„ ํ•˜์˜€๋Š”๋ฐ,, ์ด๋ฒˆ์—๋Š” ๋‚ด๊ฐ€ ์ง์ ‘ ๊ตฌ์„ฑ์„ ํ•˜๋‹ค๋‹ˆ! ์„ค๋ œ๋‹ค!! ๊ตฌ์„ฑํ•ด์•ผํ•˜๋Š” ์„œ๋ฒ„๋Š” ์ด 2๋Œ€๋กœ PostgresSQL์„ ์‚ฌ์šฉํ•œ๋‹ค. ๋ฏธ๋ฆฌ ๊ตฌ์„ฑ์„ ํ•ด๋‘๋Š” ๊ฒƒ์ด๋ผ์„œ, postgreSQL์„ ์ง์ ‘ ์„ค์น˜ํ•˜์—ฌ ์‚ฌ์šฉํ•˜๋Š” ๊ฒƒ๊ณผ, ๋„์ปค ์ปจํ…Œ์ด๋„ˆ๋กœ ์„ค์น˜ํ•˜์—ฌ ์‚ฌ์šฉํ•˜๋Š” ๊ฒƒ ์ค‘ ์–ด๋–ค๊ฒƒ์ด ๋” ๋‚˜์„์ง€ ํŒŒ์•…ํ•˜๊ธฐ ์œ„ํ•ด์„œ docker ์œ„ํ•ด ์„ค์น˜ํ•ด๋ณด๊ธฐ๋กœ ํ•˜์˜€๋‹ค. 1. Docker volumn ์„ค์ • ๋„์ปค์œ„์— ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ปจํ…Œ์ด๋„ˆ๋ฅผ ์˜ฌ๋ฆด ๋•Œ๋Š” ๋ณผ๋ฅจ ์„ค์ •์ด ํ•„์ˆ˜์ด๋‹ค. ๋„์ปค ์ปจํ…Œ์ด๋„ˆ๋Š” ์‰ฝ๊ฒŒ ์˜ฌ๋ฆฌ๊ณ  ์‰ฝ๊ฒŒ ์ง€์šด ํ›„.. 2021. 10. 31.
[PostgreSQL] PostgreSQL ์„ค์น˜ ๋ฐ ์™ธ๋ถ€์ ‘์† ํ—ˆ์šฉ (Centos7) ํ™˜๊ฒฝ Linux, Centos7 PostgreSQL v.13 1. PostgreSQL ์„ค์น˜ DB ์„ค์น˜ $ sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm $ sudo yum install -y postgresql13-server DB ์ดˆ๊ธฐํ™” (๊ธฐ๋ณธ DB ์ƒ์„ฑ) $ sudo /usr/pgsql-13/bin/postgresql-13-setup initdb ์„œ๋น„์Šค ๋“ฑ๋ก ๋ฐ ์‹คํ–‰ $ sudo systemctl enable postgresql-13 $ sudo systemctl start postgresql-13 DB user ๋ฐ schema ์ƒ.. 2021. 10. 31.

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