Pgbackrest Comparability issue

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@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@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.klaver@aklaver.com

We are suing pgBackRest 1.24 version .

Installing using rpms

yum -y install perl-parent
yum -y install perl-Time-HiRes
yum -y install perl-JSON
yum -y install perl-Digest-SHA
yum -y install perl-Digest
yum -y install perl-DBD-Pg

On Thu, Feb 28, 2019 at 10:15 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 2/28/19 10:06 AM, chiru r wrote:

We are suing pgBackRest 1.24 version .

Installing using rpms

yum -y install perl-parent
yum -y install perl-Time-HiRes
yum -y install perl-JSON
yum -y install perl-Digest-SHA
yum -y install perl-Digest
yum -y install perl-DBD-Pg

FYI, please do not top post. Inline posting is the preferred style on
this list.

In the above I do not see anything that indicates how pgBackRest was
installed or the version number.

On Thu, Feb 28, 2019 at 10:15 AM Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

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@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@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

On Thu, Feb 28, 2019 at 1:28 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 2/28/19 10:06 AM, chiru r wrote:

We are suing pgBackRest 1.24 version .

Installing using rpms

yum -y install perl-parent
yum -y install perl-Time-HiRes
yum -y install perl-JSON
yum -y install perl-Digest-SHA
yum -y install perl-Digest
yum -y install perl-DBD-Pg

FYI, please do not top post. Inline posting is the preferred style on
this list.

In the above I do not see anything that indicates how pgBackRest was
installed or the version number.

Hi Adrian,

We installed pgBackRest *1.24* version initially with PostgreSQL 9.5.10
version.
Now we have installed postgresql-10 on server and we are trying to run
backups to PostgreSQL-10 also using pgbackrest. and we are getting
compilation errors.

The below steps we followed.
yum -y install perl-parent
yum -y install perl-Time-HiRes
yum -y install perl-JSON
yum -y install perl-Digest-SHA
yum -y install perl-Digest
yum -y install perl-DBD-Pg

Downloaded pgbackrest-release-1.24.zip from github and unpacked.
https://github.com/pgbackrest/pgbackrest

cp -r pgbackrest-release-1.24/lib/pgBackRest /usr/share/perl5/
cp -r pgbackrest-release-1.24/bin/pgbackrest /usr/bin/pgbackrest

echo "Restarting Cluster......."
su -c "cd ${PGHOME}/bin; pg_ctl restart -D ${PGDATA}" -m "$DBUSER"
sleep 20

su -c "cd /usr/bin; pgbackrest --stanza=online_backups10
--log-level-console=info stanza-create" -m "$DBUSER"
su -c "cd /usr/bin; pgbackrest --stanza=online_backups10
--log-level-console=info check" -m "$DBUSER"

Thanks,
chiru

On 2/28/19 12:28 PM, chiru r wrote:

On Thu, Feb 28, 2019 at 1:28 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 2/28/19 10:06 AM, chiru r wrote:

We are suing pgBackRest 1.24 version .

Hmm, that cut off in the previous post, sorry for the noise. Seems email
client issue on my end.

Installing using rpms

yum -y install perl-parent
yum -y install perl-Time-HiRes
yum -y install perl-JSON
yum -y install perl-Digest-SHA
yum -y install perl-Digest
yum -y install perl-DBD-Pg

FYI, please do not top post. Inline posting is the preferred style on
this list.

In the above I do not see anything that indicates how pgBackRest was
installed or the version number.

Hi Adrian,
We installed  pgBackRest *1.24* version  initially with PostgreSQL
9.5.10 version.

In the 1.x series the latest is 1.28. The 1.x series has been superseded
by 2.x it would seem.

Now we have installed postgresql-10 on server and we are trying to run
backups to PostgreSQL-10 also using pgbackrest. and we are getting
compilation errors.

Is this the same server as the one that has the 9.5 instance?

The below steps we followed.
yum -y install perl-parent
yum -y install perl-Time-HiRes
yum -y install perl-JSON
yum -y install perl-Digest-SHA
yum -y install perl-Digest
yum -y install perl-DBD-Pg

Downloaded pgbackrest-release-1.24.zip from github and unpacked.
https://github.com/pgbackrest/pgbackrest

cp -r pgbackrest-release-1.24/lib/pgBackRest  /usr/share/perl5/
cp -r pgbackrest-release-1.24/bin/pgbackrest  /usr/bin/pgbackrest

Have you tried this:

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

echo "Restarting Cluster......."
su -c "cd ${PGHOME}/bin; pg_ctl restart -D ${PGDATA}" -m "$DBUSER"
sleep 20

su -c "cd /usr/bin; pgbackrest --stanza=online_backups10
--log-level-console=info stanza-create" -m "$DBUSER"
su -c "cd /usr/bin; pgbackrest --stanza=online_backups10
--log-level-console=info check" -m "$DBUSER"

 Thanks,
chiru

--
Adrian Klaver
adrian.klaver@aklaver.com

On 3/1/19 1:37 AM, Adrian Klaver wrote:

On 2/28/19 12:28 PM, chiru r wrote:

The below steps we followed.
yum -y install perl-parent
yum -y install perl-Time-HiRes
yum -y install perl-JSON
yum -y install perl-Digest-SHA
yum -y install perl-Digest
yum -y install perl-DBD-Pg

Downloaded pgbackrest-release-1.24.zip from github and unpacked.
https://github.com/pgbackrest/pgbackrest

cp -r pgbackrest-release-1.24/lib/pgBackRest  /usr/share/perl5/
cp -r pgbackrest-release-1.24/bin/pgbackrest  /usr/bin/pgbackrest

You appear to have an old version at /bin/pgbackrest.

pgBackRest is available as a package from yum.postgresql.org. If you
installed Postgres from there then you just need to:

yum install pgbackrest

If this is not a fresh install and you have old copies of pgbackrest
lying around it would be best to follow the uninstall directions here:

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

You may have files in other locations as well since I don't believe
/bin/pgbackrest has even been in our install directions.

Regards,
--
-David
david@pgmasters.net