SOLVED: [GENERAL] Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3

I changed it to on, and everything works well with SELinux enabled by default. Thanks again for the time and patience. On 24/05/15 19:43, Adrian Klaver wrote: On 05/24/2015 04:15 PM, Marcos Ortiz wrote: Sorry for the late response. Not sure if it applies but see here: http://neo4j.c

Re: [GENERAL] Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3

Sorry for the late response. On 23/05/15 19:38, Adrian Klaver wrote: On 05/23/2015 04:16 PM, Marcos Ortiz wrote: On 23/05/15 19:09, Adrian Klaver wrote: On 05/23/2015 03:51 PM, Marcos Ortiz wrote: On 23/05/15 18:40, Adrian Klaver wrote: On 05/23/2015 03:27 PM, Marcos Ortiz wrote

Re: [GENERAL] Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3

On 23/05/15 19:09, Adrian Klaver wrote: On 05/23/2015 03:51 PM, Marcos Ortiz wrote: On 23/05/15 18:40, Adrian Klaver wrote: On 05/23/2015 03:27 PM, Marcos Ortiz wrote: Regards to all the list. First all the info about the system: O.S: CentOS 7 64 bits PostgreSQL version: SELECT version

Re: [GENERAL] Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3

On 23/05/15 18:40, Adrian Klaver wrote: On 05/23/2015 03:27 PM, Marcos Ortiz wrote: Regards to all the list. First all the info about the system: O.S: CentOS 7 64 bits PostgreSQL version: SELECT version(); version

Re: [GENERAL] Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3

On 23/05/15 18:38, Tom Lane wrote: Marcos Ortiz writes: O.S: CentOS 7 64 bits We are working here to integrate PostgreSQL with Neo4j through PL/Python using the py2neo module for it, and when we want to send sentences to Neo4j using port 7474, the executed code raises a SocketError [Errno 13

[GENERAL] Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3

Regards to all the list. First all the info about the system: O.S: CentOS 7 64 bits PostgreSQL version: SELECT version(); version -- PostgreSQL 9.2.7 on x86_64-redhat-linux-gnu, compiled

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

so i fix it and got it working !!! i followed the best practices of doing the dump with the newest pg_dump version. and now is working thanks everyone for your help -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827821.html Sent fr

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

yes i'd better look at the postgis list.. i thought for one moment that this was encoding related. thanks for your help -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827760.html Sent from the PostgreSQL - general mailing list archi

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

i found this in the file... ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or directory which acording to the firs link I found , is a postgis

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

to answer to Adrian 1) i am using the old version to dump (i will try with the latest) 2) no the postgis version is different. pg9.2.4-> postgis-2.0.3 and pg9.3.5-> postgis-2.1.3 3) the schema is public \d+ al_shared_place Table "pu

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

i did it again... and the file shows exactly the same lots of : invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-no

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

might be awkard but there is no file, so i assume 2 things: 1) there was no upgrade errors 2) the script + command is not writing to stderr (i think it is doing it) -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827739.html Sent

[GENERAL] pgdump (9.2.4) not dumping all tables

hello im trying to dump a complete DB, i've been doing something like this. (i'm in the process of upgrading from 9.2.4 to 9.3.5) my current DB looks like this: Name| Owner | Encoding | Collate | Ctype | Access privileges ---+--+---+-+---

[GENERAL] using trigger to change status in one table from the modification in other table

Hello guys, i'm trying to use trigger in these two tables below, in order to do the following; To cancel the booking of an accommodation, since the customer do the host (status = "Cancelled") in the book_rooms table. Changing the state of accommodation to "occupied" (Accommodation Table). CREATE

[GENERAL] using trigger to change statusin one table from the modification in other table

Hello guys, i'm trying to use trigger in these two tables below, in order to do the following; To cancel the booking of an accommodation, since the customer do the host (status = "Cancelled") in the book_rooms table. Changing the state of accommodation to "occupied" (Accommodation Table). CREAT

Re: [GENERAL] function on trigger

On Aug 31, 7:39 pm, Marcos Hercules Santos wrote: > hi guys > > I'm newbie in Psql and I'm trying to build one function  in order to > count the products for each supplier. So i'm gonna put it quite simply > though this example > > Please, consider a table ca

[GENERAL] function on trigger

hi guys I'm newbie in Psql and I'm trying to build one function in order to count the products for each supplier. So i'm gonna put it quite simply though this example Please, consider a table called books with the following fields bookid, title, price, idPublisher and one another table call

