{"id":11051,"date":"2018-04-01T16:59:36","date_gmt":"2018-04-01T14:59:36","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/"},"modified":"2023-06-09T16:56:46","modified_gmt":"2023-06-09T14:56:46","slug":"pgbackrest-dedicated-backup-host","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/","title":{"rendered":"PgBackRest : Dedicated Backup Host"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

In previous blogs (blog1 <\/a> and blog2<\/a>) we saw a configuration of PgBackRest where the tool is installed in the same server that also hosts the PostgreSQL cluster. This configuration is fine if we have a single database server. But in the case that we have many database servers, it is more suitable to have a dedicated server for backups. This will also separate the backups and WAL archive from databases server
\nIn this article we will see how to configure PgBackRest in an environment with 2 databases servers.
\nWe present below the configuration we will use. We suppose that PgBackRest is already installed on both servers.
\npgservertools<\/strong>: dedicated backup hosts
\npgserver1<\/strong>: database server
\npgserver2<\/strong>: database server
\n\"schema\"<\/a>
\nAs we can see we have two clusters running on each database server (pgserver1 and pgserver2). Note that we can have as many clusters we want on each server.
\npgserver1 : cluster1<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
postgres=# show data_directory ;<\/code><\/div>\n
\u00a0\u00a0<\/code>data_directory<\/code><\/div>\n
-------------------<\/code><\/div>\n
\u00a0<\/code>\/u90\/pgdata\/pg101<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
postgres=# show port;<\/code><\/div>\n
\u00a0<\/code>port<\/code><\/div>\n
------<\/code><\/div>\n
\u00a0<\/code>5432<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
postgres=#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver1 : cluster2<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
postgres=# show data_directory ;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>data_directory<\/code><\/div>\n
--------------------<\/code><\/div>\n
\u00a0<\/code>\/u90\/pgdata2\/pg101<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
postgres=# show port;<\/code><\/div>\n
\u00a0<\/code>port<\/code><\/div>\n
------<\/code><\/div>\n
\u00a0<\/code>5433<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
postgres=#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver2 : cluster1<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
postgres=# show data_directory ;<\/code><\/div>\n
\u00a0\u00a0<\/code>data_directory<\/code><\/div>\n
-------------------<\/code><\/div>\n
\u00a0<\/code>\/u90\/pgdata\/pg101<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
postgres=# show port;<\/code><\/div>\n
\u00a0<\/code>port<\/code><\/div>\n
------<\/code><\/div>\n
\u00a0<\/code>5432<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
postgres=#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver2 : cluster2<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
postgres=# show data_directory ;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>data_directory<\/code><\/div>\n
--------------------<\/code><\/div>\n
\u00a0<\/code>\/u90\/pgdata2\/pg101<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
postgres=# show port;<\/code><\/div>\n
\u00a0<\/code>port<\/code><\/div>\n
------<\/code><\/div>\n
\u00a0<\/code>5433<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
postgres=#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s create on pgservertools a dedicated user who will own the repository. It is not recommended to use user postgres. We will use backupowner as user.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
[root@pgservertools ~]<\/code># useradd -m backupowner<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As PgBackRest requires communication between the hosts without password, we have to configure ssh keys between user backupowner (on pgservertools) and users postgres (on pgserver1 and pgserver2).
\nOn pgservertools, let\u2019s generate keys for user backupowner<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools ~]$ <\/code>ssh<\/code>-keygen -t rsa<\/code><\/div>\n
Generating public<\/code>\/private<\/code> rsa key pair.<\/code><\/div>\n
Enter <\/code>file<\/code> in<\/code> which<\/code> to save the key (<\/code>\/home\/backupowner\/<\/code>.<\/code>ssh<\/code>\/id_rsa<\/code>): y<\/code><\/div>\n
Enter passphrase (empty <\/code>for<\/code> no passphrase):<\/code><\/div>\n
Enter same passphrase again:<\/code><\/div>\n
Your identification has been saved <\/code>in<\/code> y.<\/code><\/div>\n
Your public key has been saved <\/code>in<\/code> y.pub.<\/code><\/div>\n
The key fingerprint is:<\/code><\/div>\n
SHA256:drIaCe1aMZSPOmQkNdYfn5WLm<\/code>\/iE4sJS2YKGj6EF38M<\/code> backupowner@pgservertools.localdomain<\/code><\/div>\n
The key's randomart image is:<\/code><\/div>\n
+---[RSA 2048]----+<\/code><\/div>\n
|\u00a0\u00a0\u00a0 +.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .\u00a0\u00a0 |<\/code><\/div>\n
|\u00a0\u00a0 o ....\u00a0\u00a0 o\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|\u00a0 . . o. o + .\u00a0\u00a0 |<\/code><\/div>\n
|.\u00a0 o o o. + .\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| + ++o= So.o\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|o =oE+o=o++\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|.* oo+=..o\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|o o o+.o\u00a0 .\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|\u00a0\u00a0 ....\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
+----[SHA256]-----+<\/code><\/div>\n
[backupowner@pgservertools ~]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Do the same on pgserver1 for user postgres<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
[postgres@pgserver1 ~]$ <\/code>ssh<\/code>-keygen -t rsa<\/code><\/div>\n
Generating public<\/code>\/private<\/code> rsa key pair.<\/code><\/div>\n
Enter <\/code>file<\/code> in<\/code> which<\/code> to save the key (<\/code>\/home\/postgres\/<\/code>.<\/code>ssh<\/code>\/id_rsa<\/code>):<\/code><\/div>\n
Created directory <\/code>'\/home\/postgres\/.ssh'<\/code>.<\/code><\/div>\n
Enter passphrase (empty <\/code>for<\/code> no passphrase):<\/code><\/div>\n
Enter same passphrase again:<\/code><\/div>\n
Your identification has been saved <\/code>in<\/code> \/home\/postgres\/<\/code>.<\/code>ssh<\/code>\/id_rsa<\/code>.<\/code><\/div>\n
Your public key has been saved <\/code>in<\/code> \/home\/postgres\/<\/code>.<\/code>ssh<\/code>\/id_rsa<\/code>.pub.<\/code><\/div>\n
The key fingerprint is:<\/code><\/div>\n
15:cf:78:47:ef:e5:ab:29:b7:25:59:03:de:de:88:be postgres@pgserver1.localdomain<\/code><\/div>\n
The key's randomart image is:<\/code><\/div>\n
+--[ RSA 2048]----+<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .\u00a0\u00a0 .\u00a0 |<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = . . |<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 o +.. o|<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ...oo.|<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 S\u00a0\u00a0\u00a0 . +o|<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .+.+|<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .o.+.|<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 o .=\u00a0 |<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 E=.\u00a0 |<\/code><\/div>\n
+-----------------+<\/code><\/div>\n
[postgres@pgserver1 ~]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And on pgserver2 for user postgres<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
[postgres@pgserver2 ~]$ <\/code>ssh<\/code>-keygen -t rsa<\/code><\/div>\n
Generating public<\/code>\/private<\/code> rsa key pair.<\/code><\/div>\n
Enter <\/code>file<\/code> in<\/code> which<\/code> to save the key (<\/code>\/home\/postgres\/<\/code>.<\/code>ssh<\/code>\/id_rsa<\/code>):<\/code><\/div>\n
Created directory <\/code>'\/home\/postgres\/.ssh'<\/code>.<\/code><\/div>\n
Enter passphrase (empty <\/code>for<\/code> no passphrase):<\/code><\/div>\n
Enter same passphrase again:<\/code><\/div>\n
Your identification has been saved <\/code>in<\/code> \/home\/postgres\/<\/code>.<\/code>ssh<\/code>\/id_rsa<\/code>.<\/code><\/div>\n
Your public key has been saved <\/code>in<\/code> \/home\/postgres\/<\/code>.<\/code>ssh<\/code>\/id_rsa<\/code>.pub.<\/code><\/div>\n
The key fingerprint is:<\/code><\/div>\n
SHA256:ZKov+TdohBLvaO<\/code>\/pSYIl<\/code>+Tk6iWfUMx1Lqixb8ByaZzI postgres@pgserver2.localdomain<\/code><\/div>\n
The key's randomart image is:<\/code><\/div>\n
+---[RSA 2048]----+<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 o\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| ..\u00a0\u00a0 o+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|+ o+ =.oS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| @ooB.+\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|E+@=o= .\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|=BB+++o o\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|oB +*+o. .\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
+----[SHA256]-----+<\/code><\/div>\n
[postgres@pgserver2 ~]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s exchange keys between servers.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools .<\/code>ssh<\/code>]$ <\/code>ssh<\/code>-copy-<\/code>id<\/code> postgres@pgserver1<\/code><\/div>\n
[backupowner@pgservertools .<\/code>ssh<\/code>]$ <\/code>ssh<\/code>-copy-<\/code>id<\/code> postgres@pgserver2<\/code><\/div>\n
[postgres@pgserver1 .<\/code>ssh<\/code>]$ <\/code>ssh<\/code>-copy-<\/code>id<\/code> backupowner@pgservertools<\/code><\/div>\n
[postgres@pgserver2 .<\/code>ssh<\/code>]$ <\/code>ssh<\/code>-copy-<\/code>id<\/code> backupowner@pgservertools<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And then let\u2019s test connection<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools ~]$ <\/code>ssh<\/code> postgres@pgserver1 <\/code>date<\/code><\/div>\n
Tue Feb 20 11:42:06 CET 2018<\/code><\/div>\n
[backupowner@pgservertools ~]$ <\/code>ssh<\/code> postgres@pgserver2 <\/code>date<\/code><\/div>\n
Tue Feb 20 11:42:10 CET 2018<\/code><\/div>\n
\u00a0<\/code>[postgres@pgserver1 .<\/code>ssh<\/code>]$ <\/code>ssh<\/code> backupowner@pgservertools <\/code>date<\/code><\/div>\n
Tue Feb 20 11:42:54 CET 2018<\/code><\/div>\n
[postgres@pgserver2 .<\/code>ssh<\/code>]$ <\/code>ssh<\/code> backupowner@pgservertools <\/code>date<\/code><\/div>\n
Tue Feb 20 11:43:23 CET 2018<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Ok now that everything is fine for trusted connections, let\u2019s configure the pgbackrest.conf files. We present below contents of our files on the 3 servers. We can notice that encryption is used (see previous blogs)<\/p>\n

