thomastthai
commented
7 years ago I manually copied the files to their rightful location and used "ldconfig /usr/local/lib64/" and it seems to be fine even though it said it failed the regression test:
bash-4.2$ make installcheck /usr/pgsql-9.6/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/pgsql-9.6/bin' --inputdir=test --load-language=plpgsql --dbname=contrib_regression base (using postmaster on Unix socket, default port) ============== dropping database "contrib_regression" ============== DROP DATABASE ============== creating database "contrib_regression" ============== CREATE DATABASE ALTER DATABASE ============== installing plpgsql ============== CREATE LANGUAGE ============== running regression test queries ============== test base ... FAILED
====================== 1 of 1 tests failed.
The differences that caused some tests to fail can be viewed in the file "/home/ec2-user/pg_rrule/regression.diffs". A copy of the test summary that you see above is saved in the file "/home/ec2-user/pg_rrule/regression.out".
make: *** [installcheck] Error 1
*** /home/ec2-user/pg_rrule/test/expected/base.out 2016-11-23 09:17:26.993916363 +0000 --- /home/ec2-user/pg_rrule/results/base.out 2016-11-23 12:48:36.746259694 +0000
* 1,19 ** \set ECHO 0 ! SELECT 'FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z'::rrule; ! rrule
FREQ=WEEKLY;UNTIL=20200101T045102Z (1 row)
SELECT get_byday('FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z;BYDAY=MO,TH,SU'::rrule); ! get_byday
{2,5,1} (1 row)
SELECT get_freq('FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z'::rrule); ! get_freq
WEEKLY (1 row) --- 1,19 ---- \set ECHO 0 ! unrecognized value "0" for "ECHO"; assuming "none" SELECT 'FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z'::rrule; ! rrule
FREQ=WEEKLY;UNTIL=20200101T045102Z (1 row)
SELECT get_byday('FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z;BYDAY=MO,TH,SU'::rrule); ! get_byday
{2,5,1} (1 row)
SELECT get_freq('FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z'::rrule); ! get_freq
WEEKLY (1 row)
* 23,34 ** get_occurrences('FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z;BYDAY=SA;BYHOUR=10;BYMINUTE=51;BYSECOND=2'::rrule, '2019-12-07 10:51:02+00'::timestamp with time zone) ); ! unnest ! ------------------------ ! 2019-12-07 10:51:02+00 ! 2019-12-14 10:51:02+00 ! 2019-12-21 10:51:02+00 ! 2019-12-28 10:51:02+00 (4 rows)
SELECT * FROM --- 23,35 ---- get_occurrences('FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z;BYDAY=SA;BYHOUR=10;BYMINUTE=51;BYSECOND=2'::rrule, '2019-12-07 10:51:02+00'::timestamp with time zone) ); ! WARNING: Can't get timezone from current session! Fallback to UTC. ! unnest ! ------------------------------ ! Sat Dec 07 02:51:02 2019 PST ! Sat Dec 14 02:51:02 2019 PST ! Sat Dec 21 02:51:02 2019 PST ! Sat Dec 28 02:51:02 2019 PST (4 rows)
SELECT * FROM
* 36,47 ** get_occurrences('FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z;BYDAY=SA;BYHOUR=10;BYMINUTE=51;BYSECOND=2'::rrule, '2019-12-07 10:51:02'::timestamp) ); ! unnest ! --------------------- ! 2019-12-07 10:51:02 ! 2019-12-14 10:51:02 ! 2019-12-21 10:51:02 ! 2019-12-28 10:51:02 (4 rows)
ROLLBACK; --- 37,48 ---- get_occurrences('FREQ=WEEKLY;INTERVAL=1;WKST=MO;UNTIL=20200101T045102Z;BYDAY=SA;BYHOUR=10;BYMINUTE=51;BYSECOND=2'::rrule, '2019-12-07 10:51:02'::timestamp) ); ! unnest ! -------------------------- ! Sat Dec 07 10:51:02 2019 ! Sat Dec 14 10:51:02 2019 ! Sat Dec 21 10:51:02 2019 ! Sat Dec 28 10:51:02 2019 (4 rows)
ROLLBACK;
======================================================================
I'm getting a failure during a regression test.
bash-4.2$ ls -la /usr/pgsql-9.6/lib/pg_rrule.so -rwxr-xr-x 1 root root 63941 Nov 23 12:16 /usr/pgsql-9.6/lib/pg_rrule.so
bash-4.2$ ls -la /usr/local/lib64/libical.so.2 lrwxrwxrwx 1 root root 17 Nov 23 11:20 /usr/local/lib64/libical.so.2 -> libical.so.2.0.50