Обсуждение: install Postgres on RHED 7

Good morning Admin/DBAs

Would you please tell me how to install Postgres 11.x on RHEL7 servers?  I am not able to install it and the pgdg-redhat 11-11-2.noarch.rpm successfully run but nothing happen when I install the packages "yum install Postgres (server, contribute and devel ) etc..."

Is there a way I can install postgres from gz file?

thank you.

 

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

#yum install readline-devel

failure: repodata/repomd.xml from pgdg11: {Errno 356] No more mirrors to try

https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7server-x86_64/repodata/repomd.xml : [Errno 14] curl#6 - "Could no relove host: download.postgresql.orag; Unknown error"

if I check the repodata I have some indexes... which one should I download beside repomd.xml.

where do I install repomd.xml and which directory should I put it in?

thank you.

 

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Wednesday, December 19, 2018 9:23 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:

It seems the readline library not found while configuration. you may have to install the readline development librarie.

Use the below command:

yum install readline-devel 

So you need to resolve dependencies first then try ./configure once more time and run make and make install.

On Wed, Dec 19, 2018 at 7:30 PM Pepe TD Vo <pepevo@yahoo.com> wrote:

thank you for looking into this.  Here is the ./configure info:

# cd /home/postgres/software

# gunzip postgresql-11.1.tar.gz

# tar –xvf postgresql-11.1.tar

# cd postgresql-11.1

# ./configure

Checking build system type .. x86_64-pc-linux-gnu

Checking host system tyupe .. x86_64-pc-linux0gnu

Checking which template to use … linux

Checking  whether NLS is wanted … no

Checking for default port number … 5432

Checking for block size …8kB

Checking for segment size … 1GB

Checking for WAL block size … 8kB

Checking for gcc … gcc

Checking whether the C compiler works … yes

Checking for suffix of executables …

Checking whether we are cross compiling … no

Checking for suffix of object files .. .o

Checking whether we are using the GNU C compiler .. yes

Checking whether gcc accepts –g … yes

Checking for gcc option to accept ISO C89 .. non needed

Checking for g++ … g++

Checking whether we ar using the GNU C++ compiler … yes

Checking whether g++ accepts –g … yes

Checking whether gcc supports – Wdeclaration-after-statement, for CFLAGS … yes

Checking whether gcc supports –Wendif-labels, for CFLAGS … yes

Checking whether g++ supports –Wendif-labels, for CXXFLAGS … yes

Checking whether gcc supports –Wmissing-format-attribute, for CFLAGS … yes

Checking whether g++ supports –Wmissing-format-attribute, for CXXFLAGS … yes

Checking whether gxxc supports –Wformat-security, for CFLAGS … yes

Checking whether g++ supports –Wformat-security, for CXXFLAGS … yes

Checking whether gxx supports –fno-strict-aliasing, for CFLAGS … yes

Checking whether g++ supports –fno-strict-aliasing, for CXXFLAGS … yes

Checking whether gxx supports –fwrapv, for CFLAGS … yes

Checking whether g++ supports –fwrapv, for CXXFLAGS … yes

Checking whether gcc supports-fexcess-precision=standard, for CFLAGS .. yes

Checking whether g++ supports-fexcess-precision=standards, for CXXFLAGS … no

Checking whether gcc supports-funroll-loops, for CFLAGS_VECTOR … yes

Checking whether gcc supports-ftree-vectorize, for CFLAGS_VECTOR … yes

Checking whether gxx supports-Wunused-command-line-arguments, for NOT_THE_CFLAGS … no

Checking whether gcc-supports-Wformat-truncation, for NOT_THE_CFLAGS … no

Checking whether gcc supports-Wstringop-truncation, for NOT_THE_CFLAGS … no

Checking whether the C compiler still works … yes

Checking how to run the C preprocessor … gcc E

Checking allow thread-safe client libraries … yes

Checking whether to build with ICU support … no

