From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | chiru r <chirupg(at)gmail(dot)com>, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Pgbackrest Comparability issue |
Date: | 2019-02-28 15:15:31 |
Message-ID: | 1821b34a-f991-000d-50a6-fc1831600294@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2/28/19 6:59 AM, chiru r wrote:
> 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*.
What version of pgBackRest?
Was it recently updated?
How was it installed?
>
> *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
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Michel Pelletier | 2019-02-28 15:47:34 | Re: Where **not** to use PostgreSQL? |
Previous Message | Ron | 2019-02-28 15:15:12 | Re: Where **not** to use PostgreSQL? |