Re: [GENERAL] default grant

n “col1”, update on “col2” in table “mytable” to “role2” • GRANT SELECT, UPDATE(col3) ON mytable TO role3; – Grants select on the table, and update on “col3” for “mytable” to “role3” My advice is that you have to see that presentation. Regards, -- ---

Re: [PERFORM] [GENERAL] PostgreSQL - case studies

ara ser realmente grande, hay que estar con la gente, no por encima de ella." Montesquieu Ing. Marcos Luís Ortíz Valmaseda PostgreSQL System DBA&& DWH -- BI Apprentice Centro de Tecnologías de Almacenamiento y Análisi

Re: [PERFORM] [GENERAL] Strange performance degradation

Lorenzo Allegrucci escribió: Matthew Wakeling wrote: On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote: Anyway, how can I get rid those "idle in transaction" processes? Can I just kill -15 them or is there a less drastic way to do it? Are you crazy? Sure, if you want to destroy all of the changes

[GENERAL] PL-Debugger installation problem

ource code. how can i instal this utility without the source code? ps. i'm not a Linux expert nor a DBA, im an application developer! tks, Marcos Davi Reis

[GENERAL] Debugger install

ource code. how can i do to instal this utility without the source code? ps. i'm not an Linux expert nor a DBA, im an application developer! Tks Marcos Davi Reis

[GENERAL] [HACKERS] exit

I would like to leave the list ...  -- Acelerador POP Acelere a sua conexão discada em até 19 x. Use o Acelerador POP. É grátis, pegue já o seu. http://www.pop.com.br/acelerador

Re: [GENERAL] Turn OFF Stats of Postgresql

Hi Ycrux Thank very much for your help. Marcos Em Ter, 2006-03-14 às 21:28 +0100, Ycrux escreveu: > Ho Marcos! > You can also try to adpat this parameters to your config: > > TUNING: > * First, see: > http://www.lyris.com/lm_help/6.0/tuning_postgresql.html >

[GENERAL] Turn OFF Stats of Postgresql

Hi, I have a search engine and for increase the performance I want to turn off the stats of Postgresql but i don't know if i should do it. Should I make this? Thanks. Marcos ---(end of broadcast)--- TIP 3: Have you checked our extensiv

Re: [GENERAL] Take advantage of PREPARE (Pool of Conections)

> It's called pgpool. I've installed it in my computer, that's o.k. Now, how do I to know if it's working with Postgresql? Thanks :o) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-n

[GENERAL] Take advantage of PREPARE (Pool of Conections)

ed by PREPARE only exists while the connection is opened. This means, if each visitor of the website opens and closes the connection, PREPARE is useless. I need the connection pool for POSTGRESQL for Linux, but i don't know how to do this. Thanks in advance

[GENERAL] Tsearch 2

Hi, How the tsearch2 work? I can use it in my project that is language Português (Brasil)? Thanks. Marcos. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [GENERAL] What is made a mistake with SP?

ulado" não existe In english I think that it means ERROR: type "tipo_compras_calculado" not exists. This is my problem with this SP... Marcos. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] What is made a mistake with SP?

Hi, I need create SP that returns cursos so that I can work with them. I have many SQLs used for search records in database, then I will make SP to return the results. The example that I'm trying is: CREATE OR REPLACE FUNCTION fun_compras_calculado() RETURNS SETOF tipo_compras_calculado AS ' DE

Re: [GENERAL] Create Produre for DROP row

treated by me it's raised. My database is in UTF8 encoding. What's happen? E.g: EXCEPTION WHEN others THEN RETURN 'Error'; Marcos. ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Encoding Problem

Hi. I'm receiving this error message: invalid UTF-8 byte sequence detected SET search_path TO administracao,public; CREATE OR REPLACE FUNCTION inserirTela(text,text,text) RETURNS text AS ' DECLARE sName ALIAS FOR $1; sDesc ALIAS FOR $2; cSist ALIAS FOR $3; BEGIN

[GENERAL] Concept about stored procedures

Hi, I'm developing one application using this wonderful Database, and I've like of use the concepts correctly. Then, i decided that all my SQL statements will be in database using the procedure language (plpgsql or plpython), I go create functions for all interactions in database, and use in the

[GENERAL] Create Produre for DROP row

Hi, Does have possible create one procedure to delete a row that return TRUE if the deletion was success or FALSE if a error occur? The procedure for deletion I already create but I don't know how detect if the deletion was success executed. Languagel: plpgsql Thanks.

