Re: install Postgres on RHED 7

I found where to download the repomd.xml but I need to know where to put it. And do I need to download the rest of xml.gz file?  the problem is I need to download all at one, ask for the CD/DVD, ask for someone to burn all into the CD/DVD and ask someone else to put on somewhere for me to move to the linux server.  So many processes.

Also, do I need to download all drpms folder too? 

wow... postgresql is harder to install than Oracle.
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 10:31 AM, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> wrote:

This indicates that you either (a) don't have a properly configured DNS server or (b) your network configuration isn't correct and you can't connect to a DNS server to check the hostname download.postgresql.orag.
Try using ping 8.8.8.8. If this fails, try ping <local-gateway-ip>. If that also fails, your local network configuration is wrong and you'll have to check the configuration.

On Wed, Dec 19, 2018 at 8:20 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:

#yum install readline-develfailure: repodata/repomd.xml from pgdg11: {Errno 356] No more mirrors to tryhttps://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(at)gmail(dot)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(at)yahoo(dot)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# ./configureChecking build system type .. x86_64-pc-linux-gnuChecking host system tyupe .. x86_64-pc-linux0gnuChecking which template to use … linuxChecking  whether NLSis wanted … noChecking for default port number … 5432Checking for block size …8kBChecking for segment size … 1GBChecking for WAL block size … 8kBChecking for gcc … gccChecking whether the C compiler works … yesChecking for suffix of executables …Checking whether we are cross compiling … noChecking for suffix of object files .. .oChecking whether we are using the GNU C compiler .. yesChecking whether gcc accepts –g … yesChecking for gcc option to accept ISO C89 .. non neededChecking for g++ … g++Checking whether we ar using the GNU C++ compiler … yesChecking whether g++ accepts –g … yesChecking whether gcc supports – Wdeclaration-after-statement,for CFLAGS … yesChecking whether gcc supports –Wendif-labels, for CFLAGS …yesChecking whether g++ supports –Wendif-labels, for CXXFLAGS …yesChecking whether gcc supports –Wmissing-format-attribute,for CFLAGS … yesChecking whether g++ supports –Wmissing-format-attribute,for CXXFLAGS … yesChecking whether gxxc supports –Wformat-security, for CFLAGS… yesChecking whether g++ supports –Wformat-security, forCXXFLAGS … yesChecking whether gxx supports –fno-strict-aliasing, forCFLAGS … yesChecking whether g++ supports –fno-strict-aliasing, forCXXFLAGS … yesChecking whether gxx supports –fwrapv, for CFLAGS … yesChecking whether g++ supports –fwrapv, for CXXFLAGS … yesChecking whether gcc supports-fexcess-precision=standard,for CFLAGS .. yesChecking whether g++ supports-fexcess-precision=standards,for CXXFLAGS … noChecking whether gcc supports-funroll-loops, forCFLAGS_VECTOR … yesChecking whether gcc supports-ftree-vectorize, forCFLAGS_VECTOR … yesChecking whether gxxsupports-Wunused-command-line-arguments, for NOT_THE_CFLAGS … noChecking whether gcc-supports-Wformat-truncation, forNOT_THE_CFLAGS … noChecking whether gcc supports-Wstringop-truncation, for NOT_THE_CFLAGS… noChecking whether the C compiler still works … yesChecking how to run the C preprocessor … gcc EChecking allow thread-safe client libraries … yesChecking whether to build with ICU support … noChecking whether to build with Tcl … noChecking whether to build Perl modules … noChecking whether to build with GSSAPI support … noChecking whether to build with PAM support … noChecking whether to build with BSD Authentication support …noChecking whether to build with LDAP support … noChecking whether to build with Bonjour support … noChecking whether to build with OpenSSL support … noChecking whether to build with SELinux support … noChecking whether to build with system support … noChecking for grep that handles long lines and –e … /bin/grepChecking for egrep …/bin/grep –EChecking for Id used for GCC … /bin/ldChecking if the linker (/bin/ld) is GNU ld … yesChecking for ranlib …ranlibChecking for strip … stripChecking whether to buildChecking whether it is possible to strip libraries … yes Checking for ar … arChecking for a BSD-compatible install …/bin/install –cChecking for tar … /bin/tarChechking whether ln –s works … yesChecking for gawk … gawkChecking for a thread-safe mkdir –p … /bing/mkdir –pChecking for bison …/bin/bisonConfigure: using bison (GNU Bison) 3.0.4Checking for flex … /bin/glexConfigure: using flex 2.5.37Checking for perl …/bin/perlConfigure: using perl 5.16.3Checking for ANSI C header files … yesChecking for sys/types.h … yesChecking for sys/stat.h … yesChecking for stdlib.h … yesChecking for string.h … yesChecking for memory.h … yesChecking for strings.h … yesChecking for inttypes.h … yesChecking for stdint.h … yesChecking for unistd.h … yesChecking if compiler needs certain flags to reject unknownflags … noChecking for the pthreads library –lpthreads … noChecking whether pthreads work without any flags … noChecking whether pthreads work with –Kthread  … noChecking whether pthreads work with –kthread … noChecking whether pthreads work with pthread … yesChecking for joinable pthread attribute ..PTHREAD_CREATE_JOINABLEChecking if more special flags are required for pthreads …noChecking for PTHREAD_PRIO_INHERIT … yesChecking pthread.h usability … yesChecking pthread.h presence … yesChecking for pthread.h … yesChecking for strerror_r … yesChecking for getpwuid_r … yesChecking for gethostbyname_r .. yesChecking whether strerror_r returens int … noChecking for main in –lm … yesChecking for library containing setproctitle .. noChecking for library containing setproctitle … noChecking for library containing dlopen … -ldlChecking for library containing socket … none requiredChecking for library containing shl_load … noChecking for library containing getopt_long .. none requiredChecking for library containing shm_open … -lrtChecking for library containing shm_unlink .. none requiredChecking for library containing clock_gettime … nonerequiredChecking for library containingfdatasync … none requiredChecking for library containing sched_yield … none requiredChecking for library containing gethostbyname_r … nonerequiredChecking for library containing shmget … none requiredChecking for library containing readline .. noConfigure: error:readline library not foundIf you have readline already installed, see config.log fordetails on the failure.  It is possiblethe compiler isn’t  looking in a properdirectory. Use –without-readline to disable readline support # mdkir build_dir#pwd/home/postges/postgresl-11.1# cd build_dirMake: *** No targets specified and no makefilefound. 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(at)quadratum-braccas(dot)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(at)gmail(dot)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(at)yahoo(dot)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