Re: Pgbackrest Comparability issue

On Thu, Feb 28, 2019 at 1:28 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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 Thu, Feb 28, 2019 at 10:15 AM Adrian Klaver
> > <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(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 <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>