pgservertools<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n<\/td>\n
\n
\n
[root@pgservertools ~]<\/code># cat \/etc\/pgbackrest.conf<\/code><\/div>\n
[pgserver1pgdata]<\/code><\/div>\n
db1-host=pgserver1<\/code><\/div>\n
db1-path=<\/code>\/u90\/pgdata\/pg101<\/code><\/div>\n
db1-user=postgres<\/code><\/div>\n
<\/div>\n
[pgserver1pgdata2]<\/code><\/div>\n
db1-host=pgserver1<\/code><\/div>\n
db1-path=<\/code>\/u90\/pgdata2\/pg101<\/code><\/div>\n
db1-user=postgres<\/code><\/div>\n
db1-port=5433<\/code><\/div>\n
[pgserver2pgdata]<\/code><\/div>\n
db1-host=pgserver2<\/code><\/div>\n
db1-path=<\/code>\/u90\/pgdata\/pg101<\/code><\/div>\n
db1-user=postgres<\/code><\/div>\n
<\/div>\n
[pgserver2pgdata2]<\/code><\/div>\n
db1-host=pgserver2<\/code><\/div>\n
db1-path=<\/code>\/u90\/pgdata2\/pg101<\/code><\/div>\n
db1-user=postgres<\/code><\/div>\n
db1-port=5433<\/code><\/div>\n
<\/div>\n
[global]<\/code><\/div>\n
repo-path=<\/code>\/u90\/backup<\/code><\/div>\n
retention-full=2<\/code><\/div>\n
repo-cipher-pass=dkN28km<\/code>\/CltmsbzkDdKahmwXctr0GJd\/9F8tegBXBWASULhVatNXauMMKWUslax1<\/code><\/div>\n
repo-cipher-<\/code>type<\/code>=aes-256-cbc [root@pgservertools etc]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver1<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
[postgres@pgserver1 ~]$ <\/code>cat<\/code> \/etc\/pgbackrest<\/code>.conf<\/code><\/div>\n
[pgserver1pgdata]<\/code><\/div>\n
db1-path=<\/code>\/u90\/pgdata\/pg101<\/code><\/div>\n
db1-socket-path=<\/code>\/tmp<\/code><\/div>\n
<\/div>\n
[pgserver1pgdata2]<\/code><\/div>\n
db1-path=<\/code>\/u90\/pgdata2\/pg101<\/code><\/div>\n
db1-port=5433<\/code><\/div>\n
db1-socket-path=<\/code>\/tmp<\/code><\/div>\n
<\/div>\n
[global]<\/code><\/div>\n
backup-host=pgservertools<\/code><\/div>\n
backup-user=backupowner<\/code><\/div>\n
log-level-<\/code>file<\/code>=detail<\/code><\/div>\n
[postgres@pgserver1 ~]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver2<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
[root@pgserver2 postgres]<\/code># cat \/etc\/pgbackrest.conf<\/code><\/div>\n
[pgserver1pgdata]<\/code><\/div>\n
db1-path=<\/code>\/u90\/pgdata\/pg101<\/code><\/div>\n
db1-socket-path=<\/code>\/tmp<\/code><\/div>\n
<\/div>\n
[pgserver1pgdata2]<\/code><\/div>\n
db1-path=<\/code>\/u90\/pgdata2\/pg101<\/code><\/div>\n
db1-port=5433<\/code><\/div>\n
db1-socket-path=<\/code>\/tmp<\/code><\/div>\n
<\/div>\n
[global]<\/code><\/div>\n
backup-host=pgservertools<\/code><\/div>\n
backup-user=backupowner<\/code><\/div>\n
log-level-<\/code>file<\/code>=detail<\/code><\/div>\n
[root@pgserver2 postgres]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The next step is to create the stanzas
\npgserver1: 2 stanzas pgserver1pgdata and pgserver1pgdata2<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools ~]$\u00a0 pgbackrest --stanza=pgserver1pgdata --log-level-console=detail --db-port=5432 --db-host=pgserver1 stanza-create<\/code><\/div>\n
2018-02-21 15:21:42.815 P00\u00a0\u00a0 INFO: stanza-create <\/code>command<\/code> begin 1.28: --db1-host=pgserver1 --db1-path=<\/code>\/u90\/pgdata\/pg101<\/code> --db1-port=5432 --db1-user=postgres --log-level-console=detail --repo-cipher-pass= --repo-cipher-<\/code>type<\/code>=aes-256-cbc --repo-path=<\/code>\/u90\/backup<\/code> --stanza=pgserver1pgdata<\/code><\/div>\n
2018-02-21 15:21:46.881 P00\u00a0\u00a0 INFO: stanza-create <\/code>command<\/code> end: completed successfully<\/code><\/div>\n
<\/div>\n
[backupowner@pgservertools ~]$\u00a0 pgbackrest --stanza=pgserver1pgdata2 --log-level-console=detail --db-port=5433 --db-host=pgserver1 stanza-create<\/code><\/div>\n
2018-02-21 15:23:39.116 P00\u00a0\u00a0 INFO: stanza-create <\/code>command<\/code> begin 1.28: --db1-host=pgserver1 --db1-path=<\/code>\/u90\/pgdata2\/pg101<\/code> --db1-port=5433 --db1-user=postgres --log-level-console=detail --repo-cipher-pass= --repo-cipher-<\/code>type<\/code>=aes-256-cbc --repo-path=<\/code>\/u90\/backup<\/code> --stanza=pgserver1pgdata2<\/code><\/div>\n
2018-02-21 15:23:41.360 P00\u00a0\u00a0 INFO: stanza-create <\/code>command<\/code> end: completed successfully<\/code><\/div>\n
[backupowner@pgservertools ~]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver2: 2 stanzas pgserver2pgdata and pgserver2pgdata2<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools pgserver1pgdata]$ pgbackrest --stanza=pgserver2pgdata --log-level-console=detail --db-port=5432 --db-host=pgserver2 stanza-create<\/code><\/div>\n
2018-02-27 13:22:47.710 P00\u00a0\u00a0 INFO: stanza-create <\/code>command<\/code> begin 1.28: --db1-host=pgserver2 --db1-path=<\/code>\/u90\/pgdata\/pg101<\/code> --db1-port=5432 --db1-user=postgres --log-level-console=detail --repo-cipher-pass= --repo-cipher-<\/code>type<\/code>=aes-256-cbc --repo-path=<\/code>\/u90\/backup<\/code> --stanza=pgserver2pgdata<\/code><\/div>\n
2018-02-27 13:22:49.624 P00\u00a0\u00a0 INFO: stanza-create <\/code>command<\/code> end: completed successfully<\/code><\/div>\n
<\/div>\n
[backupowner@pgservertools pgserver1pgdata]$ pgbackrest --stanza=pgserver2pgdata2 --log-level-console=detail --db-port=5433 --db-host=pgserver2 stanza-create<\/code><\/div>\n
2018-02-27 13:23:01.323 P00\u00a0\u00a0 INFO: stanza-create <\/code>command<\/code> begin 1.28: --db1-host=pgserver2 --db1-path=<\/code>\/u90\/pgdata2\/pg101<\/code> --db1-port=5433 --db1-user=postgres --log-level-console=detail --repo-cipher-pass= --repo-cipher-<\/code>type<\/code>=aes-256-cbc --repo-path=<\/code>\/u90\/backup<\/code> --stanza=pgserver2pgdata2<\/code><\/div>\n
2018-02-27 13:23:03.233 P00\u00a0\u00a0 INFO: stanza-create <\/code>command<\/code> end: completed successfully<\/code><\/div>\n
[backupowner@pgservertools pgserver1pgdata]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And now we can do a backup of any our cluster using the corresponding stanza<\/p>\n

