일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
- maven
- JavaScript
- Open Source
- Python
- MySQL
- oracle
- Source
- ubuntu
- jpa
- Exception
- IntelliJ
- 설정
- Tomcat
- git
- Core Java
- JDBC
- Thymeleaf
- spring
- Spring Boot
- PostgreSQL
- Docker
- myBatis
- 오픈소스
- error
- 문서
- MSSQL
- Eclipse
- STS
- SpringBoot
- AJAX
- Today
- Total
헤르메스 LIFE
[SpringBoot] Docker에 PostgreSQL 설치 / 연결하기 본문
IDE : IntelliJ
JDK : OpenJDK 11
Framework : Spring Boot 2.5.2
Database : PostgreSQL 최신버전 ( 라이센스도 소스공개의무도 없음 )
첨부파일이 MySqlRunner 로 되어있는데.. MySQL 접속테스트 중 소스만 바뀐거라.. ㅎㅎ
Docker 설치
https://hermeslog.tistory.com/497?category=302346
Docker에 PostgreSQL 설치 ( 영문버전 )
? postgresql 을 다운로드
C:\>docker pull postgres
? 다운로드된 Images 확인
C:\>docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
mysql latest d1dc36cf8d9e 9 months ago 519MB
postgres <none> e94a3bb61224 11 months ago 374MB
? Docker postgres 컨테이너 생성
? -d : 백그라운드 실행
? -p 포트 포딩 5432번 포트로 들어온 내용은 5432 번 포트로 포딩을 해주겟다는 내용
? -e 환경변수 설정 POSTRGRES_PASSWORD= 내용을 password로 설정
? --name Container 이름을 설정해줍니다.
? docker exec -> run a command on an existing/running container
? docker run -> create a new container from an image, and run the command there
C:\>docker run -p 5432:5432 --name postgres_boot -e POSTGRES_DB=springboot -e POSTGRES_USER=hermeswing -e POSTGRES_PASSWORD=pass -d postgres
? docker에 설치된 컨테이너 목록 조회
C:\>docker ps -a
? Docker 접속
C:\>docker exec -it postgres_boot bash
root@38b74b264559:/#
? Docker OS 환경 확인
? grep -n . /etc/*-release
root@38b74b264559:/# grep -n . /etc/*-release
1:PRETTY_NAME="Debian GNU/Linux 11 (bullseye)"
2:NAME="Debian GNU/Linux"
3:VERSION_ID="11"
4:VERSION="11 (bullseye)"
5:VERSION_CODENAME=bullseye
6:ID=debian
7:HOME_URL="https://www.debian.org/"
8:SUPPORT_URL="https://www.debian.org/support"
9:BUG_REPORT_URL="https://bugs.debian.org/"
? locale 설치하기
? apt-get -y update
? apt-get install -y locales
root@38b74b264559:/# apt-get -y update
Get:1 http://security.debian.org/debian-security bullseye-security InRelease [48.4 kB]
Get:2 http://deb.debian.org/debian bullseye InRelease [116 kB]
Get:3 http://deb.debian.org/debian bullseye-updates InRelease [44.1 kB]
Get:4 http://security.debian.org/debian-security bullseye-security/main amd64 Packages [237 kB]
Get:5 http://deb.debian.org/debian bullseye/main amd64 Packages [8,183 kB]
Get:6 http://deb.debian.org/debian bullseye-updates/main amd64 Packages [14.6 kB]
Get:7 http://apt.postgresql.org/pub/repos/apt bullseye-pgdg InRelease [116 kB]
Get:8 http://apt.postgresql.org/pub/repos/apt bullseye-pgdg/main amd64 Packages [269 kB]
Get:9 http://apt.postgresql.org/pub/repos/apt bullseye-pgdg/14 amd64 Packages [2,577 B]
Fetched 9,031 kB in 5s (1,688 kB/s)
Reading package lists... Done
root@38b74b264559:/# apt-get install -y locales
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages will be upgraded:
locales
1 upgraded, 0 newly installed, 0 to remove and 56 not upgraded.
Need to get 4,086 kB of archives.
After this operation, 0 B of additional disk space will be used.
Get:1 http://deb.debian.org/debian bullseye/main amd64 locales all 2.31-13+deb11u5 [4,086 kB]
Fetched 4,086 kB in 0s (9,814 kB/s)
debconf: delaying package configuration, since apt-utils is not installed
(Reading database ... 12073 files and directories currently installed.)
Preparing to unpack .../locales_2.31-13+deb11u5_all.deb ...
Unpacking locales (2.31-13+deb11u5) over (2.31-13+deb11u2) ...
Setting up locales (2.31-13+deb11u5) ...
debconf: unable to initialize frontend: Dialog
debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78.)
debconf: falling back to frontend: Readline
Generating locales (this might take a while)...
Generation complete.
? 현재 사용할 수 있는 locale 확인
? locale -a
root@38b74b264559:/# locale -a
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_COLLATE to default locale: No such file or directory
C
C.UTF-8
POSIX
? debian OS 에서 locale 생성
? localedef -f UTF-8 -i ko_KR ko_KR.UTF-8
root@38b74b264559:/# localedef -f UTF-8 -i ko_KR ko_KR.UTF-8
root@38b74b264559:/# locale -a
C
C.UTF-8
POSIX
ko_KR.utf8
? Docker 컨테이너 실행 / 접속
C:\>docker exec -it postgres_boot bash
root@38b74b264559:/# >su - postgres
root@38b74b264559:/# >psql --username hermeswing --dbname springboot
? Docker 컨테이너 멈춤
C:\>docker stop postgres_boot
? Docker 컨테이너 시작
C:\>docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
68a29cd6a49a redis "docker-entrypoint.s…" 21 hours ago Exited (0) 17 hours ago redis_boot
8870b3eecebd postgres-ko:14.1 "docker-entrypoint.s…" 21 hours ago Exited (0) 17 hours ago postgres_boot
? Docker 컨테이너 시작
# docker start -a [CONTAINER ID 또는 NAMES]
C:\>docker start -a postgres_boot
? Docker 컨테이너 삭제
C:\>docker rm postgres_boot
? 테이블 목록조회 : \l, \list
springboot=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------+------------+----------+------------+------------+---------------------------
postgres | hermeswing | UTF8 | en_US.utf8 | en_US.utf8 |
springboot | hermeswing | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | hermeswing | UTF8 | en_US.utf8 | en_US.utf8 | =c/hermeswing +
| | | | | hermeswing=CTc/hermeswing
template1 | hermeswing | UTF8 | en_US.utf8 | en_US.utf8 | =c/hermeswing +
| | | | | hermeswing=CTc/hermeswing
(4 rows)
Default 설정으로 설치된 PostgreSQL에서도 한글은 잘 등록됩니다.
PostgreSQL에서 EUC-KR 을 지원하기 때문에 한글에 문제가 없으리라 생각됩니다. 하지만, Locale 문제는 어디서 문제가 생길지 모르기 때문에 ko_KR.UTF-8로 설정하는게 좋을 것 같습니다.
생성하는 방법은 여기를 참고했습니다.
Docker에 PostgreSQL 설치 ( 한글버전 )
Dockerfile 생성 ( C:\Temp 폴더에 Dockerfile 파일을 생성했습니다. )
# 한글 Docker 파일을 생성할 폴더로 이동
$ cd C:\Temp
# 한글 Docker 파일이 생성될 폴더 생성
$ copy con Dockerfile
# 사설저장소를 사용하는 경우 아래 FROM 수정 필요
# FROM 사설저장소주소:포트/postgres:14.1
# Version이 업그레이드 됐습니다. 16.3 으로..
# FROM postgres:14.1
FROM postgres:16.3
RUN ln -sf /usr/share/zoneinfo/Asia/Seoul /etc/localtime && \
sed -i 's/# ko_KR.UTF-8 UTF-8/ko_KR.UTF-8 UTF-8/' /etc/locale.gen && \
locale-gen
ENV LANG=ko_KR.utf8 \
LC_COLLATE=ko_KR.utf8 \
POSTGRES_INITDB_ARGS=--data-checksums
^z
Docker 이미지 생성 ( Dockerfile 이 존재하는 폴더에서 명령을 실행해야 합니다. )
# C:\Temp>docker build -t postgres-ko:14.1 .
C:\Temp>docker build -t postgres-ko:16.3 .
[+] Building 2.2s (6/6) FINISHED docker:desktop-linux
=> [internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 425B 0.0s
=> [internal] load metadata for docker.io/library/postgres:16.3 2.1s
=> [internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [1/2] FROM docker.io/library/postgres:16.3@sha256:0aafd2ae7e6c391f39fb6b7621632d79f54068faebc726caf469e87bd1d301c0 0.0s
=> CACHED [2/2] RUN ln -sf /usr/share/zoneinfo/Asia/Seoul /etc/localtime && sed -i 's/# ko_KR.UTF-8 UTF-8/ko_KR.UTF-8 UTF-8/' /etc/locale.gen && locale-gen 0.0s
=> exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:64b72b4c30a6979d45d17a23efa8deca7a9d382ebc445e9ae7fac5ab6db9c6b0 0.0s
=> => naming to docker.io/library/postgres-ko:16.3 0.0s 0.0s
C:\Temp>docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
postgres-ko 16.3 64b72b4c30a6 9 minutes ago 436MB
ubuntu latest 08d22c0ceb15 5 weeks ago 77.8MB
redis latest 3358aea34e8c 5 months ago 117MB
mysql latest d1dc36cf8d9e 14 months ago 519MB
postgres <none> e94a3bb61224 16 months ago 374MB
postgres-ko Images가 생성된걸 확인 할 수 있습니다.
postgres-ko 설치
? Docker Containers 를 삭제하더라도 데이터는 남겨두고,
? 다시 사용할 수 있도록 하기위해 절대경로에 데이터를 남겨두기로 합니다.
? c:\Temp\data\postgresql 를 생성합니다.
# C:\Temp>docker run -p 5432:5432 --name postgres_boot -e POSTGRES_DB=springboot -e POSTGRES_USER=hermeswing -e POSTGRES_PASSWORD=pass -d postgres-ko:14.1
C:\Temp>docker run -p 5432:5432 --name postgres_boot -e POSTGRES_DB=springboot -e POSTGRES_USER=hermeswing -e POSTGRES_PASSWORD=pass -v c:\Temp\data\postgresql:/var/lib/postgresql/data -d postgres-ko:16.3
36e399118658fa438bba67805c3dea453f6be859b9e1fa65bd09ec16b3bb369f
C:\Temp>docker exec -it postgres_boot bash
root@36e399118658:/# grep -n . /etc/*-release
1:PRETTY_NAME="Debian GNU/Linux 11 (bullseye)"
2:NAME="Debian GNU/Linux"
3:VERSION_ID="11"
4:VERSION="11 (bullseye)"
5:VERSION_CODENAME=bullseye
6:ID=debian
7:HOME_URL="https://www.debian.org/"
8:SUPPORT_URL="https://www.debian.org/support"
9:BUG_REPORT_URL="https://bugs.debian.org/"
root@36e399118658:/# locale -a
C
C.UTF-8
POSIX
ko_KR.utf8
root@5dc09d756a3f:/# psql --username hermeswing --dbname springboot
psql (16.3 (Debian 16.3-1.pgdg120+1))
도움말을 보려면 "help"를 입력하십시오.
springboot=# \l
데이터베이스 목록
이름 | 소유주 | 인코딩 | Collate | Ctype | 액세스 권한
------------+------------+--------+------------+------------+---------------------------
postgres | hermeswing | UTF8 | ko_KR.utf8 | ko_KR.utf8 |
springboot | hermeswing | UTF8 | ko_KR.utf8 | ko_KR.utf8 |
template0 | hermeswing | UTF8 | ko_KR.utf8 | ko_KR.utf8 | =c/hermeswing +
| | | | | hermeswing=CTc/hermeswing
template1 | hermeswing | UTF8 | ko_KR.utf8 | ko_KR.utf8 | =c/hermeswing +
| | | | | hermeswing=CTc/hermeswing
(4개 행)
springboot=#
ko_KR.utf8로 설치된걸 확인할 수 있습니다.
오류메시지도 한글로 보여지네요.
org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #2 of URL [file:/C:/Octopus/workspace/octopus_bbs/bin/main/initdata/schema-postgresql.sql]: CREATE TABLE IF NOT EXISTS T_BOARD_M ( ID SERIAL NOT NULL, TITLE VARCHAR(200) NOT NULL, CONTENTS TEXT NOT NULL, READ_CNT INTEGER NOT NULL DEFAULT 0 , CRT_ID VARCHAR(20), CRT_DT TIMESTAMP, MDF_ID VARCHAR(20), MDF_DT TIMESTAMP, CONSTRAINT T_BOARD_M PRIMARY KEY (ID) ); nested exception is org.postgresql.util.PSQLException: 오류: "t_board_m" 이름의 릴레이션(relation)이 이미 있습니다
postgres-ko 백업 ( 관리자 계정으로 실행 해야 합니다. )
# Docker 컨테이너 확인
C:\Temp>docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
fa9404a86466 postgres-ko:16.3 "docker-entrypoint.s…" 3 hours ago Exited (255) 2 hours ago 0.0.0.0:5432->5432/tcp postgres_boot
d873e6ae5123 redis "docker-entrypoint.s…" 3 hours ago Exited (255) 2 hours ago 0.0.0.0:6379->6379/tcp redis_boot
# Docker 이미지 백업
# docker commit [컨테이너 이름 또는 ID] [백업 이미지 이름:태그]
# docker save -o c:\temp\postgres.tar postgres:latest
C:\Temp>docker save -o c:\temp\postgres-ko-16.3.tar postgres-ko:16.3
# 데이터 볼륨 백업
# tar -cvf [백업파일 경로\파일명] [볼륨경로]
# 참조
# C:\Temp>docker run -p 5432:5432 --name postgres_boot -e POSTGRES_DB=springboot -e POSTGRES_USER=hermeswing -e POSTGRES_PASSWORD=pass -v c:\Temp\data\postgresql:/var/lib/postgresql/data -d postgres-ko:16.3
C:\Temp>tar -cvf c:\Temp\postgres-ko-volume.tar c:\Temp\data\postgresql
정기백업을 위한 Windows Command ( 관리자 계정으로 실행 해야 합니다. )
@echo off
:: 백업 경로 설정
set BACKUP_DIR=C:\Temp\Docker_Backup
set B_DATE=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%
:: 백업 폴더가 없으면 생성
if not exist "%BACKUP_DIR%" (
mkdir "%BACKUP_DIR%"
)
:: Docker 이미지 백업
set IMAGE_NAME=postgres-ko:16.3
set IMAGE_BACKUP_PATH=%BACKUP_DIR%\postgres-ko-16.3_%B_DATE%.tar
echo Docker 이미지 백업 중: %IMAGE_BACKUP_PATH%
docker save -o %IMAGE_BACKUP_PATH% %IMAGE_NAME%
if %ERRORLEVEL% neq 0 (
echo Docker 이미지 백업 실패
exit /b 1
)
echo Docker 이미지 백업 완료: %IMAGE_BACKUP_PATH%
:: Docker 볼륨 백업
set CONTAINER_NAME=postgres_boot
set VOLUME_BACKUP_PATH=%BACKUP_DIR%\postgres-ko-16.3_%B_DATE%_volume.tar
:: 컨테이너에서 볼륨 경로를 찾음
for /f "tokens=*" %%i in ('docker inspect --format "{{ range .Mounts }}{{ .Source }}{{ end }}" %CONTAINER_NAME%') do (
set VOLUME_PATH=%%i
)
if not defined VOLUME_PATH (
echo 볼륨 경로를 찾을 수 없습니다.
exit /b 1
)
echo Docker 볼륨 백업 중: %VOLUME_BACKUP_PATH%
tar -cvf %VOLUME_BACKUP_PATH% -C %VOLUME_PATH% .
if %ERRORLEVEL% neq 0 (
echo Docker 볼륨 백업 실패
exit /b 1
)
echo Docker 볼륨 백업 완료: %VOLUME_BACKUP_PATH%
echo 모든 백업이 완료되었습니다.
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.5.2</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.mysql</groupId>
<artifactId>MySqlRunner</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>MySqlRunner</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>11</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
server.port=9090
spring.datasource.hikari.maximum-pool-size=4
# PostgreSQL DB 설정
spring.datasource.url=jdbc:postgresql://localhost:5432/springboot
spring.datasource.username=hermeswing
spring.datasource.password=pass
package com.mysql.mysqlrunner.runner;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.ApplicationArguments;
import org.springframework.boot.ApplicationRunner;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
@Component
public class PostgresRunner implements ApplicationRunner {
@Autowired
DataSource dataSource;
@Autowired
JdbcTemplate jdbcTemplate;
@Override
public void run( ApplicationArguments args ) {
try {
Connection connection = dataSource.getConnection();
System.out.println( connection.getMetaData().getClass() );
System.out.println( connection.getMetaData().getDriverName() );
System.out.println( connection.getMetaData().getURL() );
System.out.println( connection.getMetaData().getUserName() );
Statement statement = connection.createStatement();
String sql = "CREATE TABLE ACCOUNT(ID INTEGER NOT NULL, NAME VARCHAR(255), PRIMARY KEY(ID))";
statement.executeUpdate( sql );
jdbcTemplate.execute( "INSERT INTO ACCOUNT VALUES (1, 'hermeswing')" );
} catch( Exception e ) {
e.printStackTrace();
}
}
}
#>psql --username hermeswing --dbname springboot
psql (13.3 (Debian 13.3-1.pgdg100+1))
Type "help" for help.
springboot=#
? 테이블 목록조회 : \l, \list
springboot=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------+------------+----------+------------+------------+---------------------------
postgres | hermeswing | UTF8 | en_US.utf8 | en_US.utf8 |
springboot | hermeswing | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | hermeswing | UTF8 | en_US.utf8 | en_US.utf8 | =c/hermeswing +
| | | | | hermeswing=CTc/hermeswing
template1 | hermeswing | UTF8 | en_US.utf8 | en_US.utf8 | =c/hermeswing +
| | | | | hermeswing=CTc/hermeswing
(4 rows)
? 테이블 목록조회 : \dt
springboot=# \dt
Did not find any relations.
? 실행시킨 후 테이블 목록조회 : \dt
springboot=# \dt
List of relations
Schema | Name | Type | Owner
--------+---------+-------+------------
public | account | table | hermeswing
(1 row)
springboot=# select *
springboot-# from account;
id | name
----+------------
1 | hermeswing
(1 row)
springboot=#
테이블 생성 예제
C:\Temp>docker exec -it postgres_boot bash
root@3deb323864bb:/# psql --username hermeswing --dbname springboot
psql (14.1 (Debian 14.1-1.pgdg110+1))
도움말을 보려면 "help"를 입력하십시오.
springboot=# \list
데이터베이스 목록
이름 | 소유주 | 인코딩 | Collate | Ctype | 액세스 권한
------------+------------+--------+------------+------------+---------------------------
postgres | hermeswing | UTF8 | ko_KR.utf8 | ko_KR.utf8 |
springboot | hermeswing | UTF8 | ko_KR.utf8 | ko_KR.utf8 |
template0 | hermeswing | UTF8 | ko_KR.utf8 | ko_KR.utf8 | =c/hermeswing +
| | | | | hermeswing=CTc/hermeswing
template1 | hermeswing | UTF8 | ko_KR.utf8 | ko_KR.utf8 | =c/hermeswing +
| | | | | hermeswing=CTc/hermeswing
(4개 행)
springboot=# \dt
관련 릴레이션 찾을 수 없음.
springboot=# CREATE TABLE employees (
employee_id SERIAL PRIMARY KEY,
name VARCHAR(100),
age INT,
position VARCHAR(100)
);
CREATE TABLE
springboot=# \dt
릴레이션(relation) 목록
스키마 | 이름 | 종류 | 소유주
--------+-----------+--------+------------
public | employees | 테이블 | hermeswing
(1개 행)
springboot=# INSERT INTO employees (name, age, position) VALUES
('John Doe', 35, 'Manager'),
('Jane Smith', 28, 'Engineer'),
('Michael Johnson', 40, 'Analyst'),
('Emily Davis', 33, 'Developer'),
('Christopher Wilson', 45, 'Director'),
('Jessica Brown', 30, 'Designer'),
('Daniel Taylor', 38, 'Project Manager'),
('Sarah Martinez', 32, 'Software Engineer'),
('Kevin Anderson', 36, 'Consultant'),
('Amanda Thomas', 31, 'Administrator');
INSERT 0 10
springboot=# \dt
릴레이션(relation) 목록
스키마 | 이름 | 종류 | 소유주
--------+-----------+--------+------------
public | employees | 테이블 | hermeswing
(1개 행)
springboot=# select *
springboot-# from employees;
employee_id | name | age | position
-------------+--------------------+-----+-------------------
1 | John Doe | 35 | Manager
2 | Jane Smith | 28 | Engineer
3 | Michael Johnson | 40 | Analyst
4 | Emily Davis | 33 | Developer
5 | Christopher Wilson | 45 | Director
6 | Jessica Brown | 30 | Designer
7 | Daniel Taylor | 38 | Project Manager
8 | Sarah Martinez | 32 | Software Engineer
9 | Kevin Anderson | 36 | Consultant
10 | Amanda Thomas | 31 | Administrator
(10개 행)
springboot=#
POSTGRES_DB, POSTGRES_USER, POSTGRES_PASSWORD 등등에 오타가 있을 때 아래와 같은 오류를 만날 수 있습니다.
? POSTGRES_DB, POSTGRES_USER, POSTGRES_PASSWORD 등등에 오타가 있을 때 아래와 같은 오류를 만날 수 있습니다.
? 오타가 있어서 생성이 안된겁니다.
$>docker exec -it postgres_boot bash
Error response from daemon: Container 999323c0e0b300b181c91b2b4e47ad6e0e00aca34e76b5f85e1629a6028af363 is not running
?POSTGRES_PASSWORD 에 오타가 있을 때 아래와 같은 오류를 만날 수 있습니다.
? 일단 실행은 되지만 권한이 없는거죠.
$>docker run -it postgres_boot bash
Unable to find image 'postgres_boot:latest' locally
docker: Error response from daemon: pull access denied for postgres_boot, repository does not exist or may require 'docker login': denied: requested access to the resource is denied.
See 'docker run --help'.
? POSTGRESQL에 접속이 안될 경우가 발생합니다. 최신버전이라 명시적으로 명령을 처리해야 합니다.
? #>psql --username hermeswing --dbname springboot
$>psql springboot
psql: error: FATAL: role "postgres" does not exist
참고 : 백기선님의 스프링 부트 개념과 활용
'Spring Framework' 카테고리의 다른 글
[Spring Cloud Netflix] Eureka Service 샘플 (2) | 2024.03.27 |
---|---|
[Log] Log4Jdbc 설정 (0) | 2024.02.23 |
[Redis] Docker에 Redis 설치하기 + 비밀번호 (0) | 2024.01.30 |
[전자정부프레임워크] 샘플 프로젝트 생성 dev4.1 (0) | 2023.06.27 |
[전자정부프레임워크] 전자정부프레임워크 설치 (0) | 2023.06.22 |