Pgbackrest Comparability issue

From: chiru r <chirupg(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Pgbackrest Comparability issue
Date: 2019-02-28 14:59:18
Message-ID: CA+RSxMhpSenHxAPF_qc_w=wckZc=BHtZ6aBKgCTfS01EordRzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I am using Pgbackrest and have an issue while upgrading our PostgreSQL
9.5.10 to PostgreSQL 10.4 version on same Physical linux server.
As part of testing I have stop the PostgreSQL 9.5 database on server and
PostgreSQL 10 is up and running and trying to configure and execute the
backups for postgreSQL 10.

I have change the pgbackrest.conf file and trying to create the stanza, it
is throwing *compilation errors*.

*Note :* PostgreSQL 95 backups were configured earlier on same server and
they were successful.

*Details : *
1. instance
postgres 9711 1 0 09:06 pts/1 00:00:00
/u01/postgres/10/bin/postgres -D /u02/pgdata01/10/data
postgres 9712 9711 0 09:06 ? 00:00:00 postgres: logger process
postgres 9714 9711 0 09:06 ? 00:00:00 postgres: checkpointer
process
postgres 9715 9711 0 09:06 ? 00:00:00 postgres: writer process
postgres 9716 9711 0 09:06 ? 00:00:00 postgres: wal writer process
postgres 9717 9711 0 09:06 ? 00:00:00 postgres: autovacuum
launcher process
postgres 9719 9711 0 09:06 ? 00:00:00 postgres: stats collector
process
postgres 9720 9711 0 09:06 ? 00:00:00 postgres: bgworker: logical
replication launcher

2. Linux Server

*Redhat 7.2+*

3. Pgbackrest conf file

[postgres(at)ITSUSRALSP03974 install]$ cat /etc/pgbackrest.conf
[online_backups10]
db-path=/u02/pgdata01/10/data
backup-user=postgres
db-socket-path=/tmp

#[online_backups]
#db-path=/u02/pgdata01/9.5/data
#backup-user=postgres
#db-socket-path=/tmp

[global]
retention-full=3
repo-path=/pgback
start-fast=y
stop-auto=y

*Error : what we are getting . *

[postgres(at)server1 install]$ pgbackrest --stanza=online_backups10
--log-level-console=info check
Bareword "CFGCMD_HELP" not allowed while "strict subs" in use at
/bin/pgbackrest line 39.
Bareword "CFGCMD_VERSION" not allowed while "strict subs" in use at
/bin/pgbackrest line 39.
Bareword "CFGCMD_VERSION" not allowed while "strict subs" in use at
/bin/pgbackrest line 46.
Bareword "CFGOPT_TEST" not allowed while "strict subs" in use at
/bin/pgbackrest line 51.
Bareword "CFGOPT_TEST" not allowed while "strict subs" in use at
/bin/pgbackrest line 51.
Bareword "CFGOPT_TEST" not allowed while "strict subs" in use at
/bin/pgbackrest line 51.
Bareword "CFGOPT_TEST_DELAY" not allowed while "strict subs" in use at
/bin/pgbackrest line 51.
Bareword "CFGOPT_TEST_POINT" not allowed while "strict subs" in use at
/bin/pgbackrest line 51.
Bareword "CFGCMD_ARCHIVE_PUSH" not allowed while "strict subs" in use at
/bin/pgbackrest line 59.
Bareword "CFGCMD_ARCHIVE_GET" not allowed while "strict subs" in use at
/bin/pgbackrest line 71.
Bareword "CFGCMD_REMOTE" not allowed while "strict subs" in use at
/bin/pgbackrest line 83.
Bareword "CFGOPT_LOG_LEVEL_STDERR" not allowed while "strict subs" in use
at /bin/pgbackrest line 86.
Bareword "CFGOPT_LOG_LEVEL_STDERR" not allowed while "strict subs" in use
at /bin/pgbackrest line 87.
Bareword "CFGOPT_TYPE" not allowed while "strict subs" in use at
/bin/pgbackrest line 89.
Bareword "CFGOPTVAL_REMOTE_TYPE_BACKUP" not allowed while "strict subs" in
use at /bin/pgbackrest line 89.
Bareword "CFGOPT_REPO_TYPE" not allowed while "strict subs" in use at
/bin/pgbackrest line 89.
Bareword "CFGOPTVAL_REPO_TYPE_S3" not allowed while "strict subs" in use at
/bin/pgbackrest line 89.
Bareword "CFGOPT_REPO_PATH" not allowed while "strict subs" in use at
/bin/pgbackrest line 89.
Bareword "CFGOPT_REPO_PATH" not allowed while "strict subs" in use at
/bin/pgbackrest line 89.
Bareword "CFGOPT_BUFFER_SIZE" not allowed while "strict subs" in use at
/bin/pgbackrest line 100.
Bareword "CFGOPT_PROTOCOL_TIMEOUT" not allowed while "strict subs" in use
at /bin/pgbackrest line 100.
Bareword "CFGOPT_COMMAND" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGCMD_ARCHIVE_GET" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGOPT_COMMAND" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGCMD_INFO" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGOPT_COMMAND" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGCMD_RESTORE" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGOPT_COMMAND" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGCMD_CHECK" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGOPT_COMMAND" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGCMD_LOCAL" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGOPT_COMMAND" not allowed while "strict subs" in use at
/bin/pgbackrest line 103.
Bareword "CFGCMD_LOCAL" not allowed while "strict subs" in use at
/bin/pgbackrest line 119.
Bareword "CFGOPT_LOG_LEVEL_STDERR" not allowed while "strict subs" in use
at /bin/pgbackrest line 122.
Bareword "CFGOPT_LOG_LEVEL_STDERR" not allowed while "strict subs" in use
at /bin/pgbackrest line 123.
Bareword "CFGCMD_CHECK" not allowed while "strict subs" in use at
/bin/pgbackrest line 139.
Bareword "CFGCMD_START" not allowed while "strict subs" in use at
/bin/pgbackrest line 151.
Bareword "CFGCMD_STOP" not allowed while "strict subs" in use at
/bin/pgbackrest line 154.
Bareword "CFGOPT_REPO_TYPE" not allowed while "strict subs" in use at
/bin/pgbackrest line 166.
Bareword "CFGOPTVAL_REPO_TYPE_S3" not allowed while "strict subs" in use at
/bin/pgbackrest line 166.
Bareword "CFGOPT_REPO_PATH" not allowed while "strict subs" in use at
/bin/pgbackrest line 166.
Bareword "CFGCMD_INFO" not allowed while "strict subs" in use at
/bin/pgbackrest line 174.
Bareword "CFGOPT_LOG_PATH" not allowed while "strict subs" in use at
/bin/pgbackrest line 194.
Bareword "CFGOPT_STANZA" not allowed while "strict subs" in use at
/bin/pgbackrest line 194.
Bareword "CFGCMD_STANZA_CREATE" not allowed while "strict subs" in use at
/bin/pgbackrest line 200.
Bareword "CFGCMD_STANZA_UPGRADE" not allowed while "strict subs" in use at
/bin/pgbackrest line 200.
Bareword "CFGCMD_RESTORE" not allowed while "strict subs" in use at
/bin/pgbackrest line 217.
Bareword "CFGCMD_BACKUP" not allowed while "strict subs" in use at
/bin/pgbackrest line 246.
Bareword "CFGCMD_EXPIRE" not allowed while "strict subs" in use at
/bin/pgbackrest line 254.
Bareword "CFGCMD_EXPIRE" not allowed while "strict subs" in use at
/bin/pgbackrest line 260.
Execution of /bin/pgbackrest aborted due to compilation errors.

Please hep me, if i am missing anything here.

Thanks,
Chiru

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-02-28 15:15:12 Re: Where **not** to use PostgreSQL?
Previous Message Andy Fan 2019-02-28 14:55:54 Re: create unique constraint on jsonb->filed during create table