On Mon, Nov 21, 2011 at 1:06 AM, Cédric Villemain < cedric.villemain.deb...@gmail.com> wrote:
> 2011/11/20 Raghavendra <raghavendra....@enterprisedb.com>: > > Respected, > > I have tried installing pgfincore with PG 9.1(one-click installer). But > > facing below error. > > [root@localhost pgfincore-v1.1]# export > PATH=/opt/PostgreSQL/9.1/bin:$PATH > > [root@localhost pgfincore-v1.1]# echo $PATH > > > /opt/PostgreSQL/9.1/bin:/usr/lib/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > > [root@localhost pgfincore-v1.1]# which pg_config > > /opt/PostgreSQL/9.1/bin/pg_config > > [root@localhost pgfincore-v1.1]# make > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > cp pgfincore.sql pgfincore--.sql > > gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith > > -Wdeclaration-after-statement -Wendif-labels -Wformat-security > > -fno-strict-aliasing -fwrapv -fpic -I. -I. > > -I/opt/PostgreSQL/9.1/include/postgresql/server > > -I/opt/PostgreSQL/9.1/include/postgresql/internal -D_GNU_SOURCE > > -I/usr/local/include/libxml2 -I/usr/local/include -c -o pgfincore.o > > pgfincore.c > > gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith > > -Wdeclaration-after-statement -Wendif-labels -Wformat-security > > -fno-strict-aliasing -fwrapv -fpic -L/opt/PostgreSQL/9.1/lib > > -L/usr/local/lib -L/usr/local/lib > > -Wl,-rpath,'/opt/PostgreSQL/9.1/lib',--enable-new-dtags -shared -o > > pgfincore.so pgfincore.o > > rm pgfincore.o > > [root@localhost pgfincore-v1.1]# make install > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > /bin/mkdir -p '/opt/PostgreSQL/9.1/share/postgresql/extension' > > /bin/mkdir -p '/opt/PostgreSQL/9.1/lib/postgresql' > > /bin/mkdir -p '/opt/PostgreSQL/9.1/doc/postgresql/extension' > > grep: /pgfincore.control: No such file or directory > > grep: /pgfincore.control: No such file or directory > > /bin/sh > > > /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh > > -c -m 644 ./pgfincore.control > > '/opt/PostgreSQL/9.1/share/postgresql/extension/' > > /bin/sh > > > /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh > > -c -m 644 ./pgfincore--unpackaged--.sql ./pgfincore--.sql > > '/opt/PostgreSQL/9.1/share/postgresql/extension/' > > > /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh: > > ./pgfincore--unpackaged--.sql does not exist. > > make: *** [install] Error 1 > > Please assist me, thanks in advance. > > buggy Makefile. Thanks for the report. > I'll fix that soon and keep you informed. > -- > Thank you Cédric Villemain. grep: /pgfincore.control: No such file or directory > cp pgfincore.sql pgfincore--.sql > > /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh: > ./pgfincore--unpackaged--.sql does not exist. > make: *** [install] Error 1 On the above two errors, I tried one more time with small changes which worked well. I have copied the files displayed in error output with those which MAKE is looking for. [root@localhost pgfincore-v1.1]# cp pgfincore--unpackaged--1.1.sql pgfincore--unpackaged--.sql [root@localhost pgfincore-v1.1]# make install /bin/mkdir -p '/opt/PostgreSQL/9.1/share/postgresql/extension' /bin/mkdir -p '/opt/PostgreSQL/9.1/lib/postgresql' /bin/mkdir -p '/opt/PostgreSQL/9.1/doc/postgresql/extension' grep: /pgfincore.control: No such file or directory grep: /pgfincore.control: No such file or directory /bin/sh /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./pgfincore.control '/opt/PostgreSQL/9.1/share/postgresql/extension/' /bin/sh /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./pgfincore--unpackaged--.sql ./pgfincore--.sql '/opt/PostgreSQL/9.1/share/postgresql/extension/' /bin/sh /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -m 755 pgfincore.so '/opt/PostgreSQL/9.1/lib/postgresql/' /bin/sh /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./README.rst '/opt/PostgreSQL/9.1/doc/postgresql/extension/' & -bash-4.1$ ./pgs ql -p 5433 psql.bin (9.1.1) Type "help" for help. postgres=# create extension pgfincore; ERROR: could not stat file "/opt/PostgreSQL/9.1/share/postgresql/extension/pgfincore--1.1.sql": No such file or directory I verified in the extension directory, there is a file pgfincore--.sql and I copied to pfincore--1.1.sql. -bash-4.1$ pwd /opt/PostgreSQL/9.1/share/postgresql/extension -bash-4.1$ cp pgfincore--.sql pgfincore--1.1.sql -bash-4.1$ ./pgs ql -p 5433 psql.bin (9.1.1) Type "help" for help. postgres=# create extension pgfincore; CREATE EXTENSION postgres=# \dx List of installed extensions Name | Version | Schema | Description -----------+---------+------------+----------------------------------------- adminpack | 1.0 | pg_catalog | administrative functions for PostgreSQL * pgfincore | 1.1 | public | examine and manage the os buffer cache* plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language (3 rows) postgres=# select * from pgfincore('accounts'); relpath | segment | os_page_size | rel_os_pages | pages_mem | group_mem | os_pages_free | databit ------------------+---------+--------------+--------------+-----------+-----------+---------------+--------- base/12780/16393 | 0 | 4096 | 2 | 0 | 0 | 78195 | (1 row) Great tool, to help understanding PostgreSQL Caching. --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/