Обсуждение: 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

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 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