Checking whether to build with Tcl … no

Checking whether to build Perl modules … no

Checking whether to build with GSSAPI support … no

Checking whether to build with PAM support … no

Checking whether to build with BSD Authentication support … no

Checking whether to build with LDAP support … no

Checking whether to build with Bonjour support … no

Checking whether to build with OpenSSL support … no

Checking whether to build with SELinux support … no

Checking whether to build with system support … no

Checking for grep that handles long lines and –e … /bin/grep

Checking for egrep …/bin/grep –E

Checking for Id used for GCC … /bin/ld

Checking if the linker (/bin/ld) is GNU ld … yes

Checking for ranlib …ranlib

Checking for strip … strip

Checking whether to build

Checking whether it is possible to strip libraries … yes

 Checking for ar … ar

Checking for a BSD-compatible install …/bin/install –c

Checking for tar … /bin/tar

Chechking whether ln –s works … yes

Checking for gawk … gawk

Checking for a thread-safe mkdir –p … /bing/mkdir –p

Checking for bison …/bin/bison

Configure: using bison (GNU Bison) 3.0.4

Checking for flex … /bin/glex

Configure: using flex 2.5.37

Checking for perl …/bin/perl

Configure: using perl 5.16.3

Checking for ANSI C header files … yes

Checking for sys/types.h … yes

Checking for sys/stat.h … yes

Checking for stdlib.h … yes

Checking for string.h … yes

Checking for memory.h … yes

Checking for strings.h … yes

Checking for inttypes.h … yes

Checking for stdint.h …  yes

Checking for unistd.h … yes

Checking if compiler needs certain flags to reject unknown flags … no

Checking for the pthreads library –lpthreads … no

Checking whether pthreads work without any flags … no

Checking whether pthreads work with –Kthread  … no

Checking whether pthreads work with –kthread … no

Checking whether pthreads work with pthread … yes

Checking for joinable pthread attribute .. PTHREAD_CREATE_JOINABLE

Checking if more special flags are required for pthreads … no

Checking for PTHREAD_PRIO_INHERIT … yes

Checking pthread.h usability … yes

Checking pthread.h presence … yes

Checking for pthread.h  … yes

Checking for strerror_r … yes

Checking for getpwuid_r … yes

Checking for gethostbyname_r .. yes

Checking whether strerror_r returens int … no

Checking for main in –lm … yes

Checking for library containing setproctitle .. no

Checking for library containing setproctitle … no

Checking for library containing dlopen … -ldl

Checking for library containing socket … none required

Checking for library containing shl_load … no

Checking for library containing getopt_long .. none required

Checking for library containing shm_open … -lrt

Checking for library containing shm_unlink .. none required

Checking for library containing clock_gettime … none required

Checking for library containingfdatasync … none required

Checking for library containing sched_yield … none required

Checking for library containing gethostbyname_r … none required

Checking for library containing shmget … none required

Checking for library containing readline .. no

Configure: error:readline library not found

If you have readline already installed, see config.log for details on the failure.  It is possible the compiler isn’t  looking in a proper directory. Use –without-readline to disable readline support

 

# mdkir build_dir

#pwd

/home/postges/postgresl-11.1

# cd build_dir

Make: *** No targets specified and no makefile found. Stop

 

v/r,

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Tuesday, December 18, 2018 6:19 PM, SBob <sbob@quadratum-braccas.com> wrote:

Can you send the output of your ./configure command to the list or past a link to it?

On 12/18/18 8:20 AM, Pepe TD Vo wrote:

Hello,

Run these commands:

Install:

sudo yum install pgdg-redhat11-11-2.noarch.rpm

rpm -Uvh pgdg-redhat11-11-2.noarch.rpm

preparing ###############[100%}

successul

but when I do "yum list posgres*  I ge an error that loaded plugins:langpacks, product-id, search-disabled-repos, subscription-manager

This system is not register with an entitlement server

