Re: [ADMIN] SSL and md5 password?

2008-10-29 Thread Tom Lane
"Peter Koczan" <[EMAIL PROTECTED]> writes: > On Wed, Oct 29, 2008 at 9:11 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> Right. So in the meantime, what Peter should do is try the problem case >> after >> export PGSSLMODE=require >> so that he can see the error message that's relevant to his desired u

Re: [ADMIN] SSL and md5 password?

2008-10-29 Thread Peter Koczan
On Wed, Oct 29, 2008 at 1:49 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > According to this, you're trying to connect with SSL off, right? I > don't think you've got any matching lines for that in your > pg_hba.conf. But I could be reading that wrong. Well, psql is trying to connect with SSL o

Re: [ADMIN] SSL and md5 password?

2008-10-29 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > libpq tries to connect with SSL on and then falls back to SSL off. If > the latter fails, the error message from the first attempt has been > overwritten, and only the second one is logged. > This has been fixed by Magnus on CVS HEAD. Right. So in the

Re: [ADMIN] SSL and md5 password?

2008-10-29 Thread Alvaro Herrera
Scott Marlowe escribió: > On Wed, Oct 29, 2008 at 11:07 AM, Peter Koczan <[EMAIL PROTECTED]> wrote: > > And an md5 connection... > > > > $ /s/postgresql/bin/psql -h dumbo.cs.wisc.edu -p 5432 -U test_md5 > > koczan_test > > Password for user test_md5: > > psql: FATAL: no pg_hba.conf entry for hos

Re: [ADMIN] SSL and md5 password?

2008-10-29 Thread Scott Marlowe
On Wed, Oct 29, 2008 at 11:07 AM, Peter Koczan <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm looking to add an md5-based user to a postgres server, and I can't > seem to get psql to connect using SSL. Normally I use Kerberos to > connect, and that works flawlessly with SSL. I'd much prefer to use >

Re: [ADMIN] Recovering disk space...

2008-10-29 Thread Peter Koczan
On Fri, Oct 24, 2008 at 8:43 AM, Carol Walter <[EMAIL PROTECTED]> wrote: > I'm running on Solaris 10 and postgreSQL 8.2.10. > > Thanks, > Carol > > On Oct 24, 2008, at 7:47 AM, Helio Campos Mello de Andrade wrote: > >> On Thu, Oct 23, 2008 at 4:12 PM, Carol Walter <[EMAIL PROTECTED]> wrote: >>> >>>

Re: [ADMIN] SSL and md5 password?

2008-10-29 Thread Kevin Grittner
>>> "Kevin Grittner" <[EMAIL PROTECTED]> wrote: >> hostssl all postgres128.105.0.0/16 reject >> hostssl all postgres198.133.224.0/24 reject > I think it uses the first matching entry in pg_hba.conf. > What happens with the matching "reject" line? Never mind. Some

Re: [ADMIN] SSL and md5 password?

2008-10-29 Thread Kevin Grittner
>>> "Peter Koczan" <[EMAIL PROTECTED]> wrote: > psql: FATAL: no pg_hba.conf entry for host "128.105.162.36", user > "test_md5", database "koczan_test", SSL off > hostssl all postgres128.105.0.0/16 reject > hostssl all postgres198.133.224.0/24 reject > > # Testing

[ADMIN] SSL and md5 password?

2008-10-29 Thread Peter Koczan
Hi all, I'm looking to add an md5-based user to a postgres server, and I can't seem to get psql to connect using SSL. Normally I use Kerberos to connect, and that works flawlessly with SSL. I'd much prefer to use SSL connections, so I'm wondering if there's something I'm doing wrong. Here's what

Re: [ADMIN] drop role fails

2008-10-29 Thread Alvaro Herrera
Marc Fromm wrote: > I need to drop a role/user but receive the message: > ERROR: role "ken" cannot be dropped because some objects depend on it > DETAIL: 1 objects in database css > 1 objects in database manuals > 1 objects in database cswe2 > > I checked the databases listed and the user/role k

[ADMIN] drop role fails

2008-10-29 Thread Marc Fromm
I need to drop a role/user but receive the message: ERROR: role "ken" cannot be dropped because some objects depend on it DETAIL: 1 objects in database css 1 objects in database manuals 1 objects in database cswe2 I checked the databases listed and the user/role ken is not associated with any i