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
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: