Home
> AWS, CentOS, Fedora 15 64 bit, PostgreSQL > Post install check of plproxy-2.4 on replicated PostgreSQL 9.1.3 at Amazon Web Services (EC2 , S3)
Post install check of plproxy-2.4 on replicated PostgreSQL 9.1.3 at Amazon Web Services (EC2 , S3)
I got an error on the post install check of plproxy:
root@domU-12-31-39-07-39-AE-node-1:[Fri May 18 18:37:24]:[/opt/installs/plproxy-2.4]$ make installcheck postgres /usr/lib64/pgsql/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=. --psqldir='/usr/bin' --dbname=regression --inputdir=test --dbname=regression plproxy_init plproxy_test plproxy_select plproxy_many plproxy_errors plproxy_clustermap plproxy_dynamic_record plproxy_encoding plproxy_split plproxy_target plproxy_sqlmed (using postmaster on Unix socket, default port) ============== dropping database "regression" ============== DROP DATABASE ============== creating database "regression" ============== CREATE DATABASE ALTER DATABASE ============== running regression test queries ============== test plproxy_init ... ok test plproxy_test ... FAILED test plproxy_select ... ok test plproxy_many ... ok test plproxy_errors ... ok test plproxy_clustermap ... ok test plproxy_dynamic_record ... ok test plproxy_encoding ... FAILED (test process exited with exit code 2) test plproxy_split ... ok test plproxy_target ... ok test plproxy_sqlmed ... ok ======================= 2 of 11 tests failed. ======================= The differences that caused some tests to fail can be viewed in the file "/opt/installs/plproxy-2.4/regression.diffs". A copy of the test summary that you see above is saved in the file "/opt/installs/plproxy-2.4/regression.out". make: *** [installcheck] Error 1
how to fix plproxy_test:
Edit the plproxy Make file and add to REGRESS_OPTS proper values in a view to use the correct user and host
root@domU-12-31-39-07-39-AE-node-1:[Fri May 18 19:10:12]:[/opt/installs/plproxy-2.4]$ fgrep REGRESS_OPTS Makefile REGRESS_OPTS = --dbname=regression --inputdir=test --user=postgres --host=127.0.0.1 # now we have : root@domU-12-31-39-07-39-AE-node-1:[Fri May 18 19:05:51]:[/opt/installs/plproxy-2.4]$ make installcheck /usr/lib64/pgsql/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=. --psqldir='/usr/bin' --dbname=regression --inputdir=test --user=postgres --host=127.0.0.1 --no-locale --dbname=regression plproxy_init plproxy_test plproxy_select plproxy_many plproxy_errors plproxy_clustermap plproxy_dynamic_record plproxy_encoding plproxy_split plproxy_target plproxy_sqlmed (using postmaster on 127.0.0.1, default port) ============== dropping database "regression" ============== DROP DATABASE ============== creating database "regression" ============== CREATE DATABASE ALTER DATABASE ============== running regression test queries ============== test plproxy_init ... ok test plproxy_test ... ok test plproxy_select ... ok test plproxy_many ... ok test plproxy_errors ... ok test plproxy_clustermap ... ok test plproxy_dynamic_record ... ok test plproxy_encoding ... FAILED (test process exited with exit code 2) test plproxy_split ... ok test plproxy_target ... ok test plproxy_sqlmed ... ok ======================= 1 of 11 tests failed. =======================
Advertisements
Categories: AWS, CentOS, Fedora 15 64 bit, PostgreSQL
AWS, EC2, plproxy-2.4, PostgreSQL 9.1.3
Comments (0)
Trackbacks (0)
Leave a comment
Trackback