Postgresql/설치

pgBackRest 설치

dbavayne 2025. 3. 15. 12:34

환경: Ubuntu, PostgreSQL 15

  1. pgBackRest 설치 확인
    sudo apt update
    sudo apt install pgbackrest
    pgbackrest version
postgres@lkmpg:~$ sudo apt update
Get:1 http://security.ubuntu.com/ubuntu noble-security InRelease [126 kB]
Hit:2 http://kr.archive.ubuntu.com/ubuntu noble InRelease
Get:3 http://security.ubuntu.com/ubuntu noble-security/main amd64 Packages [670 kB]
Get:4 http://kr.archive.ubuntu.com/ubuntu noble-updates InRelease [126 kB]
Get:5 https://apt.postgresql.org/pub/repos/apt noble-pgdg InRelease [129 kB]
Get:6 http://security.ubuntu.com/ubuntu noble-security/main Translation-en [130 kB]
Get:7 http://security.ubuntu.com/ubuntu noble-security/main amd64 Components [8,960 B]
Get:8 http://security.ubuntu.com/ubuntu noble-security/main amd64 c-n-f Metadata [6,912 B]
Get:9 http://security.ubuntu.com/ubuntu noble-security/restricted amd64 Packages [726 kB]
Get:10 http://kr.archive.ubuntu.com/ubuntu noble-backports InRelease [126 kB]
Get:11 http://security.ubuntu.com/ubuntu noble-security/restricted Translation-en [146 kB]
Get:12 https://apt.postgresql.org/pub/repos/apt noble-pgdg/main amd64 Packages [309 kB]
Get:13 http://security.ubuntu.com/ubuntu noble-security/restricted amd64 Components [212 B]
Get:14 http://security.ubuntu.com/ubuntu noble-security/restricted amd64 c-n-f Metadata [432 B]
Get:15 http://security.ubuntu.com/ubuntu noble-security/universe amd64 Packages [819 kB]
Get:16 http://security.ubuntu.com/ubuntu noble-security/universe Translation-en [177 kB]
Get:17 http://security.ubuntu.com/ubuntu noble-security/universe amd64 Components [51.9 kB]
Get:18 http://security.ubuntu.com/ubuntu noble-security/universe amd64 c-n-f Metadata [16.9 kB]
Get:19 http://security.ubuntu.com/ubuntu noble-security/multiverse amd64 Components [212 B]
Get:20 http://security.ubuntu.com/ubuntu noble-security/multiverse amd64 c-n-f Metadata [448 B]
Get:21 http://kr.archive.ubuntu.com/ubuntu noble-updates/main amd64 Packages [919 kB]
Get:22 http://kr.archive.ubuntu.com/ubuntu noble-updates/main Translation-en [208 kB]
Get:23 http://kr.archive.ubuntu.com/ubuntu noble-updates/main amd64 Components [151 kB]
Get:24 http://kr.archive.ubuntu.com/ubuntu noble-updates/main amd64 c-n-f Metadata [13.4 kB]
Get:25 http://kr.archive.ubuntu.com/ubuntu noble-updates/restricted amd64 Packages [759 kB]
Get:26 http://kr.archive.ubuntu.com/ubuntu noble-updates/restricted Translation-en [153 kB]
Get:27 http://kr.archive.ubuntu.com/ubuntu noble-updates/restricted amd64 Components [212 B]
Get:28 http://kr.archive.ubuntu.com/ubuntu noble-updates/restricted amd64 c-n-f Metadata [464 B]
Get:29 http://kr.archive.ubuntu.com/ubuntu noble-updates/universe amd64 Packages [1,037 kB]
Get:30 http://kr.archive.ubuntu.com/ubuntu noble-updates/universe Translation-en [261 kB]
Get:31 http://kr.archive.ubuntu.com/ubuntu noble-updates/universe amd64 Components [364 kB]
Get:32 http://kr.archive.ubuntu.com/ubuntu noble-updates/universe amd64 c-n-f Metadata [25.8 kB]
Get:33 http://kr.archive.ubuntu.com/ubuntu noble-updates/multiverse amd64 Components [940 B]
Get:34 http://kr.archive.ubuntu.com/ubuntu noble-updates/multiverse amd64 c-n-f Metadata [656 B]
Get:35 http://kr.archive.ubuntu.com/ubuntu noble-backports/main amd64 Components [208 B]
Get:36 http://kr.archive.ubuntu.com/ubuntu noble-backports/restricted amd64 Components [216 B]
Get:37 http://kr.archive.ubuntu.com/ubuntu noble-backports/universe amd64 Components [20.0 kB]
Get:38 http://kr.archive.ubuntu.com/ubuntu noble-backports/universe amd64 c-n-f Metadata [1,256 B]
Get:39 http://kr.archive.ubuntu.com/ubuntu noble-backports/multiverse amd64 Components [212 B]
Fetched 7,484 kB in 10s (764 kB/s)

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
131 packages can be upgraded. Run 'apt list --upgradable' to see them.
postgres@lkmpg:~$
postgres@lkmpg:~$ sudo apt install pgbackrest
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
  libssh2-1t64
