Re: [ADMIN] no verification of client certificate?

2007-03-26 Thread Ray Stell
Thanks, I'll see if I can test that this morning. A minor suggestion, perhaps said config or perhaps a reference to the Chapter 29. libpq - C Library could be added to the section on ssl: http://www.postgresql.org/docs/8.2/interactive/ssl-tcp.html If you don't mind, how do you use ssldump to

Re: [ADMIN] no verification of client certificate?

2007-03-26 Thread Ray Stell
On Mon, Mar 26, 2007 at 12:04:21AM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > On Sun, Mar 25, 2007 at 10:01:20PM -0400, Tom Lane wrote: > >> I looked more closely and you are right: if the server does not have > >> a root.crt file then it doesn't send its server cert to t

Re: [ADMIN] no verification of client certificate?

2007-03-26 Thread Michael Fuhr
On Mon, Mar 26, 2007 at 09:03:53AM -0400, Ray Stell wrote: > If you don't mind, how do you use ssldump to trace a psql setup? I usually capture the connection to a file with tcpdump and then use ssldump to read the file. Sometimes I use wireshark (formerly ethereal) but it's a bit heavyweight for

Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP

2007-03-26 Thread Daniel Ricardo Medina
After delete all, postgres said no exist the user id 1... The version is 7.4.8 Daniel Ricardo Medina Ing. de Desarrollo Computec S.A. Tel 260 71 11 Ext 1640 -Mensaje original- De: Tom Lane [mailto:[EMAIL PROTECTED] Enviado el: Sunday, March 25, 2007 1:52 PM Para: Daniel Ricardo Medi

Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP

2007-03-26 Thread Tom Lane
"Daniel Ricardo Medina" <[EMAIL PROTECTED]> writes: > After delete all, postgres said no exist the user id 1... Maybe reindexing pg_shadow would help. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our l

Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP

2007-03-26 Thread Daniel Ricardo Medina
ok thank, in single mode i try to erase two unique index on pg_shadow but postgres show this messages this index is used by system postgres... can´t erase it Daniel Ricardo Medina Ing. de Desarrollo Computec S.A. Tel 260 71 11 Ext 1640 De: Peter Ko

Re: [ADMIN] no verification of client certificate?

2007-03-26 Thread Michael Fuhr
On Mon, Mar 26, 2007 at 09:35:33AM -0400, Ray Stell wrote: > Knowing how Michael traced the connection with ssldump would be > VERY helpful. The simple way is to run ssldump in one shell while running psql in another: ssldump -q port 5482# my 8.2.3 db listens on port 5482 If I want to do mor

[ADMIN] Problems with precompiled pgsql on mac

2007-03-26 Thread Peter Elmers
Hi Guys! I am trying to deploy an application together with postgresql. Therefore, i compiled postgres versions on Intel, G4 and G5. Mostly, this works perfectly. But on some machines, the installation was successful and postgres does not start. PostGres does not write any log. If i try to

[ADMIN] autovacuum question

2007-03-26 Thread Laszlo Nagy
Hello, I had a problem in my computer system yesterday. Some data has disappeared. I was looking for a program that might have deleted it accidentally. Before I found anything, the data suddenly came back. I thought it must be a transaction id wraparound problem. The system is running on F

Re: [ADMIN] Problems with precompiled pgsql on mac

2007-03-26 Thread Shane Ambler
Peter Elmers wrote: Hi Guys! A bit more info would help - I am trying to deploy an application together with postgresql. Therefore, i compiled postgres versions on Intel, G4 and G5. Mostly, this works perfectly. But on some machines, the installation was successful and postgres does not star

Re: [ADMIN] autovacuum question

2007-03-26 Thread Jim Nasby
Autovacuum doesn't launch a separate daemon; you'll only see an autovac process when an autovac is actually working. Also, 8.1 has code to prevent wraparound, so that's not it (see backend/access/transam/varsup.c) On Mar 27, 2007, at 5:17 AM, Laszlo Nagy wrote: Hello, I had a problem i

[ADMIN] data from system tables.

2007-03-26 Thread Carol Walter
Hello, We recently began giving our users a ten connection limit. The are some accounts that have no limit. Some of these should have no limit because they're system accounts, but others are just users that were created before we started the limit. Is there a psql command that I can ru

Re: [ADMIN] data from system tables.

2007-03-26 Thread Tom Lane
Carol Walter <[EMAIL PROTECTED]> writes: > We recently began giving our users a ten connection limit. The are > some accounts that have no limit. Some of these should have no limit > because they're system accounts, but others are just users that were > created before we started the limit.

Re: [ADMIN] data from system tables.

2007-03-26 Thread Michael Fuhr
On Mon, Mar 26, 2007 at 04:45:01PM -0400, Carol Walter wrote: > We recently began giving our users a ten connection limit. The are > some accounts that have no limit. Some of these should have no limit > because they're system accounts, but others are just users that were > created before w

Re: [ADMIN] [GENERAL] ERROR: out of shared memory

2007-03-26 Thread Tom Lane
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes: >I have to manage an application written in java which call another module > written in java which uses Postgre DBMS in a Linux environment. I'm new to > Postgres. The problem is that for large amounts of data the application > throws an: > org.p

Re: [ADMIN] RPMs for RedHat 5 Enterprise?

2007-03-26 Thread Devrim GÜNDÜZ
Hi, On Wed, 2007-03-21 at 18:22 +0200, Devrim GÜNDÜZ wrote: > On Wed, 2007-03-21 at 07:33 -0700, Benjamin Arai wrote: > > When and are rpms going to be released for RedHat 5? > > Probably on Monday. I will have the isos on Sunday. Ok, I pushed 8.2.3 RPMs for RHEL5 a few minutes before. It will

Re: [ADMIN] Problems with precompiled pgsql on mac

2007-03-26 Thread Peter Elmers
Hi Shane, Peter Elmers wrote: Hi Guys! A bit more info would help - I am trying to deploy an application together with postgresql. Therefore, i compiled postgres versions on Intel, G4 and G5. Mostly, this works perfectly. But on some machines, the installation was successful and postgre