\uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud575\uc2ec \uc694\uc18c \uc911 \ud558\ub098\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \uac83\uc774 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ubcf8 \ubb38\uc11c\ub294 \uc6b0\ubd84\ud22c\uc5d0\uc11c MySQL \ubc0f PostgreSQL\uc744 \uc124\uce58\ud558\uace0 \uae30\ubcf8 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc744 \ub2e8\uacc4\ubcc4\ub85c \uc124\uba85\ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uacac\uace0\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud658\uacbd\uc744 \uad6c\ucd95\ud558\uc5ec \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc131\ub2a5\uc744 \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
MySQL\uc740 \uac00\uc7a5 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS)\uc785\ub2c8\ub2e4. SQL(Structured Query Language)\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uba70, \ub9ce\uc740 \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uae30\ubcf8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc0ac\uc6a9\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. MySQL\uc740 \uc548\uc815\uc131\uacfc \uc131\ub2a5\uc774 \ub6f0\uc5b4\ub098\uace0, \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\ub294 \ub370 \ucd5c\uc801\ud654\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
MySQL\uc744 \uc124\uce58\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uc758 \ub2e8\uacc4\ub97c \ub530\ub974\uba74 \ub429\ub2c8\ub2e4. \uc6b0\ubd84\ud22c\uc5d0\uc11c MySQL\uc744 \uc27d\uac8c \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
sudo apt update\nsudo apt install mysql-server<\/code><\/pre>\n\uc704 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uba74 MySQL \uc11c\ubc84\uac00 \uc124\uce58\ub429\ub2c8\ub2e4. \uc124\uce58\uac00 \uc644\ub8cc\ub418\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub85c MySQL \uc11c\ube44\uc2a4\ub97c \uc2dc\uc791\ud569\ub2c8\ub2e4.<\/p>\n
sudo systemctl start mysql<\/code><\/pre>\n1.3 MySQL \ubcf4\uc548 \uc124\uc815<\/h3>\n
MySQL \uc124\uce58\uac00 \uc644\ub8cc\ub418\uba74, \ub2e4\uc74c \ub2e8\uacc4\ub85c MySQL\uc758 \ubcf4\uc548 \uc124\uc815\uc744 \uc9c4\ud589\ud569\ub2c8\ub2e4. MySQL\uc740 \uc548\uc804\ud558\uc9c0 \uc54a\uc740 \uc0ac\uc6a9\uc790 \ubc0f \uc554\ud638 \uc124\uc815\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574 mysql_secure_installation<\/code> \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\nsudo mysql_secure_installation<\/code><\/pre>\n\uc704 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uba74, \ubcf4\uc548 \uad00\ub828 \uc9c8\ubb38\ub4e4\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uac01 \uc9c8\ubb38\uc5d0 \ub300\ud574 \uc801\uc808\ud558\uac8c \ub2f5\ubcc0\ud558\uc5ec \ubcf4\uc548\uc744 \uac15\ud654\ud574\uc57c \ud569\ub2c8\ub2e4. \ubcf4\ud1b5 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0ac\ud56d\uc744 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
\n- \ub8e8\ud2b8 \uc0ac\uc6a9\uc790 \uc554\ud638 \uc124\uc815<\/li>\n
- \uc775\uba85 \uc0ac\uc6a9\uc790 \uc81c\uac70<\/li>\n
- \uc6d0\uaca9 \ub8e8\ud2b8 \ub85c\uadf8\uc778 \uae08\uc9c0<\/li>\n
- \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uac70<\/li>\n
- \uad8c\ud55c \ud14c\uc774\ube14 \uac31\uc2e0<\/li>\n<\/ul>\n
1.4 MySQL \uae30\ubcf8 \uc124\uc815<\/h3>\n
MySQL\uc5d0 \uc811\uc18d\ud558\uae30 \uc704\ud574 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n
sudo mysql -u root -p<\/code><\/pre>\n\ub8e8\ud2b8 \uc554\ud638\ub97c \uc785\ub825\ud558\uba74 MySQL \uc178\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9cc\ub4e4\uace0 \uc0ac\uc6a9\uc790 \uad8c\ud55c\uc744 \uc124\uc815\ud558\ub294 \uae30\ubcf8 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
1.4.1 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131<\/h4>\nCREATE DATABASE example_db;<\/code><\/pre>\n1.4.2 \uc0ac\uc6a9\uc790 \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec<\/h4>\nCREATE USER 'example_user'@'localhost' IDENTIFIED BY 'password';\nGRANT ALL PRIVILEGES ON example_db.* TO 'example_user'@'localhost';<\/code><\/pre>\n1.4.3 \ubcc0\uacbd\uc0ac\ud56d \uc801\uc6a9<\/h4>\nFLUSH PRIVILEGES;<\/code><\/pre>\n\uc774\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0ac\uc6a9\uc790\uac00 \uc131\uacf5\uc801\uc73c\ub85c \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4. MySQL\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
2. PostgreSQL \uc124\uce58 \ubc0f \uae30\ubcf8 \uc124\uc815<\/h2>\n2.1 PostgreSQL\uc774\ub780?<\/h3>\n
PostgreSQL\uc740 \uc624\ud508 \uc18c\uc2a4 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc73c\ub85c, \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc640 \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \uac15\ub825\ud55c \ub2a5\ub825\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c, \uace0\uae09 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ub2a5(\ud2b8\ub79c\uc7ad\uc158, ACID \uc900\uc218 \ub4f1)\uc744 \uc9c0\uc6d0\ud558\uc5ec \uc548\uc815\uc131\uacfc \uc720\uc5f0\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n
2.2 PostgreSQL \uc124\uce58<\/h3>\n
\uc6b0\ubd84\ud22c\uc5d0\uc11c PostgreSQL\uc740 \ub2e4\uc74c\uc758 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc27d\uac8c \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
sudo apt update\nsudo apt install postgresql postgresql-contrib<\/code><\/pre>\n\uc124\uce58\uac00 \uc644\ub8cc\ub418\uba74 PostgreSQL \uc11c\ube44\uc2a4\uac00 \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ub429\ub2c8\ub2e4.<\/p>\n
2.3 PostgreSQL \ubcf4\uc548 \uc124\uc815<\/h3>\n
PostgreSQL\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \uc288\ud37c\uc720\uc800 \uacc4\uc815\uc774 \uc874\uc7ac\ud569\ub2c8\ub2e4. PostgreSQL\uc758 \uae30\ubcf8 \uc288\ud37c\uc720\uc800\ub294 postgres<\/code>\uc785\ub2c8\ub2e4. \uc774 \uacc4\uc815\uc758 \ube44\ubc00\ubc88\ud638\ub97c \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\nsudo -u postgres psql<\/code><\/pre>\nPostgreSQL \uc178\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ube44\ubc00\ubc88\ud638\ub97c \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n
ALTER USER postgres PASSWORD 'newpassword';<\/code><\/pre>\n2.4 PostgreSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \uc0ac\uc6a9\uc790 \uc0dd\uc131<\/h3>\n
\uc774\uc81c PostgreSQL \uc178\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0ac\uc6a9\uc790\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
2.4.1 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131<\/h4>\nCREATE DATABASE example_db;<\/code><\/pre>\n2.4.2 \uc0ac\uc6a9\uc790 \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec<\/h4>\nCREATE USER example_user WITH PASSWORD 'password';\nGRANT ALL PRIVILEGES ON DATABASE example_db TO example_user;<\/code><\/pre>\n\uc774\uc81c PostgreSQL\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud65c\uc6a9\ud558\uac8c \ub418\uba74, \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc694\uad6c\uc0ac\ud56d\uc5d0 \ub530\ub77c \uc801\ud569\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
3. MySQL\uacfc PostgreSQL \ube44\uad50<\/h2>\n
MySQL\uacfc PostgreSQL\uc740 \ubaa8\ub450 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc774\uc9c0\ub9cc, \uac01\uac01\uc758 \uc7a5\ub2e8\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \ub450 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc8fc\uc694 \ucc28\uc774\uc810\uc785\ub2c8\ub2e4:<\/p>\n
\n\n\ud2b9\uc9d5<\/th>\n MySQL<\/th>\n PostgreSQL<\/th>\n<\/tr>\n \n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\ud615<\/td>\n \uad00\uacc4\ud615<\/td>\n \uad00\uacc4\ud615 \ubc0f \ube44\uad00\uacc4\ud615<\/td>\n<\/tr>\n \nACID \uc900\uc218<\/td>\n \uc6b0\uc120\uc801\uc73c\ub85c \uc9c0\uc6d0<\/td>\n \uc644\ubcbd\ud55c ACID \uc900\uc218<\/td>\n<\/tr>\n \n\ub370\uc774\ud130 \ubb34\uacb0\uc131 \uc81c\uc57d\uc870\uac74<\/td>\n \uc81c\ud55c\uc801 \uc9c0\uc6d0<\/td>\n \uc804\ubb38\uc801\uc778 \uc9c0\uc6d0<\/td>\n<\/tr>\n \n\ubcf5\uc7a1\ud55c \ucffc\ub9ac<\/td>\n \uc81c\ud55c\uc801<\/td>\n \uac15\ub825\ud55c \uc9c0\uc6d0<\/td>\n<\/tr>\n<\/table>\n\uc5b4\ub5a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud560\uc9c0\ub294 \ud504\ub85c\uc81d\ud2b8\uc758 \uc694\uad6c\uc0ac\ud56d\uacfc \uaddc\ubaa8\uc5d0 \ub530\ub77c \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4. MySQL\uc740 \uac04\ub2e8\ud55c \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \uc801\ud569\ud558\uba70, PostgreSQL\uc740 \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \uad6c\uc870\uc640 \ub192\uc740 \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/p>\n
4. \uacb0\ub860<\/h2>\n
\uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 \uc6b0\ubd84\ud22c\uc5d0\uc11c MySQL \ubc0f PostgreSQL\uc744 \uc124\uce58\ud558\uace0 \uae30\ubcf8 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uac01 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc7a5\ub2e8\uc810\uc744 \ube44\uad50\ud558\uace0, \uc0ac\uc6a9\uc790 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc131\uacf5\uc801\uc73c\ub85c \uc6b4\uc601\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uac00 \ud544\uc218\uc801\uc774\ubbc0\ub85c, \ud544\uc694\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \uc120\ud0dd\ud558\uace0 \uc801\uc808\ud55c \uc124\uc815\uc744 \ud1b5\ud574 \uc548\uc815\uc801\uc778 \ud658\uacbd\uc744 \ub9c8\ub828\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ucd94\uac00\uc801\uc778 \uc9c8\ubb38\uc774\ub098 \ub3c4\uc6c0\uc774 \ud544\uc694\ud55c \uacbd\uc6b0, \uacf5\uc2dd \ubb38\uc11c\ub098 \ucee4\ubba4\ub2c8\ud2f0 \ud3ec\ub7fc\uc744 \ucc38\uc870\ud558\ub294 \uac83\ub3c4 \uc88b\uc740 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"