[ADMIN] PgAgent logging verbosity

2007-03-13 Thread Ezequias Rodrigues da Rocha
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/ use

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

2007-02-28 Thread Ezequias Rodrigues da Rocha
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still

[ADMIN] Debug (is it PostgreSQL?)

2007-02-16 Thread Ezequias Rodrigues da Rocha
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:

[ADMIN] Deadlock on transaction

2007-02-12 Thread Ezequias Rodrigues da Rocha
with it ? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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] Deadlock on transaction

2007-02-12 Thread Ezequias Rodrigues da Rocha
) 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://ezequiasrocha.blogspot.com/

Re: [SQL] [ADMIN] Deadlock on transaction

2007-02-12 Thread Ezequias Rodrigues da Rocha
2007/2/12, Richard Huxton dev@archonet.com: 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: [SQL] [ADMIN] Deadlock on transaction

2007-02-12 Thread Ezequias Rodrigues da Rocha
da Rocha wrote: 2007/2/12, Richard Huxton dev@archonet.com: 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

Re: [ADMIN] Password Policy

2007-02-10 Thread Ezequias Rodrigues da Rocha
Hi list (my first post), Is there any password polity that postgresql implement ? It is possible to put a set all no administrators passwords to = '123456' from times and times ? Has anyone implement a dinamic password autentication (the password changes according the date/month etc of a day