Re: [ADMIN] Full text search: How to implement?
Hi, you must install from the contrib package fulltext regards Mario Soto De: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] En nombre de Ramiro Barreca Enviado el: viernes, 11 de noviembre de 2011 12:06 Para: pgsql-admin@postgresql.org Asunto: [ADMIN] Full text search: How to implement? Can anybody advice where to find a "How-to" to implement full text search ina PG 8.4 database? There might be some documents or whitepapers that learn about it. Ramiro Barreca rbarr...@gmail.com
Re: [ADMIN] [GENERAL] postgresql Secure Mode
2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > On Mon, Aug 08, 2005 at 11:41:24AM -0400, Mario Soto Cordones - Venezuela > wrote: > > LOG Say: > > > > LOG: conexión recibida: host=192.168.0.100 port=1175 > > FATAL: no hay una lÃnea en pg_hba.conf para «192.168.0.100», > > usuario «vasa», base de datos «vasa», SSL inactivo > > LOG: conexión recibida: host=192.168.0.100 port=1226 > > FATAL: no hay una lÃnea en pg_hba.conf para «192.168.0.100», > > usuario «vasa», base de datos «vasa», SSL inactiv > > > > but SSl its active > > Yeah, the server thinks it's active, but the client doesn't know it. > Did you try connecting with psql? Maybe your EMS client does not > support SSL (it'd surprise me.) Yes EMS suport this but say unable to autenticate user thank > > -- > Alvaro Herrera () > "Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias) > -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] [GENERAL] postgresql Secure Mode
LOG Say: LOG: conexión recibida: host=192.168.0.100 port=1175 FATAL: no hay una lÃnea en pg_hba.conf para «192.168.0.100», usuario «vasa», base de datos «vasa», SSL inactivo LOG: conexión recibida: host=192.168.0.100 port=1226 FATAL: no hay una lÃnea en pg_hba.conf para «192.168.0.100», usuario «vasa», base de datos «vasa», SSL inactiv but SSl its active select * from pg_settings where name = 'ssl' ssl on Connections and Authentication / Security and Authentication Enables SSL connections. postmaster boolconfiguration file thank you 2005/8/8, Mario Soto Cordones - Venezuela <[EMAIL PROTECTED]>: > Hola Alvaro no po lostee en espanol porque pense que este problema > correspondia a la lista de admin, o me equivoco > > Saludos > > > 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > > On Mon, Aug 08, 2005 at 11:06:22AM -0400, Mario Soto Cordones - Venezuela > > wrote: > > > 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > > > > On Mon, Aug 08, 2005 at 10:24:54AM -0400, Mario Soto Cordones - > > > > Venezuela wrote: > > > > > > > but when I try to connect myself for example from an application EMS > > > > > postgresql manager by means of SSL, says that it cannot authenticate > > > > > in user > > > > > > > > Ok, so do you have the user created in Postgres by means of CREATE USER > > > > or createuser? Try changing the password. Also, please show us the > > > > relevant extract of the server log file. > > > > > > yes expample the user is vasa > > > > > > the log say > > > > > > LOG: no se pudo cargar el archivo del certificado raiz > > > /var/lib/pgsql/data/bd/root.crt > > > DETALLE: Los certificados de clientes no se verificaran > > > > This isn't the problem. Here it's only telling you that were the client > > to hand a certificate, they wouldn't be checked. There must be other > > message. > > > > > but I don't understand because it leaves that message > > > > It's because you don't have the root.crt file, or the file doesn't have > > the proper permissions. > > > > > > I don't understand why didn't you post this problem to pgsql-es-ayuda > > first ... > > > > -- > > Alvaro Herrera () > > Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí." > > "Y que hayan abogados, para que la gente no culpe de todo a Satanás" > > > > > -- > cordialmente, > > Ing. Mario Soto Cordones > -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] postgresql Secure Mode
Hi, i have a probem,. I am trying to configure postgresql in sure way, I have made the following thing: 1. - I have created the certificate and put this in the directory it data 2. - given him privileges to the user postgresql for the certificate 3. - in the file postgresql.conf, modify the parameters ssl = true to use md5 = true 4. - in the file pg_hba.conf adds one it lines this way hostssl all all 192.168.0.0/255.255.255.0 md5 5. - stsrt postresql But when trying to connect me says that the user cannot authenticate some idea thank you very much -- cordialmente, Ing. Mario Soto Cordones -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] catalog of postgres
OK i have a big mistake, i saw bad, now my new query is SELECT nspname as esquema, relname as objeto, (CASE relkind WHEN 'v' THEN 'Vista' WHEN 'i' THEN 'Indice' WHEN 'S' THEN 'Secuencia' WHEN 'r' THEN 'Tabla' WHEN 'c' THEN 'Tipo' END) as tipo FROM pg_class bc, pg_attribute ta, pg_namespace ns, pg_type ty WHERE ta.attrelid = bc.oid and ta.attnum > 0 and not ta.attisdropped and nspname <> 'information_schema' and nspname not like 'pg_%' and relam = 0 and bc.relnamespace = ns.oid and bc.relname not like 'pg_%' and ta.atttypid = ty.oid group by nspname, relname, relkind order by tipo desc select * from pg_class where relkind = 'i' but not you where they stay the functions thank you for all 2005/4/27, Tom Lane <[EMAIL PROTECTED]>: > Mario Soto Cordones <[EMAIL PROTECTED]> writes: > > OK but views and tables for example have the same one relkind > > Not for many years now (certainly not in any release that has pg_namespace). > > regards, tom lane > -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] catalog of postgres
OK but views and tables for example have the same one relkind thank 2005/4/27, Alvaro Herrera <[EMAIL PROTECTED]>: > On Wed, Apr 27, 2005 at 02:02:09PM -0400, Mario Soto Cordones wrote: > > > with this query I obtain the schema name and the objects of this it , but > > like I can know that they are, that is to say if they are tables, > > views, functions, sequences, etc > > See pg_class.relkind. > > -- > Alvaro Herrera (<[EMAIL PROTECTED]>) > "El día que dejes de cambiar dejarás de vivir" > -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] catalog of postgres
Hi guys i have a following query: SELECT nspname as schema, relname as objeto FROM pg_class bc, pg_attribute ta, pg_namespace ns, pg_type ty WHERE ta.attrelid = bc.oid and ta.attnum > 0 and not ta.attisdropped and nspname <> 'information_schema' and nspname not like 'pg_%' and relam = 0 and bc.relnamespace = ns.oid and bc.relname not like 'pg_%' and ta.atttypid = ty.oid group by nspname, relname order by nspname, relname asc with this query I obtain the schema name and the objects of this it , but like I can know that they are, that is to say if they are tables, views, functions, sequences, etc thank for all -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] cache lookup failed for function 8044889
OK thank you for your help 2005/4/26, Oleg Bartunov : > On Tue, 26 Apr 2005, Mario Soto Cordones wrote: > > > Hi > > I migrate the database according to the procedure indicated in the > > documentation of 8.0.2 , but I have not read the documentation of the > > patch of the tsearch, but my others functions make in pl/pgsql make > > so you have two choices - if you have 7.4.5 still available then read > docs and try patch and you should get good dump, or reinstall tsearch2 > stuff. There are OIDs stored in tsearch2 config tables > > > for me work fine > > > > thank > > > > > > 2005/4/26, Oleg Bartunov : > >> How did you migrate to 8.0 ? > >> Have you read about regprocedure patch from > >> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ? > >> > >> Oleg > >> On Tue, 26 Apr 2005, Mario Soto Cordones wrote: > >> > >>> Hello list, there is migrate to postgreSQL 8.0. and I have begun to have > >>> some errors, before had the 7.4.5: > >>> For example I have the following function: > >>> > >>> CREATE OR REPLACE FUNCTION "public"."find_observaciones_activos" > >>> (integer, integer, text) RETURNS SETOF "public"."finddoc_t" AS > >>> $body$ > >>> select set_curcfg('default'); > >>> select co_empresa, co_filial, nu_activo_fijo,sq_serialcolumn, > >>> headline(tx_observaciones, q), > >>> rank(vector, q) > >>>from observaciones_activos, to_tsquery($3) as q > >>>where co_empresa = $1 and co_filial = $2 and > >>> vector @@ q order by rank(vector,q) desc > >>> $body$ > >>> LANGUAGE 'sql' STABLE CALLED ON NULL INPUT SECURITY INVOKER; > >>> > >>> and to execute this say > >>> > >>> cache lookup failed for function 8044889 > >>> > >>> CONTEXT: sentencia SQL: ??select lt.tokid, map.dict_name from > >>> public.pg_ts_cfgmap as map, public.pg_ts_cfg as cfg, > >>> public.token_type( $1 ) as lt where lt.alias = map.tok_alias and > >>> map.ts_name = cfg.ts_name and cfg.oid= $2 order by lt.tokid desc;?? > >>> funci??n SQL ??find_observaciones_activos?? en la sentencia 1 > >>> > >>> > >>> i drop all functions and I have recreated them again, but the problem > >>> persist, but with the 7.4.5 version all work fine... only functions > >>> alone the functions related with ltree or tsearch or spatial > >>> implementation don't work > >>> > >>> any idea please ? > >>> > >>> > >>> > >> > >> Regards, > >> Oleg > >> _____ > >> Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > >> Sternberg Astronomical Institute, Moscow University (Russia) > >> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > >> phone: +007(095)939-16-83, +007(095)939-23-83 > >> > > > > > > > > Regards, > Oleg > _ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [ADMIN] cache lookup failed for function 8044889
Hi I am trying to apply the following patches to solve my problem tsearch2_stat.patch.gz and regprocedure_7.4.patch.gz , but I don't understand that it is what it is necessary to make thank you 2005/4/26, Mario Soto Cordones <[EMAIL PROTECTED]>: > Hi > I migrate the database according to the procedure indicated in the > documentation of 8.0.2 , but I have not read the documentation of the > patch of the tsearch, but my others functions make in pl/pgsql make > for me work fine > > thank > > 2005/4/26, Oleg Bartunov : > > How did you migrate to 8.0 ? > > Have you read about regprocedure patch from > > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ? > > > > Oleg > > On Tue, 26 Apr 2005, Mario Soto Cordones wrote: > > > > > Hello list, there is migrate to postgreSQL 8.0. and I have begun to have > > > some errors, before had the 7.4.5: > > > For example I have the following function: > > > > > > CREATE OR REPLACE FUNCTION "public"."find_observaciones_activos" > > > (integer, integer, text) RETURNS SETOF "public"."finddoc_t" AS > > > $body$ > > > select set_curcfg('default'); > > > select co_empresa, co_filial, nu_activo_fijo,sq_serialcolumn, > > > headline(tx_observaciones, q), > > > rank(vector, q) > > >from observaciones_activos, to_tsquery($3) as q > > >where co_empresa = $1 and co_filial = $2 and > > > vector @@ q order by rank(vector,q) desc > > > $body$ > > > LANGUAGE 'sql' STABLE CALLED ON NULL INPUT SECURITY INVOKER; > > > > > > and to execute this say > > > > > > cache lookup failed for function 8044889 > > > > > > CONTEXT: sentencia SQL: ??select lt.tokid, map.dict_name from > > > public.pg_ts_cfgmap as map, public.pg_ts_cfg as cfg, > > > public.token_type( $1 ) as lt where lt.alias = map.tok_alias and > > > map.ts_name = cfg.ts_name and cfg.oid= $2 order by lt.tokid desc;?? > > > funci??n SQL ??find_observaciones_activos?? en la sentencia 1 > > > > > > > > > i drop all functions and I have recreated them again, but the problem > > > persist, but with the 7.4.5 version all work fine... only functions > > > alone the functions related with ltree or tsearch or spatial > > > implementation don't work > > > > > > any idea please ? > > > > > > > > > > > > > Regards, > > Oleg > > _ > > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > > Sternberg Astronomical Institute, Moscow University (Russia) > > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > > phone: +007(095)939-16-83, +007(095)939-23-83 > > > > -- > cordialmente, > > Ing. Mario Soto Cordones > -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] cache lookup failed for function 8044889
Hi I migrate the database according to the procedure indicated in the documentation of 8.0.2 , but I have not read the documentation of the patch of the tsearch, but my others functions make in pl/pgsql make for me work fine thank 2005/4/26, Oleg Bartunov : > How did you migrate to 8.0 ? > Have you read about regprocedure patch from > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ? > > Oleg > On Tue, 26 Apr 2005, Mario Soto Cordones wrote: > > > Hello list, there is migrate to postgreSQL 8.0. and I have begun to have > > some errors, before had the 7.4.5: > > For example I have the following function: > > > > CREATE OR REPLACE FUNCTION "public"."find_observaciones_activos" > > (integer, integer, text) RETURNS SETOF "public"."finddoc_t" AS > > $body$ > > select set_curcfg('default'); > > select co_empresa, co_filial, nu_activo_fijo,sq_serialcolumn, > > headline(tx_observaciones, q), > > rank(vector, q) > >from observaciones_activos, to_tsquery($3) as q > >where co_empresa = $1 and co_filial = $2 and > > vector @@ q order by rank(vector,q) desc > > $body$ > > LANGUAGE 'sql' STABLE CALLED ON NULL INPUT SECURITY INVOKER; > > > > and to execute this say > > > > cache lookup failed for function 8044889 > > > > CONTEXT: sentencia SQL: ??select lt.tokid, map.dict_name from > > public.pg_ts_cfgmap as map, public.pg_ts_cfg as cfg, > > public.token_type( $1 ) as lt where lt.alias = map.tok_alias and > > map.ts_name = cfg.ts_name and cfg.oid= $2 order by lt.tokid desc;?? > > funci??n SQL ??find_observaciones_activos?? en la sentencia 1 > > > > > > i drop all functions and I have recreated them again, but the problem > > persist, but with the 7.4.5 version all work fine... only functions > > alone the functions related with ltree or tsearch or spatial > > implementation don't work > > > > any idea please ? > > > > > > > > Regards, > Oleg > _____ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] cache lookup failed for function 8044889
Hello list, there is migrate to postgreSQL 8.0. and I have begun to have some errors, before had the 7.4.5: For example I have the following function: CREATE OR REPLACE FUNCTION "public"."find_observaciones_activos" (integer, integer, text) RETURNS SETOF "public"."finddoc_t" AS $body$ select set_curcfg('default'); select co_empresa, co_filial, nu_activo_fijo,sq_serialcolumn, headline(tx_observaciones, q), rank(vector, q) from observaciones_activos, to_tsquery($3) as q where co_empresa = $1 and co_filial = $2 and vector @@ q order by rank(vector,q) desc $body$ LANGUAGE 'sql' STABLE CALLED ON NULL INPUT SECURITY INVOKER; and to execute this say cache lookup failed for function 8044889 CONTEXT: sentencia SQL: «select lt.tokid, map.dict_name from public.pg_ts_cfgmap as map, public.pg_ts_cfg as cfg, public.token_type( $1 ) as lt where lt.alias = map.tok_alias and map.ts_name = cfg.ts_name and cfg.oid= $2 order by lt.tokid desc;» función SQL «find_observaciones_activos» en la sentencia 1 i drop all functions and I have recreated them again, but the problem persist, but with the 7.4.5 version all work fine... only functions alone the functions related with ltree or tsearch or spatial implementation don't work any idea please ? -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [ADMIN] PostgreSQL in FreeBSD jails
2005/4/26, Alexander Rusinov <[EMAIL PROTECTED]>: > Hi, > > I need to run a number of PostgreSQL servers in different FreeBSD jails. > I managed to run a first instance of PostgreSQL server in a jail, but > after I launch a new server in another jail the first one starts to > return an error messages like the following: > > semctl(1507328, 4, SETVAL, 0) failed: Invalid argument > > The problem in general is: only one instance of PostgreSQL server > normally processes clients' connections, all of the others return semctl > errors. > > The system is FreeBSD 5.4-PRERELEASE. SEM and SHM sysctl setting are: > > # sysctl -a | grep shm > kern.ipc.shmmax: 1 > kern.ipc.shmmin: 1 > kern.ipc.shmmni: 192 > kern.ipc.shmseg: 128 > kern.ipc.shmall: 32768 > kern.ipc.shm_use_phys: 0 > kern.ipc.shm_allow_removed: 0 > > # sysctl -a | grep sem > kern.ipc.semmap: 256 > kern.ipc.semmni: 256 > kern.ipc.semmns: 512 > kern.ipc.semmnu: 256 > kern.ipc.semmsl: 60 > kern.ipc.semopm: 100 > kern.ipc.semume: 10 > kern.ipc.semusz: 92 > kern.ipc.semvmx: 32767 > kern.ipc.semaem: 16384 > > Trying to solve the problem I've set the following in postgresql.conf files: > max_connections = 5 > shared_buffers = 100 > > Please help! What am I doing wrong? > > -- > Alexander Rusinov > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- cordialmente, Ing. Mario Soto Cordones ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq