Re: FW: [GENERAL] postgres kerberos how to

2006-12-20 Thread Derrick Stensrud
, however. Good luck! garner *From:* Derrick Stensrud [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, December 20, 2006 10:36 AM *To:* Garner Chung *Cc:* pgsql-general@postgresql.org *Subject:* Re: FW: [GENERAL] postgres kerberos

Re: FW: [GENERAL] postgres kerberos how to

2006-12-20 Thread Derrick Stensrud
u. garner -Original Message- From: Garner Chung Sent: Wednesday, December 20, 2006 10:10 AM To: 'pgsql-general@postgresql.org' Cc: 'Derrick Stensrud ' Subject: RE: [GENERAL] postgres kerberos how to Hey Derrick, I work with Matt, and I was involved in our Kerber

Re: [GENERAL] postgres kerberos how to

2006-12-20 Thread Derrick Stensrud
b on the linux box, and I edit my krb5.conf file to resemble yours listed. Is there anything else that has to be done on the Windows or linux side? - When using postgres kerberos support, do you have to have a local unix user account? Derrick Stensrud wrote: Thanks, I'm going to go ahead

Re: [GENERAL] postgres kerberos how to

2006-12-20 Thread Derrick Stensrud
Thanks, I'm going to go ahead and try to implement postgresql kerberos against active directory 2003 today. I read a bit about it last night and have a few questions. You wrote: " * Map PG on database server as a user in Active Directory o Create user account in AD for PG service

Re: [GENERAL] Anyone? Best way to authenticate postgres against

2006-12-19 Thread Derrick Stensrud
Is anyone successfully using pam_ldap with postgres to authenticate database users? I've read a million how to docs but I've hit a road block. Magnus Hagander wrote: Stephen Frost wrote: * John McCawley ([EMAIL PROTECTED]) wrote: (I am working on this project with Derrick.) We have to

Re: [GENERAL] Anyone? Best way to authenticate postgres against

2006-12-19 Thread Derrick Stensrud
Thanks I've been trying to use pam_ldap but I keep getting this error from postgres. I think it may have something to do with postgres running as the postgres user and not having permissions to something, but I have no idea what. LOG: pam_authenticate failed: Conversation error FATAL: PAM

[GENERAL] pam ldap postgres troubles cannot get postgres to auth via ldap

2006-12-18 Thread Derrick Stensrud
I've been beating my head it trying to understand what is going on here. I'm trying to setup postgresql to authenticate using pam_ldap against a windows 2003 Active Directory server. I have setup accounts on the Active directory and tested the authentication against it using services like loc

[GENERAL] best way to setup raid array in this situation

2006-12-01 Thread Derrick Stensrud
We have a server with 6 32GB SCSI drives and we are thinking about setting up 4 drives in RAID 10 for the database itself and using the other 2 drives in RAID 1 for the WAL and OS. Is this a good idea or can anyone think of a better idea other than this? Thanks. ---(e