Re: [ADMIN] complie postgresql with kerberos in centos

2009-07-22 Thread rahimeh khodadadi
I already installed krb5-devel-1.6.1-31.el5_3.3, e2fsprogs-devel-1.39-20.el5, openssl-devel-0.9.8e-7.el5, But it is not compiled. Please help Thanks On Wed, Jul 22, 2009 at 6:35 PM, Tom Lane wrote: > rahimeh khodadadi writes: > > I have problem in compiling of postgresql with krb5 in CentOS; >

[ADMIN] General queries regarding backup

2009-07-22 Thread Deepak Bala
Hi everyone, I have some queries regarding the PITR backup procedure on Postgres 8.3. Here are the steps I follow for backup 1. I set up WAL archiving and checked that this is working. 2. Execute SELECT pg_start_backup('label') 3. Zip the entire data directory excluding the pg_xlog directory. 4.

Re: [ADMIN] complie postgresql with kerberos in centos

2009-07-22 Thread Tom Lane
rahimeh khodadadi writes: > I have problem in compiling of postgresql with krb5 in CentOS; It should pretty much just work, if you have the appropriate packages installed. On RHEL-5 I see the RPMs requiring BuildPrereq: krb5-devel BuildPrereq: e2fsprogs-devel so make sure you have those installe

Re: [ADMIN] implement ldap authentication in PostgreSQL

2009-07-22 Thread Andreas Wenk
mitra nazemian schrieb: Excuse me, I have another question. should I run ldapserver in linux for using ldap autentication in PostgreSQL? Thanks most likely http://en.wikipedia.org/wiki/Ldap is your friend to get some basic info ... this could also be of interest: http://www.openldap.org/ O

Re: [ADMIN] implement ldap authentication in PostgreSQL

2009-07-22 Thread mitra nazemian
Excuse me, I have another question. should I run ldapserver in linux for using ldap autentication in PostgreSQL? Thanks On Wed, Jul 22, 2009 at 8:47 AM, mitra nazemian wrote: > > Oh. ok, thanks. > but can you suggest me a book to get some info about LDAP and how to use > it. I am in hurry. > I am

Re: [ADMIN] implement ldap authentication in PostgreSQL

2009-07-22 Thread mitra nazemian
Oh. ok, thanks. but can you suggest me a book to get some info about LDAP and how to use it. I am in hurry. I am in a hurry for it. Thanks -Mitra On Wed, Jul 22, 2009 at 8:39 AM, Andreas Wenk < a.w...@netzmeister-st-pauli.de> wrote: > mitra nazemian schrieb: > >> hi, >> thanks. I know that I sho

[ADMIN] complie postgresql with kerberos in centos

2009-07-22 Thread rahimeh khodadadi
Hi readers, I have problem in compiling of postgresql with krb5 in CentOS; My compiling statement is : ./configure --with-krb5 --without-readline --without-zlib --with-openssl --with-ldap because of the fact that Postgresql need ldap in compile with krb5, I have to add --with-openssl , --with

Re: [ADMIN] implement ldap authentication in PostgreSQL

2009-07-22 Thread Andreas Wenk
mitra nazemian schrieb: hi, thanks. I know that I shoud use it hostall all 127.0.0.1/32 ldap / ldap:// your.domain.com/dc=company,dc=com;uid=

Re: [ADMIN] implement ldap authentication in PostgreSQL

2009-07-22 Thread mitra nazemian
hi, thanks. I know that I shoud use it hostall all 127.0.0.1/32 ldap / ldap:// your.domain.com/dc=company,dc=com;uid=;,ou=employees,dc=company,dc=com in pg_hba.conf. I have a basic problem. I am new in PostgreSQL and linux. I dont know where I shoud define dc, ou and