[ADMIN] SSL SYSCALL error: EOF detected

Hi all, i have a problem while trying to delete rows from a table: I received: SSL SYSCALL error: EOF detected How can i fix this problem? -Postgresql version 9.1 -O.S Ubuntu Server 11.04 Thanks Francesco -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

[ADMIN] autovacuum: found orphan temp

Hi all, in postgresql log file i found a lots of rows like: autovacuum: found orphan temp table pg_temp_32.test11 in database Test I tried to select this table: select * from pg_temp_32.test11 but i received the follow error: ERROR: could not open file base/16385/t32_13288115: No such file

[ADMIN] CEST ERROR: cursor ogrpglayerreaderxxxxxxxxx does not exist

Hi all, i found a lots of ERROR into my postgresql log file as follow: 2012-06-10 23:37:17 CEST ERROR: cursor ogrpglayerreader073a8d30 does not exist 2012-06-10 23:37:17 CEST STATEMENT: CLOSE OGRPGLayerReader073A8D30 2012-06-10 23:37:23 CEST ERROR: cursor ogrpglayerreader073a8e78 does not

R: Re: [ADMIN] CEST ERROR: cursor ogrpglayerreaderxxxxxxxxx does not exist

not exist On 06/18/2012 04:12 PM, francescobocca...@libero.it wrote: Hi all, i found a lots of ERROR into my postgresql log file as follow: 2012-06-10 23:37:17 CEST ERROR: cursor ogrpglayerreader073a8d30 does not exist 2012-06-10 23:37:17 CEST STATEMENT: CLOSE OGRPGLayerReader073A8D30 2012-06-10

[ADMIN] Run external program from postgresql

Hi all, i have a question. I'd like to create a trigger function that call and external application (es . C:\myprogram.exe) when a new row will be insert in a table. Is it possible? How can do that? Thanks Francesco -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make

R: Re: [ADMIN] Run external program from postgresql

postgresql 2012/5/17 francescobocca...@libero.it francescobocca...@libero.it Hi all, i have a question. I'd like to create a trigger function that call and external application (es . C:\myprogram.exe) when a new row will be insert in a table. Is it possible? How can do that? Yes

R: Re: [ADMIN] dblink question about duplicate connection

:36 AM, francescobocca...@libero.it wrote: Somentimes happend that an error accours in insert data and when i try to run new insert posgresql return and error like duplicate connection. I would like to change my functions in this way: If 'conn_test' exist PERFORM dblink_disconnect

[ADMIN] dblink question about duplicate connection

Dear all, i have a question about dblink connection.I use it in a trigger function : CREATE OR REPLACE FUNCTION setuser() RETURNS trigger AS $BODY$ DECLARE BEGIN IF (TG_OP = 'INSERT') THEN PERFORM dblink_connect('conn_test', 'dbname=database_test'); PERFORM

R: [ADMIN] Too many IDLE in current_query

Hi, i add another question to my previous mail.. why all the rows of my query have waiting field false? Thanks Francesco Messaggio originale Da: francescobocca...@libero.it Data: 12/07/2011 17.38 A: pgsql-admin@postgresql.org Ogg: [ADMIN] Too many IDLE in current_query Dear all, i'm

R: Re: [ADMIN] adminpack installation problem

? Thanks Francesco Boccacci Messaggio originale Da: fren...@cromwell.co.uk Data: 06/07/2011 13.29 A: francescobocca...@libero.it, pgsql-admin@postgresql.org Ogg: Re: [ADMIN] adminpack installation problem Hi You need to ensure you install into the database you specified as your maintenance

R: Re: R: Re: [ADMIN] adminpack installation problem

Thanks, Francesco Boccacci Messaggio originale Da: gabriele.bartol...@2ndquadrant.it Data: 07/07/2011 10.34 A: francescobocca...@libero.it Cc: fren...@cromwell.co.uk, pgsql-admin@postgresql.org Ogg: Re: R: Re: [ADMIN] adminpack installation problem Dear Francesco, On Thu, 7 Jul 2011

[ADMIN] Install postgreSQL 9.0 in Linux Ubuntu 9.10

Dear all, i tried to install postgresql 9.0 in my Linux Ubuntu 9.10. I follow these steps that i found in: http://www.russbrooks.com/2010/12/4/install-postgresql-9-on-ubuntu-linux I know that : Tested on: Ubuntu 10.04 I received this error: $ sudo apt-get install postgresql-9.0 Reading

R: Re: [ADMIN] Install postgreSQL 9.0 in Linux Ubuntu 9.10

...@pinpointresearch.com Data: 07/07/2011 16.49 A: francescobocca...@libero.itfrancescobocca...@libero.it Cc: pgsql-admin@postgresql.org Ogg: Re: [ADMIN] Install postgreSQL 9.0 in Linux Ubuntu 9.10 On 07/07/2011 02:04 AM, francescobocca...@libero.it wrote: Dear all, i tried to install postgresql 9.0

R: Re: R: Re: [ADMIN] Install postgreSQL 9.0 in Linux Ubuntu 9.10

@postgresql.org Ogg: Re: R: Re: [ADMIN] Install postgreSQL 9.0 in Linux Ubuntu 9.10 On 07/07/2011 08:29 AM, francescobocca...@libero.it wrote: Hi, i tried to run : /postgresql-9.0.4-1-linux.bin but i received segmentation fault error. So i think, after Steve reply, that the best way

[ADMIN] adminpack installation problem

Dear all, i have a question for you. I'd like to install adminpack functionality to my pgadminIII. I use pgaminIII v1.10 and with it i connect to my server where i installed a cluster of database. I read some documentations but i don't understand how can install the package. I found in my

R: Re: [ADMIN] adminpack installation problem

Thanks Francesco Boccacci Messaggio originale Da: fren...@cromwell.co.uk Data: 06/07/2011 13.29 A: francescobocca...@libero.it, pgsql-admin@postgresql.org Ogg: Re: [ADMIN] adminpack installation problem Hi You need to ensure you install into the database you specified as your

R: Re: [ADMIN] Import image into postgresql database

Thanks, Francesco Messaggio originale Da: gabriele.bartol...@2ndquadrant.it Data: 01/07/2011 12.27 A: francescobocca...@libero.it Cc: pgsql-admin@postgresql.org Ogg: Re: [ADMIN] Import image into postgresql database Ciao Francesco, On Fri, 1 Jul 2011 12:13:33 +0200 (CEST