Suggested packages:
  pgbackrest-doc check-pgbackrest
The following NEW packages will be installed:
  libssh2-1t64 pgbackrest
0 upgraded, 2 newly installed, 0 to remove and 131 not upgraded.
Need to get 673 kB of archives.
After this operation, 1,862 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://kr.archive.ubuntu.com/ubuntu noble/main amd64 libssh2-1t64 amd64 1.11.0-4.1build2 [120 kB]
Get:2 https://apt.postgresql.org/pub/repos/apt noble-pgdg/main amd64 pgbackrest amd64 2.54.2-1.pgdg24.04+1 [553 kB]
Fetched 673 kB in 5s (126 kB/s)
Selecting previously unselected package libssh2-1t64:amd64.
(Reading database ... 124284 files and directories currently installed.)
Preparing to unpack .../libssh2-1t64_1.11.0-4.1build2_amd64.deb ...
Unpacking libssh2-1t64:amd64 (1.11.0-4.1build2) ...
Selecting previously unselected package pgbackrest.
Preparing to unpack .../pgbackrest_2.54.2-1.pgdg24.04+1_amd64.deb ...
Unpacking pgbackrest (2.54.2-1.pgdg24.04+1) ...
Setting up libssh2-1t64:amd64 (1.11.0-4.1build2) ...
Setting up pgbackrest (2.54.2-1.pgdg24.04+1) ...
Processing triggers for libc-bin (2.39-0ubuntu8.4) ...
Processing triggers for man-db (2.12.0-4build2) ...
Scanning processes...
Scanning linux images...

Running kernel seems to be up-to-date.

No services need to be restarted.

No containers need to be restarted.

No user sessions are running outdated binaries.

No VM guests are running outdated hypervisor (qemu) binaries on this host.
postgres@lkmpg:~$
postgres@lkmpg:~$ pgbackrest version
pgBackRest 2.54.2
postgres@lkmpg:~$

 

2. pgBackRest 설정 파일 구성

postgres@lkmpg:/usr/bin$ sudo mkdir -p -m 770 /var/log/pgbackrest
postgres@lkmpg:/usr/bin$ sudo chown postgres:postgres /var/log/pgbackrest
        sudo mkdir -p /etc/pgbackrest
        sudo mkdir -p /etc/pgbackrest/conf.d
        sudo touch /etc/pgbackrest/pgbackrest.conf
        sudo chmod 640 /etc/pgbackrest/pgbackrest.conf
        sudo chown postgres:postgres /etc/pgbackrest/pgbackrest.conf
postgres@lkmpg:/usr/bin$
postgres@lkmpg:/usr/bin$
postgres@lkmpg:/usr/bin$
postgres@lkmpg:/usr/bin$ ls -lrt /etc/pgbackrest/pgbackrest.conf
-rw-r----- 1 postgres postgres 0 Mar 15 12:10 /etc/pgbackrest/pgbackrest.conf

 

 

