pgsql to ldap

From: Nicolas Kowalski <Nicolas(dot)Kowalski(at)imag(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: pgsql to ldap
Date: 2001-12-13 09:38:48
Message-ID: vqo8zc7jw7r.fsf@anie.imag.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello.

I use PostgreSQL 7.1.3 for our intranet database.

I am working on building an LDAP directory based on the info provided
by the intranet database. Currently the only available method for
updating this LDAP directory is to delete all records then rebuild
them from scratch. This is quite dirty, and really too long, and this
is not acceptable for the Netscape roaming profiles.

I thought to write scripts that would be called through triggers in
the database, then would generate ldif files for updating LDAP with
just the necessary information. But then I saw the message from Tom
Lane (http://www.geocrawler.com/mail/msg.php3?msg_id=5446222&list=6),
and decided not follow this design. But now I am a bit stucked.

Perhaps I can use a sort of logging table containing create/old/new
values for a particular field of a table, and extract modified data
from here. I am not sure that this will work. Did anyone implemented
such a functionnality ? Am I going the wrong way ?

Thanks in advance.
Nicolas.

Browse pgsql-general by date

  From Date Subject
Next Message Serkan BEKTAS 2001-12-13 09:49:22 How Can I reach the mail archieve ?
Previous Message Timmy 鄧添喜 2001-12-13 09:20:07 Can I call unix/linux commands within plsql?