Re: [GENERAL] pg_similarity

2013-10-17 Thread sachin kotwal
I tried the installation as suggested at
http://pgsimilarity.projects.pgfoundry.org/

after make install command we have run following command:-

psql -f SHAREDIR/contrib/pg_similarity.sql mydb

Here SHAREDIR is /usr/local/pgsql/share/extension/ 
under this directory we can see file pg_similarity.sql and mydb is your
database name.
so provide correct path and database then pg_similarity will create it's
classes,functions and operators etc.

after that you can load pg_similarity using SQL command load
'pg_similarity'; or 
copy a sample file at tarball (pg_similarity.conf.sample) to PGDATA (as
pg_similarity.conf) and include the following line in postgresql.conf:-
include 'pg_similarity.conf'




-
Thanks and Regards,

Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/pg-similarity-tp5774125p5774835.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] pg_similarity

2013-10-09 Thread janek12
Now the Steps:
$ USE_PGXS=1 make
$ USE_PGXS=1 make install
are working.
But I still don't have the directory 'SHAREDIR/contrib/pg_similarity.sql'
 
Janek Sendrowski
 


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] pg_similarity

2013-10-09 Thread janek12
Thanks a lot!
Now it's working :)
 
Janek Sendrowksi


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] pg_similarity

2013-10-07 Thread Pavel Stehule
Hello

you are missing some from basic packages on your system probably

postgresql-devel.i686 : PostgreSQL development header files and libraries
postgresql-server.i686 : The programs needed to create and run a PostgreSQL

Regards

Pavel Stehule


2013/10/7 jane...@web.de

 Hi,

 I have some problems to install the pg_similarity Module. It's my first
 time to install something like that and I'm a novice in Linux.
 This is the Introduction:
 tar -zxf pg_similarity-0.0.19.tgz
 $ cd pg_similarity-0.0.19
 $ $EDITOR Makefile # edit PG_CONFIG iif necessary
 $ USE_PGXS=1 make
 $ USE_PGXS=1 make install
 $ psql -f SHAREDIR/contrib/pg_similarity.sql mydb # SHAREDIR is pg_config
 --sharedir

 link: http://pgsimilarity.projects.pgfoundry.org/

 I' ve been editing the file 'Makefile' with my path of the PG_CONFIG:
 PG_CONFIG = /usr/bin/pg_config.
 But at the next the error:
 'Makefile:14: /usr/lib/postgresql/9.2/lib/pgxs/src/makefiles/pgxs.mk: No
 such file or directory
 make: *** No rule to make target
 `/usr/lib/postgresql/9.2/lib/pgxs/src/makefiles/pgxs.mk'. Stop.' is
 raising.

 I don't know what to do. I count't find another introduction

 Janek Sendrowski