On Thu, Feb 28, 2019 at 1:28 PM Adrian Klaver <adrian.kla...@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 Thu, Feb 28, 2019 at 10:15 AM Adrian Klaver > > <adrian.kla...@aklaver.com <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
