[ADMIN] PgAgent logging verbosity

Hi list, I would like to know if I set the debug mode to 2 (-l 2) in the pgAgent connection string it could spend much cpu processing. I have other things running in the server and I don't like to create problem to others. -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com

[ADMIN] Installing with libs of postgresql-libs

postgresql-libs-8.2.3-1PGDG.i686.rpm but I do not have the adm permissions. Any help would be glad Ezequias ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Disconnecting non active (IDLE ) users

I would like to know how postgresql defines that a connection is inactive. I have the same problem but in the future I couldn't restart my server every day. Any explanation ? Ezequias 2007/2/26, Goran Rakic <[EMAIL PROTECTED]>: I have installed POSTGRESQL 8.2 on W2K3 32bit

[ADMIN] Debug (is it PostgreSQL?)

My Linux is reporting the following message: DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping... DEBUG: Clearing inactive connections DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping

Re: [SQL] [ADMIN] Deadlock on transaction

Insert into base.bilhete (id, estado, uso_sequencia, promocao_documento, assento_id, cartao_id, ingresso_id, promocao_id, sessao_id, vendedor_venda_id )')); dm.qQ1.SQL.add(Concat('values(', BilheteID, ',' , QuotedStr(EstadoID), ',' , '0,0', 

Re: [SQL] [ADMIN] Deadlock on transaction

2007/2/12, Richard Huxton : Ezequias Rodrigues da Rocha wrote: > I mean really deadlock. Other transactions can't access the database until > the main transaction is complete. A question: > > PostgreSQL doesn't permit multiple transactions concurrently ? PG has quite good

Re: [ADMIN] Deadlock on transaction

I mean really deadlock. Other transactions can't access the database until the main transaction is complete. A question: PostgreSQL doesn't permit multiple transactions concurrently ? Ezequias 2007/2/12, Scott Marlowe <[EMAIL PROTECTED]>: On Mon, 2007-02-12 at 11:43, Ezequ

[ADMIN] Deadlock on transaction

? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http

Re: [ADMIN] Password Policy

c of a day ) ? Is there any function to encript, decript plain text in PostgreSQL and if it is aplicable ? Regards ... Ezequias