[GENERAL] Create one prepared function

lt is little direct and many dispersed. Very Thanks!! -- __ Marcos José Setim [EMAIL PROTECTED] http://www.linuxhard.org ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subs

[GENERAL] Performance Low Using the Prepare and Execute

, __LINE__, __FILE__ ); Teste3 Code: $sSQL = 'INSERT INTO teste (nome) VALUES(\'teste2...\')'; for ( $i = 0; $i < $iNTestes; $i++ ) $bOk = $oDB->execute_query( $sSQL, __LINE__, __FILE__ ); The SQL that they use the Prepare and Execute would

Re: [GENERAL] [ANNOUNCE] 8.1 Beta 3: The Final Beta?

Please unsubscribe my e-mail [EMAIL PROTECTED] thank you --- "Marc G. Fournier" <[EMAIL PROTECTED]> escreveu: > > Like all of our beta periods, this one has been > going smoothly ... but, > unlike other ones, we're seeing most bugs found very > early in the cycle, > so right now its look

[GENERAL] create user

user and i did it. how can i prevent this option? best regards, marcos [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] showing X fields from X total

in advance, marcos -- m a r c o s @ i v a l . e s

[GENERAL] exporting table to txt

hi, i would like to make some changes in the configuration of the fields from a table so my first doubt is concerning to keep the info safe. how can i export data from my table into a text file separated with tabs? thanks in advance, marcos -- m a r c o s @ i v a l . e s

[GENERAL] Apache+Postgresql (mod_auth_pgsql)

ion) Perhaps could be a script to write into the database. ?¿? Thirdly, Any suggestions will be pleased, thanks in advance, marcos [EMAIL PROTECTED]

[GENERAL] auto increment

har(90), primary key(codigo)); EOF how can i do it? thanks in advance, marcos -- m a r c o s @ i v a l . e s

[GENERAL] NullPointerException [MORE]

hi, it occurss me with each field of the database. i have txt file. i make a database and put it into posgres. maybe it is a mistake in the in the txt file. marcos [EMAIL PROTECTED]

[GENERAL] NullPointerException

in advance, marcos [EMAIL PROTECTED]

[GENERAL] Disable the more command

Hi, Can someone tell me how can I disable the more command at the end of any one page display in PostgreSQL 7.0 ? I simply don't want to be asked to press a key to continue displaying the result of a query. Thanks a lot! Marcos C

[GENERAL] NOTICE: DateStyle is Postgres with Eropean convention

hi list, i have restart postgresql with postmaster -i -o -e & and every time the servlets (via web) are accesing to posgres database it shows, in the shell, this: NOTICE: DateStyle is Postgres with European conventions thanks marcos [EMAIL PROTECTED]

[GENERAL] DateStyle is Postgres with US (NonEuropean) conventions

pean) conventions NOTICE: DateStyle is Postgres with US (NonEuropean) conventions and continuos. does anyone know how can start postgres to prevent from this? thanks. marcos [EMAIL PROTECTED]

[GENERAL] Cursor Problems

ion ? Thanks a lot! Marcos Castro email: [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE prints! http://photos.yahoo.com

[GENERAL] existing but not-existing database.

ERROR: createdb: database 'todojamon' already exists ERROR: createdb: database 'todojamon' already exists how can i delete todojamon database?? thanks in advance. marcos [EMAIL PROTECTED]

[GENERAL] troubles installing postgresql6.4

/base/template1 what should i do thanks in advance, marcos [EMAIL PROTECTED]

[GENERAL] Questions about CURSORS

Hi, Suppose there is a table that's being shared among 5 computers at the same time. Suppose I've created a CURSOR for a SELECT * FROM GROUP BY . Suppose I have fetched the 3rd record and am going to fetch the 4th and in the meantime someone at another computer just DELETED that 4th recor

[GENERAL] Limits on PostgreSQL

records'contents using FETCH FORWARD, for example?) 2 - When one uses a CURSOR for a SELECT is there a big memory consumption or there is a memory buffer limit and beyond that the result is written to a file (virtual memory) and read from there when needed? Marcos Castro email: [EMAIL PROT

[GENERAL] Queries using the C API

e software developed using the Postgresql C API? If so, where can I find them? Thanks a lot for any help on this matter. Marcos Barreto de Castro email: [EMAIL PROTECTED] phone: +55 61 3498747 fax..: +55 61 3498747 __ Do You Yahoo!? Send instant mess