pgserver1pgdata<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools pgserver1pgdata]$ pgbackrest --stanza=pgserver1pgdata --log-level-console=detail --db-port=5432 --db-host=pgserver1 backup<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver1pgdata2<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools pgserver1pgdata]$ pgbackrest --stanza=pgserver1pgdata2 --log-level-console=detail --db-port=5433 --db-host=pgserver1 backup<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver2pgdata<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools pgserver1pgdata]$ pgbackrest --stanza=pgserver2pgdata --log-level-console=detail --db-port=5432 --db-host=pgserver2 backup<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pgserver2pgdata2<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools pgserver1pgdata]$ pgbackrest --stanza=pgserver2pgdata2 --log-level-console=detail --db-port=5433 --db-host=pgserver2 backup<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

An example of getting info about backup<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
[backupowner@pgservertools pgserver1pgdata]$ pgbackrest --stanza=pgserver1pgdata --log-level-console=detail\u00a0 info<\/code><\/div>\n
stanza: pgserver1pgdata<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>status: ok<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>db (current)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>wal archive min<\/code>\/max<\/code> (10-1): 000000010000000000000018 \/ 000000010000000000000018<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>full backup: 20180221-155755F<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>timestamp start<\/code>\/stop<\/code>: 2018-02-27 11:45:51 \/ 2018-02-27 11:46:18<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>wal start<\/code>\/stop<\/code>: 000000010000000000000018 \/ 000000010000000000000018<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>database size: 30MB, backup size: 30MB<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>repository size: 3.5MB, repository backup size: 3.5MB<\/code><\/div>\n
[backupowner@pgservertools pgserver1pgdata]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/strong>
\nIn this blog we have seen how PgbackRest can be be used in an environment with multiple database servers.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw In previous blogs (blog1 and blog2) we saw a configuration of PgBackRest where the tool is installed in the same server that also hosts the PostgreSQL cluster. This configuration is fine if we have a single database server. But in the case that we have many database servers, it is more suitable […]<\/p>\n","protected":false},"author":27,"featured_media":11052,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[202,1293,586],"type_dbi":[],"class_list":["post-11051","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-backup","tag-pgbackrest","tag-postegresql"],"acf":[],"yoast_head":"\nPgBackRest : Dedicated Backup Host - dbi Blog<\/title>\n<meta name=\"description\" content=\"PostegreSQL, Backup, PgBackRest\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PgBackRest : Dedicated Backup Host\" \/>\n<meta property=\"og:description\" content=\"PostegreSQL, Backup, PgBackRest\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-01T14:59:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T14:56:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"917\" \/>\n\t<meta property=\"og:image:height\" content=\"569\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"PgBackRest : Dedicated Backup Host\",\"datePublished\":\"2018-04-01T14:59:36+00:00\",\"dateModified\":\"2023-06-09T14:56:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/\"},\"wordCount\":361,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png\",\"keywords\":[\"Backup\",\"pgbackrest\",\"PostegreSQL\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/\",\"name\":\"PgBackRest : Dedicated Backup Host - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png\",\"datePublished\":\"2018-04-01T14:59:36+00:00\",\"dateModified\":\"2023-06-09T14:56:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"PostegreSQL, Backup, PgBackRest\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png\",\"width\":917,\"height\":569},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PgBackRest : Dedicated Backup Host\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PgBackRest : Dedicated Backup Host - dbi Blog","description":"PostegreSQL, Backup, PgBackRest","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/","og_locale":"en_US","og_type":"article","og_title":"PgBackRest : Dedicated Backup Host","og_description":"PostegreSQL, Backup, PgBackRest","og_url":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/","og_site_name":"dbi Blog","article_published_time":"2018-04-01T14:59:36+00:00","article_modified_time":"2023-06-09T14:56:46+00:00","og_image":[{"width":917,"height":569,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"PgBackRest : Dedicated Backup Host","datePublished":"2018-04-01T14:59:36+00:00","dateModified":"2023-06-09T14:56:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/"},"wordCount":361,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png","keywords":["Backup","pgbackrest","PostegreSQL"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/","url":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/","name":"PgBackRest : Dedicated Backup Host - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png","datePublished":"2018-04-01T14:59:36+00:00","dateModified":"2023-06-09T14:56:46+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"PostegreSQL, Backup, PgBackRest","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/schema-1.png","width":917,"height":569},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-dedicated-backup-host\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PgBackRest : Dedicated Backup Host"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11051","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11051"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11051\/revisions"}],"predecessor-version":[{"id":25768,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11051\/revisions\/25768"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11052"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11051"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}