Обсуждение: pg_backrest build dependencies rpm's

Hi Pavan,

On 23/05/2019 16:53, Pavan Kumar wrote:
> I am using RHEL 7 and postgres as 10, 11.2 and 11.3
> here is the note I do see from pgbackrest.org <http://pgbackrest.org> , 

Have you considered using the prepackaged version that can be found in
the PGDG yum repository? It can be found here:

https://yum.postgresql.org

and the dependency resolution will be handled for you (Note, some of the
packages might depend on the EPEL repository).

Cheers,
Jakub Olczyk

Hi Pavan,

I think you forgot to add the list to your reply, so I am adding it
right now.

On 23/05/2019 17:46, Pavan Kumar wrote:
> I installed  pgdg repository rpm.
>
> [root@katyayani ~]# rpm -Uvh pgdg-redhat-repo-latest.noarch.rpm
> Preparing...                ########################################### [100%]
>    1:pgdg-redhat-repo       ########################################### [100%]
>
> when i query for rpm's in the repository, i don't see the rpm i am looking for
> [root@katyayani ~]# yum provides build
> Loaded plugins: refresh-packagekit, security, ulninfo
> Repository pgdg11 is listed more than once in the configuration
> Repository pgdg96 is listed more than once in the configuration
> Repository pgdg11-updates-testing is listed more than once in the configuration
> Repository pgdg96-updates-testing is listed more than once in the configuration
> Repository pgdg11-source is listed more than once in the configuration
> Repository pgdg11-source-updates-testing is listed more than once in the configuration
> Repository pgdg96-source is listed more than once in the configuration
> Repository pgdg96-source-updates-testing is listed more than once in the configuration
> pgdg94                                                                                                         | 4.1
kB    00:00 
> pgdg94/primary_db                                                                                              | 238
kB    00:00 
> pgdg95                                                                                                         | 4.1
kB    00:00 
> pgdg95/primary_db                                                                                              | 242
kB    00:00 
> Warning: 3.0.x versions of yum would erroneously match against filenames.
>  You can use "*/build" and/or "*bin/build" to get that behaviour
> No Matches found
>
> Instead of configuring pgdg yum repository, is there any way to download rpm's  from pgdg repository portal ?

Well, I thought you might want to use the prepackaged version of
pgbackrest from the repository that matches the version of PostgreSQL
you have installed. So the command after installing the repository RPM
would look like this:

# yum install pgbackrest

In that way you won't need to compile anything from scratch and you can
count on the automated updates from the repository.

If that approach isn't really working for you and you can only compile
yourself the first step would be installing the @buildsys-build group
which is roughly equivalent to build-essential from Debian world. As for
other library packages I'd start with the ones that are listed as
BuildRequires in the source RPM package from PGDG repository and later
install anything that is still missing.

So the command for installing packages required during build would be:
# yum install @buildsys-build \
                openssl-devel \
                   zlib-devel \
          perl-ExtUtils-Embed

Cheers,
Jakub Olczyk

On 5/24/19 3:16 AM, Jakub Olczyk wrote:
>>
>> Instead of configuring pgdg yum repository, is there any way to download rpm's  from pgdg repository portal ?
> 
> Well, I thought you might want to use the prepackaged version of
> pgbackrest from the repository that matches the version of PostgreSQL
> you have installed. So the command after installing the repository RPM
> would look like this:
> 
> # yum install pgbackrest
> 
> In that way you won't need to compile anything from scratch and you can
> count on the automated updates from the repository.

Using the packages available from yum.postgresql.org is generally the
best idea.

If you must build from source the instructions for RHEL7 can be found here:

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

-- 
-David
david@pgmasters.net

David and Jakub,

Thank you so much for reply.

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

 I was able to install pgbackrest  tool. when I tried to create stanza, I got below error. kindly help us on this.

[root@oralnx1 ~]# su - postgres
-bash-4.2$ source pg_5400_env.sh >>>> I have sourced my 11.2 version environment variables 