[Erno 14] curl#6- "Could not resolve host: downlaod.posgresql.org; Unknown error" 

Trying other mirror.

One of the configured repositories failed (PostgreSQL 11 7Server -x86_64), and yum doesn't have enough cached data to continue. At this point the on safe thing yum can do is failed.   There are a few ways to work "fix" this:

1. contact the upstream for the repository and get them to fix the problem.

2. Reconfigure the baseirl/etc.for the repository, to point to a working upstream. This is mot often useful if you are using a new distribution release than is supported by the repository (and the packages for the previous distribution release still work).

3. run the command with the repository temporarily disabled

yum --disablerepo=pgdb11..

4.Disable the repositiroy permanently so yum won't use it by default. Yum will then just ignore the repository until you permanently enable it again or use --enablerepo for temporary usage:

 5. Configure the failing repository to be skipped, if it's unavailable.

etc...

--------------------------------------------------

I use the source one

# gunzip postgresql-11.1.tar.gz

# tar -xvf postgresql-11-1.tar

# cd postgresql11.1

#./configure   ----> it's checking build system, host system and etc... all the packages 

#mkdir build_dir

#cd build_dir

# make

now I get an error  Make: *** No targets specified and no makefile found.   Stop.

which target I should put?

thank you.

 

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Tuesday, December 18, 2018 8:40 AM, Erkan Durmuş <derkan@gmail.com> wrote:

Run these commands:

Install:

sudo yum install epel-release

rpm -Uvh https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm

yum install postgresql11-server postgresql11-contrib

Init DB:

/usr/pgsql-11/bin/postgresql-11-setup initdb

Int Service:

sudo systemctl start postgresql-11

sudo systemctl enable postgresql-11

On Tue, Dec 18, 2018 at 4:14 PM Pepe TD Vo <pepevo@yahoo.com> wrote:

Good morning Admin/DBAs

Would you please tell me how to install Postgres 11.x on RHEL7 servers?  I am not able to install it and the pgdg-redhat 11-11-2.noarch.rpm successfully run but nothing happen when I install the packages "yum install Postgres (server, contribute and devel ) etc..."

Is there a way I can install postgres from gz file?

thank you.

 

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

#yum install readline-devel

failure: repodata/repomd.xml from pgdg11: {Errno 356] No more mirrors to try

https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7server-x86_64/repodata/repomd.xml : [Errno 14] curl#6 - "Could no relove host: download.postgresql.orag; Unknown error"

if I check the repodata I have some indexes... which one should I download beside repomd.xml.

where do I install repomd.xml and which directory should I put it in?

thank you.

 

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Wednesday, December 19, 2018 9:23 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:

It seems the readline library not found while configuration. you may have to install the readline development librarie.

Use the below command:

yum install readline-devel 

So you need to resolve dependencies first then try ./configure once more time and run make and make install.

On Wed, Dec 19, 2018 at 7:30 PM Pepe TD Vo <pepevo@yahoo.com> wrote:

thank you for looking into this.  Here is the ./configure info:

# cd /home/postgres/software

# gunzip postgresql-11.1.tar.gz

# tar –xvf postgresql-11.1.tar

# cd postgresql-11.1

# ./configure

Checking build system type .. x86_64-pc-linux-gnu

Checking host system tyupe .. x86_64-pc-linux0gnu

Checking which template to use … linux

Checking  whether NLS is wanted … no

Checking for default port number … 5432

Checking for block size …8kB

Checking for segment size … 1GB

Checking for WAL block size … 8kB

Checking for gcc … gcc

Checking whether the C compiler works … yes

Checking for suffix of executables …

Checking whether we are cross compiling … no

Checking for suffix of object files .. .o

Checking whether we are using the GNU C compiler .. yes

Checking whether gcc accepts –g … yes

Checking for gcc option to accept ISO C89 .. non needed

Checking for g++ … g++

Checking whether we ar using the GNU C++ compiler … yes

