It's definitely in my path. And stays there, even when I run sub-processes (which I thought might be the problem, after you mentioned it).
bash-4.2$ pg_ctl pg_ctl: no operation specified Try "pg_ctl --help" for more information. bash-4.2$ type pg_ctl pg_ctl is hashed (/opt/rh/rh-postgresql12/root/usr/bin/pg_ctl) bash-4.2$ echo $PATH /opt/rh/rh-postgresql12/root/usr/bin:/opt/app-root/src/bin:/opt/app-root/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin bash-4.2$ bash bash-4.2$ echo $PATH /opt/rh/rh-postgresql12/root/usr/bin:/opt/app-root/src/bin:/opt/app-root/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin bash-4.2$ exit exit bash-4.2$ bash -c 'echo $PATH' /opt/rh/rh-postgresql12/root/usr/bin:/opt/app-root/src/bin:/opt/app-root/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin Domino On Tue, Aug 2, 2022 at 1:43 PM Orhan Kislal <okis...@vmware.com.invalid> wrote: > Hey Domino, > > Thanks for testing the RC. For versions 1.19.0 and later we need to run a > pg_ctl/gpstop command to update a GUC value as part of the install process > (part of a database upgrade requirement). Could you check your path to make > sure you have it in your path? > > Thanks, > > Orhan > ________________________________ > From: Domino Valdano <domino@valdano.email> > Sent: Tuesday, August 2, 2022 10:13 PM > To: dev@madlib.apache.org <dev@madlib.apache.org> > Subject: Re: Apache MADlib 1.20.0 Release (RC2) > > ⚠ External Email > > I tried installing it on Centos7, using the centos7/postgresql-12-centos7 > docker image. Ran into a few issues: > > - First one was easily fixable and seems fine (missing m4 dependency). > - Second problem is it prompts for a password when there is no password. > That seems like a bug to me, since on the command line you can connect to > the database fine with no password, and create and read tables without any > problem. But this behavior feels familiar, anyone remember if there was an > easy workaround for this odd madlib quirk? > - Third problem (possibly a weird side-effect of second problem?) is that > if I press enter at that password prompt, I get the error "No such file or > directory". > > I'm not sure whether it accepted the empty string as the correct password, > and the third one is an unrelated error... or if it's just a case of it > misreporting an intermediate "Authentication Denied" error to the user as a > "No such file or directory". > > Holding off on voting, until I figure out if there's a simple workaround > for #2, as that might make the difference between a +1 and a -1 > > Domino > > bash-4.2$ cat /etc/*release* > > CentOS Linux release 7.8.2003 (Core) > > Derived from Red Hat Enterprise Linux 7.8 (Source) > > NAME="CentOS Linux" > > VERSION="7 (Core)" > > ID="centos" > > ID_LIKE="rhel fedora" > > VERSION_ID="7" > > PRETTY_NAME="CentOS Linux 7 (Core)" > > ANSI_COLOR="0;31" > > CPE_NAME="cpe:/o:centos:centos:7" > > HOME_URL=" > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.centos.org%2F&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Tyqsol9%2BxowPhTmiXZlayp8869CgZs0d0zDXuZg1wrY%3D&reserved=0 > " > > BUG_REPORT_URL=" > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.centos.org%2F&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mzd3eTLrju1F6MN7Dz419q2BP9BiXgJCjNpvL0dFkOU%3D&reserved=0 > " > > > CENTOS_MANTISBT_PROJECT="CentOS-7" > > CENTOS_MANTISBT_PROJECT_VERSION="7" > > REDHAT_SUPPORT_PRODUCT="centos" > > REDHAT_SUPPORT_PRODUCT_VERSION="7" > > > CentOS Linux release 7.8.2003 (Core) > > CentOS Linux release 7.8.2003 (Core) > > cpe:/o:centos:centos:7 > > > bash-4.2$ rpm -i apache-madlib-1.20.0-CentOS7.rpm > > error: Failed dependencies: > > m4 >= 1.4 is needed by madlib-1.20.0-1.x86_64 > > > bash-4.2$ yum install m4 > > ... > > Installed: > > m4.x86_64 0:1.4.16-10.el7 > > > bash-4.2# rpm -i apache-madlib-1.20.0-CentOS7.rpm > > bash-4.2# rpm -qa |grep madlib > > madlib-1.20.0-1.x86_64 > > > bash-4.2$ psql -l > > List of databases > > Name | Owner | Encoding | Collate | Ctype | Access privileges > > > -----------+----------+-----------+---------+-------+----------------------- > > madlib | postgres | SQL_ASCII | C | C | > > postgres | postgres | SQL_ASCII | C | C | > > template0 | postgres | SQL_ASCII | C | C | =c/postgres > + > > | | | | | postgres=CTc/postgres > > template1 | postgres | SQL_ASCII | C | C | =c/postgres > + > > | | | | | postgres=CTc/postgres > > (4 rows) > > > bash-4.2$ id > > uid=26(postgres) gid=26(postgres) groups=26(postgres),0(root) > > bash-4.2$ /usr/local/madlib/bin/madpack -c/madlib install -ppostgres > > Password for user postgres: > > Traceback (most recent call last): > > File "/usr/local/madlib/Versions/1.20.0/bin/../madpack/madpack.py", line > 1537, in <module> > > main(sys.argv[1:]) > > File "/usr/local/madlib/Versions/1.20.0/bin/../madpack/madpack.py", line > 1397, in main > > _internal_run_query("SELECT 1", False) > > File "/usr/local/madlib/Versions/1.20.0/bin/../madpack/madpack.py", line > 99, in _internal_run_query > > return run_query(sql, con_args, show_error) > > File "/usr/local/madlib/Versions/1.20.0/madpack/utilities.py", line 90, > in run_query > > stderr=subprocess.PIPE).communicate() > > File "/usr/lib64/python2.7/subprocess.py", line 711, in __init__ > > errread, errwrite) > > File "/usr/lib64/python2.7/subprocess.py", line 1327, in _execute_child > > raise child_exception > > OSError: [Errno 2] No such file or directory > > bash-4.2$ echo $PGDATA > > /var/lib/pgsql/data > > > bash-4.2# psql madlib > > psql (12.7) > > Type "help" for help. > > > madlib=# select version(); > > version > > > > ------------------------------------------------------------------------------------------------------------- > > PostgreSQL 12.7 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 > 20150623 (Red Hat 4.8.5-44), 64-bit > > (1 row) > > madlib=# create table hi (a int); > > CREATE TABLE > > madlib=# insert into hi (a) values (3); > > INSERT 0 1 > > madlib=# select * from hi; > > a > > --- > > 3 > > (1 row) > > > madlib=# \q > > On Tue, Aug 2, 2022 at 12:22 AM Nikhil Kak <n...@vmware.com.invalid> > wrote: > > > +1 binding > > > > Tested the rpm on centos 7 + pg12 > > > > All the install-check, dev-check and unit-test tests passed > > > > - Nikhil > > ________________________________ > > From: Orhan Kislal <okis...@vmware.com.INVALID> > > Sent: Monday, August 1, 2022 5:53 PM > > To: dev@madlib.apache.org <dev@madlib.apache.org> > > Subject: Re: Apache MADlib 1.20.0 Release (RC2) > > > > ⚠ External Email > > > > +1 (binding) > > > > Best, > > > > Orhan Kislal > > ________________________________ > > From: Ekta Khanna <khannae...@apache.org> > > Sent: Monday, August 1, 2022 11:37 AM > > To: dev@madlib.apache.org <dev@madlib.apache.org> > > Subject: Re: Apache MADlib 1.20.0 Release (RC2) > > > > ⚠ External Email > > > > +1 (binding) > > > > Build, installed the release rpm and ran dev-check, unit-test, > > install-check on GP6(centos7). All passed. > > > > Best Regards, > > Ekta > > > > On 2022/07/29 15:47:54 Venkatesh Raghavan wrote: > > > Small correction. Deadline is August 3. > > > > > > Regards, > > > > > > Venky > > > ________________________________ > > > From: Venkatesh Raghavan <raghava...@vmware.com.INVALID> > > > Sent: Friday, July 29, 2022 8:41 AM > > > To: dev@madlib.apache.org <dev@madlib.apache.org>; > > u...@madlib.apache.org <u...@madlib.apache.org> > > > Subject: Apache MADlib 1.20.0 Release (RC2) > > > > > > > > > ⚠ External Email > > > > > > Hello Apache MADlib Community, > > > > > > > > > This is the vote for Apache MADlib 1.20.0 Release (RC2). It provides > the > > source release tarball and a convenience binary for CentOS7. > > > > > > > > > The vote will run for at least 72 hours and close on August 2nd, 2022 > > @20:00 UTC (15:00 EST). A minimum of 3 binding +1 votes and more binding > +1 > > than binding -1 are required to pass. > > > > > > > > > The main goals of this release are: > > > > > > > > > New features: > > > > > > - XGBoost: Python-based XGBoost with single and grid search > > executions (MADLIB-1425, MADLIB-1490) > > > > > > - Graph: Add multicolumn support for WCC and Pagerank (MADLIB-1502, > > MADLIB-1503) > > > > > > > > > Improvements: > > > > > > - Utilities: Reuse update plan in GroupIterationController > > > > > > - Documentation: Update online examples for various modules > > > > > > > > > Bug fixes: > > > > > > - Elastic Net - GLM - SVM: Adjust ORCA to reduce planning time > > > > > > > > > 1.20.0 docs available here: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmadlib.apache.org%2Fdocs%2Frc%2Findex.html&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=8Sy%2FVeq74TjAln7QlJTBeGESJqJQ8uHQ%2Fqs8BHxdPcE%3D&reserved=0 > > > > > > > > > For additional information, please see: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FMADLIB%2FMADlib%2B1.20.0&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=NjjzHxIyaStSXQXLZYhlsArjeGiUBrxnNW8f6FPf204%3D&reserved=0 > > > > > > > > > Here are the release artifact details: > > > > > > Source release tag to be voted on: rc/1.20.0-rc2, located here: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fmadlib%2Ftree%2Frc%2F1.20.0-rc2&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=hLadqh2sq9XA9tCdV44sNbiGPCjT%2B3haRkIKm0OiOiw%3D&reserved=0 > > > > > > > > > Source release tarball can be retrieved from the following locations: > > > > > > Package: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-src.tar.gz&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=WjYXQsag0RMWTJxEqu3a5yzaJLz4b75Paq%2FSbG1W9BI%3D&reserved=0 > > > > > > PGP Signature: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-src.tar.gz.asc&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=AWpF8WG9UwyUWkoAqp395owEpCMO5IOw02ELKIpOY9Y%3D&reserved=0 > > > > > > SHA512 Hash: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-src.tar.gz.sha512&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9xy5KohGdUXoQYEK5mvvhKpBhV2pRho0QUBQAhza2QI%3D&reserved=0 > > > > > > > > > Convenience binary for CentOS7 (compiled with gcc 4.8) can be retrieved > > from the following locations: > > > > > > Package: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-CentOS7.rpm&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=i8XRO%2FIo3kla79FkuV5fXd5Mo%2BjczkCfl0iFpZRZ4M0%3D&reserved=0 > > > > > > PGP Signature: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-CentOS7.rpm.asc&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=OeSAEG9Hz41hVYbyd5WVK9F57N5UyaBHVZPWyqeQ32U%3D&reserved=0 > > > > > > SHA512 Hash: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2F1.20.0.RC2%2Fapache-madlib-1.20.0-CentOS7.rpm.sha512&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=QjCU02eToo3C4kdGVytNfr2NQtXlPx9BWhGX728HkMA%3D&reserved=0 > > > > > > > > > The PGP KEYS file used to validate the signature of the release > > artifacts is available here: > > > > > > > > > https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdist.apache.org%2Frepos%2Fdist%2Fdev%2Fmadlib%2FKEYS&data=05%7C01%7Cokislal%40vmware.com%7Cdba529db21d34ccc283a08da74bb1dbd%7Cb39138ca3cee4b4aa4d6cd83d9dd62f0%7C0%7C1%7C637950644268515137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=tak4GRKOhd0sks98n4R27acstzvu5XacD7SqtUsUgXI%3D&reserved=0 > > > > > > > > > To help in tallying the vote, PMC members please be sure to indicate > > “(binding)” with the vote. > > > > > > > > > [ ] +1 approve > > > > > > [ ] +0 no opinion > > > > > > [ ] -1 disapprove (and the reason why) > > > > > > > > > Best regards, > > > > > > Venkatesh Raghavan <raghava...@vmware.com> > > > > > > ------------------------------------------------------- > > > Venkatesh Raghavan > > > Sr. Manager of Product (Greenplum) > > > raghava...@vmware.com > > > +1 508-410-7296 > > > > > > [cid:1bdaf535-bb9f-4a2a-9249-974074993bf0] > > > > > > ________________________________ > > > > > > ⚠ External Email: This email originated from outside of the > > organization. Do not click links or open attachments unless you recognize > > the sender. > > > > > > > ________________________________ > > ⚠ External Email: This email originated from outside of the organization. > Do not click links or open attachments unless you recognize the sender. >