>>>>> tried to created stanza 

postgres@oralnx1 ~> pgbackrest --stanza=visa-demo --log-path=/oratrace/pg_alert_log --repo-path=/orabackup/WORM/PGBACKUP/visa-demo-5400 --log-level-console=detail --log-level-file=detail stanza-create
2019-05-24 16:44:52.671 P00   INFO: stanza-create command begin 2.14: --log-level-console=detail --log-level-file=detail --log-path=/oratrace/pg_alert_log --pg1-path=/oradbaudit/pg_data_dir --repo1-path=/orabackup/WORM/PGBACKUP/visa-demo-5400 --stanza=visa-demo
ERROR [058]: : version '10' and path '/oratrace/pgdata_10.8' queried from cluster do not match version '11' and pg1-path '/oradbaudit/pg_data_dir' read from '/oradbaudit/pg_data_dir/global/pg_control'
HINT: the pg1-path and pg1-port settings likely reference different clusters
2019-05-24 16:44:53.906 P00   INFO: stanza-create command end: aborted with exception [058]

problem Is I do have postgres version 10 and 11 on same server. why pgbackrest is taking version 10 ?

please advise 

On Fri, May 24, 2019 at 6:16 AM David Steele <david@pgmasters.net> wrote:

On 5/24/19 3:16 AM, Jakub Olczyk wrote:
>>
>> Instead of configuring pgdg yum repository, is there any way to download rpm's  from pgdg repository portal ?
>
> Well, I thought you might want to use the prepackaged version of
> pgbackrest from the repository that matches the version of PostgreSQL
> you have installed. So the command after installing the repository RPM
> would look like this:
>
> # yum install pgbackrest
>
> In that way you won't need to compile anything from scratch and you can
> count on the automated updates from the repository.

Using the packages available from yum.postgresql.org is generally the
best idea.

If you must build from source the instructions for RHEL7 can be found here:

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

--
-David
david@pgmasters.net

--

Regards,

#!  Pavan Kumar
-----------------------------------------------
Sr. Database Administrator..!
NEXT GENERATION PROFESSIONALS, LLC
Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  

India   # 9000459083

Take Risks; if you win, you will be very happy. If you lose you will be Wise  

On 5/24/19 1:12 PM, Pavan Kumar wrote:
> 
>  I was able to install pgbackrest  tool. when I tried to create stanza,
> I got below error. kindly help us on this.
> 
> [root@oralnx1 ~]# su - postgres
> -bash-4.2$ source pg_5400_env.sh >>>> I have sourced my 11.2 version
> environment variables 
> 
>>>>>> tried to created stanza 
> 
> postgres@oralnx1 ~> pgbackrest --stanza=visa-demo
> --log-path=/oratrace/pg_alert_log
> --repo-path=/orabackup/WORM/PGBACKUP/visa-demo-5400
> --log-level-console=detail --log-level-file=detail stanza-create
> 2019-05-24 16:44:52.671 P00   INFO: stanza-create command begin 2.14:
> --log-level-console=detail --log-level-file=detail
> --log-path=/oratrace/pg_alert_log --pg1-path=/oradbaudit/pg_data_dir
> --repo1-path=/orabackup/WORM/PGBACKUP/visa-demo-5400 --stanza=visa-demo
> ERROR [058]: : version '10' and path '/oratrace/pgdata_10.8' queried
> from cluster do not match version '11' and pg1-path
> '/oradbaudit/pg_data_dir' read from
> '/oradbaudit/pg_data_dir/global/pg_control'
> HINT: the pg1-path and pg1-port settings likely reference different clusters
> 2019-05-24 16:44:53.906 P00   INFO: stanza-create command end: aborted
> with exception [058]
> 
> problem Is I do have postgres version 10 and 11 on same server. why
> pgbackrest is taking version 10 ?

It looks like you need to set pg1-port=5400 (This is a guess from your
directory name);

The servers are running on different ports -- you'll need to let
pgBackRest know which one.

-- 
-David
david@pgmasters.net