Checking whether g++ accepts –g … yes

Checking whether gcc supports – Wdeclaration-after-statement, for CFLAGS … yes

Checking whether gcc supports –Wendif-labels, for CFLAGS … yes

Checking whether g++ supports –Wendif-labels, for CXXFLAGS … yes

Checking whether gcc supports –Wmissing-format-attribute, for CFLAGS … yes

Checking whether g++ supports –Wmissing-format-attribute, for CXXFLAGS … yes

Checking whether gxxc supports –Wformat-security, for CFLAGS … yes

Checking whether g++ supports –Wformat-security, for CXXFLAGS … yes

Checking whether gxx supports –fno-strict-aliasing, for CFLAGS … yes

Checking whether g++ supports –fno-strict-aliasing, for CXXFLAGS … yes

Checking whether gxx supports –fwrapv, for CFLAGS … yes

Checking whether g++ supports –fwrapv, for CXXFLAGS … yes

Checking whether gcc supports-fexcess-precision=standard, for CFLAGS .. yes

Checking whether g++ supports-fexcess-precision=standards, for CXXFLAGS … no

Checking whether gcc supports-funroll-loops, for CFLAGS_VECTOR … yes

Checking whether gcc supports-ftree-vectorize, for CFLAGS_VECTOR … yes

Checking whether gxx supports-Wunused-command-line-arguments, for NOT_THE_CFLAGS … no

Checking whether gcc-supports-Wformat-truncation, for NOT_THE_CFLAGS … no

Checking whether gcc supports-Wstringop-truncation, for NOT_THE_CFLAGS … no

Checking whether the C compiler still works … yes

Checking how to run the C preprocessor … gcc E

Checking allow thread-safe client libraries … yes

Checking whether to build with ICU support … no

Checking whether to build with Tcl … no

Checking whether to build Perl modules … no

Checking whether to build with GSSAPI support … no

Checking whether to build with PAM support … no

Checking whether to build with BSD Authentication support … no

Checking whether to build with LDAP support … no

Checking whether to build with Bonjour support … no

Checking whether to build with OpenSSL support … no

Checking whether to build with SELinux support … no

Checking whether to build with system support … no

Checking for grep that handles long lines and –e … /bin/grep

Checking for egrep …/bin/grep –E

Checking for Id used for GCC … /bin/ld

Checking if the linker (/bin/ld) is GNU ld … yes

Checking for ranlib …ranlib

Checking for strip … strip

Checking whether to build

Checking whether it is possible to strip libraries … yes

 Checking for ar … ar

Checking for a BSD-compatible install …/bin/install –c

Checking for tar … /bin/tar

Chechking whether ln –s works … yes

Checking for gawk … gawk

Checking for a thread-safe mkdir –p … /bing/mkdir –p

Checking for bison …/bin/bison

Configure: using bison (GNU Bison) 3.0.4

Checking for flex … /bin/glex

Configure: using flex 2.5.37

Checking for perl …/bin/perl

Configure: using perl 5.16.3

Checking for ANSI C header files … yes

Checking for sys/types.h … yes

Checking for sys/stat.h … yes

Checking for stdlib.h … yes

Checking for string.h … yes

Checking for memory.h … yes

Checking for strings.h … yes

Checking for inttypes.h … yes

Checking for stdint.h …  yes

Checking for unistd.h … yes

Checking if compiler needs certain flags to reject unknown flags … no

Checking for the pthreads library –lpthreads … no

Checking whether pthreads work without any flags … no

Checking whether pthreads work with –Kthread  … no

Checking whether pthreads work with –kthread … no

Checking whether pthreads work with pthread … yes

Checking for joinable pthread attribute .. PTHREAD_CREATE_JOINABLE

Checking if more special flags are required for pthreads … no

Checking for PTHREAD_PRIO_INHERIT … yes

Checking pthread.h usability … yes

Checking pthread.h presence … yes

Checking for pthread.h  … yes

