[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

[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 to

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

Thanks, i'll investigate on it. Francesco >Messaggio originale >Da: ring...@ringerc.id.au >Data: 18/06/2012 10.20 >A: "francescobocca...@libero.it" >Cc: >Ogg: Re: [ADMIN] CEST ERROR: cursor "ogrpglayerreaderx" does not exis

[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] Run external program from postgresql

2012/5/17 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, it is. But you'll have to use an

[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 c

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

Thanks, I solved it with your help. Francesco Boccacci >Messaggio originale >Da: m...@joeconway.com >Data: 02/08/2011 22.46 >A: "francescobocca...@libero.it" >Cc: >Ogg: Re: [ADMIN] dblink question about duplicate connection > >On 08/02/2011 05:36 AM,

[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 dblink_exec(

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: >Ogg: [ADMIN] Too many IDLE in current_query > >Dear

[ADMIN] Too many IDLE in current_query

Dear all, i'm checking my postgresql server to try to monitoring all activity that are running. i run this query: postgres=# select current_timestamp - query_start as runtime, current_query from pg_stat_activity order by 1 desc; and the resul is many rows like this: runtime |

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

ok, i'm going to try the Scott's suggestion, but as soon as possible i'll install Ubuntu 10.04LTS version. Thanks, Francesco Boccacci >Messaggio originale >Da: scrawf...@pinpointresearch.com >Data: 07/07/2011 17.54 >A: "francescobocca...@libero.it" &

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

scrawf...@pinpointresearch.com >Data: 07/07/2011 16.49 >A: "francescobocca...@libero.it" >Cc: >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

[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 packag

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: >Cc: , >Ogg: Re: R: Re: [ADMIN] adminpack installation problem > > Dear Francesco, > > On Thu, 7 Jul 2011 10:29:10 +0200 (CEST), "fra

R: Re: [ADMIN] adminpack installation problem

eers > > >-Original Message----- >From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-owner@postgresql. org] On Behalf Of francescobocca...@libero.it >Sent: 06 July 2011 09:20 >To: pgsql-admin@postgresql.org >Subject: [ADMIN] adminpack installation problem > >D

R: Re: [ADMIN] adminpack installation problem

>-Original Message- >From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-owner@postgresql. org] On Behalf Of francescobocca...@libero.it >Sent: 06 July 2011 09:20 >To: pgsql-admin@postgresql.org >Subject: [ADMIN] adminpack installation problem > >Dear all, >i

[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 serve

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

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

[ADMIN] Import image into postgresql database

Dear all, i have a question for you: I would like to store images (jpg) into a table of postgresql database. My question is : what is the corret type of tables filed that i have to use? Reading some forum of article in the net there are two ways: bytea or oid type. Whati is the best type to sto