±â¼ú ÀÚ·á½Ç
[Linux] PostgreSQL ¿¡ ´ëÇØ ¾Ë¾Æº¸°í ½Ç½ÀÇغ¸±â |
---|
Date : 2023-11-22
Name : ¼¹ö¸ó
Hits : 191
|
¾È³çÇϼ¼¿ä. ÁÖ½Äȸ»ç ¼¹ö¸ó ÀÔ´Ï´Ù. ¿À´Ã PostgreSQL¿¡ ´ëÇؼ ¾Ë¾Æº¸°í ½Ç½À Çغ¸µµ·Ï ÇÏ°Ú½À´Ï´Ù. PostgreSQL À̶õ?PostgreSQLÀº ¿ÀÇ ¼Ò½º °´Ã¼-°ü°èÇü µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ (ORDBMS) ·Î 1996³â ù Ãâ½Ã µÇ¾ú½À´Ï´Ù. ¾à 20¿©³âÀÇ ¿À·£ ¿ª»ç¸¦ °¡Áö°í ÀÖÀ¸¸ç, Àü ¼¼°èÀÇ ¿ÀǼҽº °³¹ßÀÚµé°ú °ü·Ã ȸ»çµéÀÌ °³¹ß¿¡ Âü¿© ÇÏ°í ÀÖ½À´Ï´Ù. ´Ù¸¥ °ü°èÇü µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ°ú ´Þ¸® ¿¬»êÀÚ, º¹Àâ ÀÚ·áÇü, Áý°èÇÔ¼ö, ÀÚ·áÇü ¹ÝȯÀÚ, È®Àåµî ´Ù¾çÇÑ µ¥ÀÌÅÍ °´Ã¼¸¦ »ç¿ëÀÚ°¡ ÀÓÀÇ·Î ¸¸µé ¼ö ÀÖ´Â ±â´ÉÀ» Á¦°øÇÔÀ¸·Î ÇÏ°í ÀÖ½À´Ï´Ù. Àü ¼¼°è »ç¿ë·üÀº »óÀ§ 3°³ÀÇ DB(Oracle DB, MySQL, Microsoft SQL)¿¡ À̾î 4À§ÀÌ¸ç ²ÙÁØÈ÷ »ó½ÂÇÏ°í ÀÖ´Â °ÍÀÌ Æ¯Â¡À̸ç MySQL¿¡ ºñÇؼ SQL Ç¥ÁØÀ» ´õ Àß Áö¿øÇÏ°í ±â´ÉÀÌ ´õ °·ÂÇϸç Äõ¸®°¡ º¹ÀâÇØÁú¼ö·Ï ¼º´ÉÀÌ ´õ Àß ³ª¿À´Â Æí ÀÔ´Ï´Ù. PostgreSQL Ư¡ ¹× ±â´ÉÈ®Àå °¡´É¼º PostgreSQL ½Ç½À(¼³Ä¡)DB ¼¹ö´Â ¸®´ª½º ±â¹ÝÀ» ¸¹ÀÌ »ç¿ëÇϱ⿡ RockyLinux8 (Redhat 8) ±â¹Ý¿¡¼ ¼³Ä¡ ¹× ½Ç½ÀÀ» ÁøÇàÇϵµ·Ï ÇÕ´Ï´Ù. ¸ÕÀú PostgreSQL ȨÆäÀÌÁö¿¡ Á¢¼Ó ÇÕ´Ï´Ù. https://www.postgresql.org/download/ PostgrelSQL Àº ´Ù¾çÇÑ OS ¿¡ ´ëÇؼ Áö¿ø ÇÕ´Ï´Ù. ½Ç½À ȯ°æ¿¡ ¸Â°Ô Redhat / Rocky/ AlmaLinux ¸¦ ¼±Åà Çϵµ·Ï ÇÕ´Ï´Ù. ȯ°æ¿¡ ¸Â´Â ¹öÀü ¹× Ç÷§Æû À» ¼±ÅÃÇÏ¿© ¾Ë¸Â´Â ¼³Á¤ ÆÄÀÏÀ» ´Ù¿î·Îµå Çϵµ·Ï ÇÕ´Ï´Ù. º» Æ÷½ºÆÿ¡¼´Â ÀÛ¼ºÀÏ ±âÁØ ÃֽŠ¹öÀüÀÎ v16 °ú Redhat 8 À» ¼±ÅÃÇÏ¿© ¼³Á¤ ÇÏ¿´½À´Ï´Ù. # Install the repository RPM:
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# Disable the built-in PostgreSQL module:
sudo dnf -qy module disable postgresql
# Install PostgreSQL:
sudo dnf install -y postgresql16-server
# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-16/bin/postgresql-16-setup initdb
sudo systemctl enable postgresql-16
sudo systemctl start postgresql-16 À§ °¡À̵带 Åä´ë·Î ¼¹öÃø¿¡ PostgreSQL À» ¼³Ä¡ÇÕ´Ï´Ù. PostgreSQL ½Ç½À(·ÎÄà Á¢¼Ó)¼³Ä¡°¡ ³¡³µ´Ù¸é Ŭ¶óÀ̾ðÆ®¸¦ ÅëÇØ Á¢¼Ó Å×½ºÆ®¸¦ ÁøÇàÇÕ´Ï´Ù. PostgreSQL Àº ±âº» °ªÀ¸·Î ¿î¿µ °èÁ¤¿¡ ·Î±×ÀÎÀÌ °¡´ÉÇÕ´Ï´Ù. #postgres °èÁ¤À¸·Î Àüȯ
[root@pgsql1 ~]# su - postgres
#psql ·Î DB Á¢¼Ó
[postgres@pgsql1 ~]$ psql
#DB ¸®½ºÆ® È®ÀÎ
postgres-# \l
µ¥ÀÌÅͺ£À̽º ¸ñ·Ï
À̸§ | ¼ÒÀ¯ÁÖ | ÀÎÄÚµù | Collate | Ctype | ICU ·ÎÄÉÀÏ | ·ÎÄÉÀÏ Á¦°øÀÚ | ¾×¼¼½º ±ÇÇÑ
-----------+----------+--------+-------------+-------------+------------+---------------+-----------------------
postgres | postgres | UTF8 | ko_KR.UTF-8 | ko_KR.UTF-8 | | libc |
template0 | postgres | UTF8 | ko_KR.UTF-8 | ko_KR.UTF-8 | | libc | =c/postgres +
| | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | ko_KR.UTF-8 | ko_KR.UTF-8 | | libc | =c/postgres +
| | | | | | | postgres=CTc/postgres
(3°³ Çà
#DB ¹öÀü È®ÀÎ
postgres=# SELECT VERSION();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 15.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit
(1°³ Çà PostgreSQL ½Ç½À (Äõ¸®)½Ç½À µ¥ÀÌÅ͸¦ ´Ù¿î·Îµå ÈÄ ¿©·¯°¡Áö Äõ¸®¸¦ ½Ç½À ÇÏ°Ú½À´Ï´Ù. ½Ç½À µ¥ÀÌÅÍ ´Ù¿î·Îµå
# wget https://www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip
# unzip dvdrental.zip
# mv dvdrental.tar /var/lib/pgsql/
¿î¿µ °èÁ¤À¸·Î Àüȯ
# su - postgres
$ psql
postgres=# CREATE DATABASE dvdrental;
CREATE DATABASE
DB º¹¿ø
$ pg_restore -U postgres -d dvdrental dvdrental.tar °£´Ü ¸í·É¾î Á¤¸® \l : µ¥ÀÌÅͺ£À̽º ¸ñ·ÏÀ» Á¶È¸ \c : ÇöÀç Á¢¼ÓÁ¤º¸ Á¶È¸ \connect µ¥ÀÌÅͺ£À̽º¸í : º£ÀÌÅͺ£À̽º ¼±ÅÃ, ¿¬°á \dt : Å×ÀÌºí ¸ñ·Ï Á¶È¸ \d : °ü°è¸ñ·Ï(Å×À̺í,º¸±â,½ÃÄö½º) Á¶È¸ \d Å×À̺íÀ̸§ : Å×ÀÌºí¿¡°³ÇÑ °³º° Á¤º¸ Á¶È¸ µ¥ÀÌÅÍ Á¶È¸ SELECT "columns" FROM "table"; À§¿Í °°ÀÌ ½Ç½À ȯ°æ°ú µ¥ÀÌÅÍ Äõ¸® ½Ç½ÀÀ» ÁøÇàÇغ¸¾Ò½À´Ï´Ù. °¨»çÇÕ´Ï´Ù. 1u¼¹ö / APC / DB / defog / DEFOG·¢ / dell5820 / dell5820t / dell7920 / dellpoweredge / dellr240 / dellr340 / dellr350 / dellr450 / dellr540 / dellr630 / dellr640 / dellr740 / dellr750 / dellserver / dellt40 / dellt440 / dellt5820 / dell¼¹ö / DELL¼¹öCPU / DELL¼¹öRAIDÄÁÆ®·Ñ·¯ / DELL¼¹öSASÇϵåµð½ºÅ© / DELL¼¹ö°¡°Ýºñ±³ / DELL¼¹ö°¡°Ýºñ±³°ßÀû / DELL¼¹ö°ßÀû / DELL¼¹ö±¸¸Å / DELL¼¹öµð½ºÅ©±³Ã¼ / DELL¼¹ö¸Þ¸ð¸® / DELL¼¹öÆß¿þ¾î / DELL¼¹öÇϵåµð½ºÅ©±¸¸Å / dell¿öÅ©½ºÅ×ÀÌ¼Ç / dl20 / dl20gen10 / dl360 / dl360gen10 / dl380 / dl380g10 / dl380gen10 / ECC¸Þ¸ð¸® / EDFOG·¢°¡°Ý / ESTSOFT / FIRMWARE / gpu¼¹ö / gpuŸ¿öÇü¼¹ö / HA¼Ö·ç¼Ç / hpdl20 / hpdl360 / hpdl360gen10 / hpdl380 / hpdl380g10 / HPE / HPE Service Pack for Proliant / HPE SPP / hpedl20 / hpedl20gen10 / hpedl360gen10 / hpe¼¹ö / HPE¼¹öCPU / HPE¼¹öRAIDÄÁÆ®·Ñ·¯ / HPE¼¹öSASÇϵåµð½ºÅ© / HPE¼¹ö°¡°Ýºñ±³ / HPE¼¹ö°¡°Ýºñ±³°ßÀû / HPE¼¹ö°ßÀû / HPE¼¹ö±¸¸Å / HPE¼¹öµå¶óÀ̹ö¼³Ä¡ / HPE¼¹öµð½ºÅ©±³Ã¼ / HPE¼¹ö¸Þ¸ð¸® / HPE¼¹öºñ¿ë / HPE¼¹öÆß¿þ¾î / HPE¼¹öÇϵåµð½ºÅ©±¸¸Å / hpgen10 / hpml30 / hpserver / hpz2 / hpz4 / hpz420 / hpz440 / hpz4g4 / hpz640 / hpz6g4 / hpz8g4 / hp¸¶ÀÌÅ©·Î¼¹ö / hp¼¹ö / hp¼¹ö800 / hp¼¹ö800w / hp¼¹öcto / hp¼¹öpc / HP¼¹ö¸Þ¸ð¸® / hp¼¹öÄÄÇ»ÅÍ / HP¼¹öÆß¿þ¾î / HP¼¹öÇϵåµð½ºÅ© / hp¿öÅ©½ºÅ×ÀÌ¼Ç / hpÇÁ·Î¶óÀ̾ðÆ® / HYPER BACKUP / ibm¼¹ö / Intelligent Provisioning / KVM / KVM ±â¼úÁö¿øºñ(ºñ¿ë) / KVM ¼³Ä¡ºñ / L2½ºÀ§Ä¡ / L3½ºÀ§Ä¡ / LENONO¼¹öSASÇϵåµð½ºÅ© / lenovop620 / lenovor650 / LENOVO¼¹ö / LENOVO¼¹öCPU / LENOVO¼¹öRAIDÄÁÆ®·Ñ·¯ / LENOVO¼¹ö°¡°Ýºñ±³ / LENOVO¼¹ö°¡°Ýºñ±³°ßÀû / LENOVO¼¹ö°ßÀû / LENOVO¼¹ö±¸¸Å / LENOVO¼¹öµð½ºÅ©±³Ã¼ / LENOVO¼¹ö¸Þ¸ð¸® / LENOVO¼¹öÇϵåµð½ºÅ©±¸¸Å / LENOVOÆß¿þ¾î¾÷µ¥ÀÌÆ® / Linux / ML30 / ml30gen10 / ML350GEN10 / ML360 / MSSQL / MSSQL ±â¼úÁö¿øºñ(ºñ¿ë) / MSSQL ¼³Ä¡ºñ / MYSQL / MySQL ±â¼úÁö¿øºñ(ºñ¿ë) / MySQL ¼³Ä¡ºñ / OS¼³Ä¡ / p17079-b21 / poweredger740 / poweredger750 / precision5820 / QUADRO / QUADRO±×·¡ÇÈÄ«µå / r240 / r340 / r440 / r740 / RHEL¼³Ä¡ / RMS·¢ / server / serverpc / SOPHOS / SPP / sr250 / sr650 / SYNOLOGY / SYNOLOGY³ª½º / UPS / UPS±â¼úÁö¿ø / UPS³³Ç° / UPS¼³Ä¡ / V3 / Windows¼¹ö¼³Ä¡ / z420 / z620 / z840 / z8g4 / ±â¼úÁö¿øºñ(ºñ¿ë) / ³ª½º±â¼úÁö¿ø / ³ª½º¼³Ä¡Áö¿ø / ³×Æ®¿öÅ©½ºÀ§Ä¡ / ³×Æ®¿öÅ©Àåºñ / ´õºíÅ×ÀÌÅ© / µ¥ÀÌÅͺ£À̽º / µ¨5820 / µ¨¼¹ö / µ¨¼¹öºñ¿ë / µ¨¼¹öÆß¿þ¾î¾÷µ¥ÀÌÆ® / µ¨¿öÅ©½ºÅ×ÀÌ¼Ç / µ¨ÄÄÇ»ÅÍ¿öÅ©½ºÅ×ÀÌ¼Ç / µðÆ÷±× / µðÆ÷±×·¢ / µðÆ÷±×·¢°¡°Ý / µö·¯´×pc / µö·¯´×¼¹ö / ·¢ / ·¢(RACK) ±â¼úÁö¿øºñ(ºñ¿ë) / ·¢(RACK) ¼³Ä¡ºñ / ·¢³³Ç°¼³Ä¡ / ·¢¼³Ä¡ / ·¹³ë¹öp620 / ·¹³ë¹ö¼¹ö / ·¹³ë¹ö¿öÅ©½ºÅ×ÀÌ¼Ç / ·¹³ëº¸¼¹ö / ·¹³ëº¸¼¹öÆß¿þ¾î / ·¹µåÇò¼³Ä¡ / ¸®´ª½º ±â¼úÁö¿øºñ(ºñ¿ë) / ¸®´ª½º ¼³Ä¡ºñ / ¸®´ª½º¼¹ö / ¸®´ª½º¼¹ö¼³Ä¡ / ¸®´ª½º¼¹öÆ®·¯ºí½´Æà / ¸®´ª½ºÆ®·¯ºí½´Æà / ¸®¿í½º / ¹Ì´Ï¼¹ö / ¹Ì´Ï¼¹ö·¢ / ¹æȺ® / ¹æȺ® ±â¼úÁö¿øºñ(ºñ¿ë) / ¹æȺ® ¼³Ä¡ºñ / ¹æȺ®¿£Áö´Ï¾î / ¹é¾÷ / º¸¾È¼Ö·ç¼Ç / º¸¾È¼Ö·ç¼Ç±¸¸Å / º¸¾È¼Ö·ç¼Ç¼³Ä¡ / ¼¹ö / ¼¹ö ±â¼úÁö¿øºñ(ºñ¿ë) / ¼¹ö ·¢¸¶¿îÆ®ºñ¿ë / ¼¹ö ¼³Ä¡ºñ / ¼¹ö Àå¾ÖÁ¶Ä¡ºñ¿ë / ¼¹öCPU / ¼¹öMEMORY / ¼¹öOS¼³Ä¡ / ¼¹öpc / ¼¹ö°¡°Ý / ¼¹ö±¸¸Å / ¼¹ö±â¼úÁö¿ø / ¼¹ö³³Ç° / ¼¹öµð½ºÅ©Àå¾Öó¸® / ¼¹ö·¢ / ¼¹ö·º¸¶¿îÆ® / ¼¹ö¸Þ¸ð¸® / ¼¹ö¸ó / ¼¹ö¸ó±â¼úÁö¿ø / ¼¹ö¹é¾÷ / ¼¹öº¸¾È / ¼¹ö¿£Áö´Ï¾î / ¼¹ö¿ëpc / ¼¹ö¿ë±×·¡ÇÈÄ«µå / ¼¹ö¿ë¸Þ¸ð¸® / ¼¹ö¿ëÄÄÇ»ÅÍ / ¼¹ö¿ëÇϵåµð½ºÅ© / ¼¹öÄÄ / ¼¹öÄÄÇ»ÅÍ / ¼¹öÆ®·¯ºí½´Æà / ¼¹öÈ£½ºÆà / ¼ÒÆ÷½º / ½ºÀ§Ä¡ / ½ºÀ§Ä¡ ±â¼úÁö¿øºñ(ºñ¿ë) / ½ºÀ§Ä¡ ¼³Ä¡ºñ / ½ºÅ丮Áö / ½ºÅ丮Áö ±â¼úÁö¿øºñ(ºñ¿ë) / ½ºÅ丮Áö ·¢¸¶¿îÆ®ºñ¿ë / ½ºÅ丮Áö ¼³Ä¡ºñ / ½ºÅ丮Áö Àå¾ÖÁ¶Ä¡ºñ¿ë / ½ºÅ丮Áö³³Ç°¼³Ä¡ / ½ºÅ丮Áö¼¹ö / ½Ã³î·ÎÁöDS918 / ½Ã³î·ÎÁöHyperBackup / ½Ã³î·ÎÁö³ª½º / ½Ã³î·ÎÁö³ª½º¹é¾÷ / ½Ã³î·ÎÁöÇÏÀÌÆÛ¹é¾÷ / ½ÃÅ¥¾îµð½ºÅ© / ¾È·¦ / ¾Ë¾à / ¿Þµµ¿ì¼¹ö¼³Ä¡ / ¿ìºÐÅõ¼³Ä¡ / ¿öÅ©½ºÅ×ÀÌ¼Ç / ¿öÅ©½ºÅ×À̼Çpc / ¿öÅ©½ºÅ×À̼ÇÄÄÇ»ÅÍ / À©µµ¿ì¼¹ö / À©µµ¿ì¼¹ö2016 / À©µµ¿ì¼¹ö2019 / À©µµ¿ì¼¹öÆ®·¯ºí½´Æà / À©µµ¿ìÁî ±â¼úÁö¿øºñ(ºñ¿ë) / À©µµ¿ìÁî ¼³Ä¡ºñ / À̽ºÆ®¼ÒÇÁÆ® / ÀÌÁßȼַç¼Ç / ÀÌÁßȼַç¼Ç±¸¸Å / ÀÌÁßȼַç¼Ç¼³Ä¡ / ÀÎÅͳݵð½ºÅ© / ÀÛ¾÷ÀåÄÄÇ»ÅÍ / Á¦¿Â¼¹ö / Á¨¼¹ö / Áß°í¼¹ö / Áß°í¿öÅ©½ºÅ×ÀÌ¼Ç / Ä«º¸³ªÀÌÆ® / Ä«½ºÆÛ½ºÅ° / ÄÄÇ»Åͼ¹ö / Äõµå·ÎP400 / Ÿ¿öÇü¼¹ö / Æäµµ¶ó¼³Ä¡ / ÇÁ·Î¶óÀ̾ðÆ® / GPU¼¹ö / ¹Ì´Ï¼¹ö·º / ¼¹ö¿ëPC / Á¨¼¹ö / AI¼¹ö / Á¦¿Â¼¹ö / ¼¹ö°¡°Ý / 1U¼¹ö / HPDL20Gen10 / HP¼¹ö8SFF800W / °¡»ó¼¹ö / Ÿ¿öÇü¼¹ö / HPDL360 / HPDL380Gen10 / ÄÄÇ»Åͼ¹ö / ¹Ìµð¾î¼¹ö / Ÿ¿ö¼¹ö / DB¼¹ö / HP¼¹ö580 / HP¼¹öÆÄ¿ö / HPDL360Gen10 / À©µµ¿ì¼¹öÄÄÇ»ÅÍ / XEON¼¹ö / 881457-B21 |
Content |
Name |
Date |
Hits |
---|---|---|---|
|
2023-11-22 |
191 |