Checking for strerror_r … yes

Checking for getpwuid_r … yes

Checking for gethostbyname_r .. yes

Checking whether strerror_r returens int … no

Checking for main in –lm … yes

Checking for library containing setproctitle .. no

Checking for library containing setproctitle … no

Checking for library containing dlopen … -ldl

Checking for library containing socket … none required

Checking for library containing shl_load … no

Checking for library containing getopt_long .. none required

Checking for library containing shm_open … -lrt

Checking for library containing shm_unlink .. none required

Checking for library containing clock_gettime … none required

Checking for library containingfdatasync … none required

Checking for library containing sched_yield … none required

Checking for library containing gethostbyname_r … none required

Checking for library containing shmget … none required

Checking for library containing readline .. no

Configure: error:readline library not found

If you have readline already installed, see config.log for details on the failure.  It is possible the compiler isn’t  looking in a proper directory. Use –without-readline to disable readline support

 

# mdkir build_dir

#pwd

/home/postges/postgresl-11.1

# cd build_dir

Make: *** No targets specified and no makefile found. Stop

 

v/r,

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Tuesday, December 18, 2018 6:19 PM, SBob <sbob@quadratum-braccas.com> wrote:

Can you send the output of your ./configure command to the list or past a link to it?

On 12/18/18 8:20 AM, Pepe TD Vo wrote:

Hello,

Run these commands:

Install:

sudo yum install pgdg-redhat11-11-2.noarch.rpm

rpm -Uvh pgdg-redhat11-11-2.noarch.rpm

preparing ###############[100%}

successul

but when I do "yum list posgres*  I ge an error that loaded plugins:langpacks, product-id, search-disabled-repos, subscription-manager

This system is not register with an entitlement server

[Erno 14] curl#6- "Could not resolve host: downlaod.posgresql.org; Unknown error" 

Trying other mirror.

One of the configured repositories failed (PostgreSQL 11 7Server -x86_64), and yum doesn't have enough cached data to continue. At this point the on safe thing yum can do is failed.   There are a few ways to work "fix" this:

1. contact the upstream for the repository and get them to fix the problem.

2. Reconfigure the baseirl/etc.for the repository, to point to a working upstream. This is mot often useful if you are using a new distribution release than is supported by the repository (and the packages for the previous distribution release still work).

3. run the command with the repository temporarily disabled

yum --disablerepo=pgdb11..

4.Disable the repositiroy permanently so yum won't use it by default. Yum will then just ignore the repository until you permanently enable it again or use --enablerepo for temporary usage:

 5. Configure the failing repository to be skipped, if it's unavailable.

etc...

--------------------------------------------------

I use the source one

# gunzip postgresql-11.1.tar.gz

# tar -xvf postgresql-11-1.tar

# cd postgresql11.1

#./configure   ----> it's checking build system, host system and etc... all the packages 

#mkdir build_dir

#cd build_dir

# make

now I get an error  Make: *** No targets specified and no makefile found.   Stop.

which target I should put?

thank you.

 

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Tuesday, December 18, 2018 8:40 AM, Erkan Durmuş <derkan@gmail.com> wrote:

Run these commands:

Install:

sudo yum install epel-release

rpm -Uvh https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm

yum install postgresql11-server postgresql11-contrib

Init DB:

/usr/pgsql-11/bin/postgresql-11-setup initdb

Int Service:

sudo systemctl start postgresql-11

sudo systemctl enable postgresql-11

On Tue, Dec 18, 2018 at 4:14 PM Pepe TD Vo <pepevo@yahoo.com> wrote:

Good morning Admin/DBAs

Would you please tell me how to install Postgres 11.x on RHEL7 servers?  I am not able to install it and the pgdg-redhat 11-11-2.noarch.rpm successfully run but nothing happen when I install the packages "yum install Postgres (server, contribute and devel ) etc..."

Is there a way I can install postgres from gz file?

thank you.

 

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success