[demo] 
pg1-path=/var/lib/postgresql/15/main 

[global] 
repo1-path=/var/lib/pgbackrest 
repo1-retention-full=2 
log-level-console=info

 

3. PostgreSQL WAL 아카이빙 설정 파일 수정

/etc/postgresql/15/main/postgresql.conf

 postgres@lkmpg:~$ cat /etc/postgresql/15/main/postgresql.conf | grep command 
  
  
  # Any parameter can also be given as a command-line option to the server, e.g., 
  # with the "SET" SQL command. 
  # The default values of these variables are driven from the -D command-line 
  #ssl_passphrase_command = '' 
  #ssl_passphrase_command_supports_reload = off 
  # (empty string indicates archive_command should #archive_command = '' 
  # command to use to archive a logfile segment
  #restore_command = '' 
  # command to use to restore an archived logfile segment #archive_cleanup_command = '' 
  # command to execute at every restartpoint #recovery_end_command = '' 
  # command to execute at completion of recovery 
  # %i = command tag #log_replication_commands = off 
  #archive_command = '/usr/local/bin/wal-g wal-push %p --config=/etc/wal-g.yaml' 
  
  archive_command = 'pgbackrest --stanza=demo archive-push %p' 
  
  #restore_command = '/usr/local/bin/wal-g wal-fetch %f %p --config=/etc/wal-g.yaml'

 

 

4. PostgreSQL 재기동

 

5. stanza 초기화작업 

postgres@lkmpg:~$ sudo -u postgres pgbackrest --stanza=demo stanza-create 

2025-03-15 12:26:38.812 P00 INFO: stanza-create command begin 2.54.2: --exec-id=1420-cbcc50f3 --log-level-console=info -- pg1-path=/var/lib/postgresql/15/main --repo1-path=/var/lib/pgbackrest --stanza=demo 
2025-03-15 12:26:38.880 P00 INFO: stanza-create for stanza 'demo' on repo1 
2025-03-15 12:26:38.887 P00 INFO: stanza-create command end: completed successfully (81ms)

 

 

6. stanza check

postgres@lkmpg:/var/lib/pgbackrest/archive/demo$ sudo -u postgres pgbackrest --stanza=demo --log-level-console=info check 

2025-03-15 12:33:06.833 P00 INFO: check command begin 2.54.2: --exec-id=1472-cf6c746d --log-level-console=info --pg1-path=/var/lib/postgresql/15/main --repo1-path=/var/lib/pgbackrest --stanza=demo 
2025-03-15 12:33:06.845 P00 INFO: check repo1 configuration (primary) 
2025-03-15 12:33:06.906 P00 INFO: check repo1 archive for WAL (primary) 
2025-03-15 12:33:07.208 P00 INFO: WAL segment 000000050000000000000011 successfully archived to '/var/lib/pgbackrest/archive/demo/15-1/0000000500000000/000000050000000000000011-fc3f218f07125da170b6185e5e7fab439e2ec54b.gz' on repo1 
2025-03-15 12:33:07.208 P00 INFO: check command end: completed successfully (378ms)

 

 

 


https://pgbackrest.org/user-guide.html#installation

 

 

 

 

 

pgBackRest User Guide - Debian & Ubuntu

The pgBackRest User Guide demonstrates how to quickly and easily setup pgBackRest for your PostgreSQL database. Step-by-step instructions lead the user through all the important features of the fastest, most reliable PostgreSQL backup and restore solution.

pgbackrest.org

 

 

 

저작자표시 비영리 변경금지

'Postgresql > 설치' 카테고리의 다른 글

pg DB 이중화 관리 repmgr 구축  (0) 2025.04.05
pg DB 이중화 구성 (streaming replication) - primary crash  (0) 2025.04.05
pg DB 이중화 구성 (streaming replication)  (0) 2025.04.01
유용한 extension 정리  (0) 2025.03.13
postgresql 15 삭제 후 재설치  (0) 2025.03.10

'Postgresql/설치'의 다른글

  • 현재글pgBackRest 설치

관련글

티스토리툴바