[GENERAL] re-using cluster

2008-06-29 Thread Fernando Dominguez
Hello, One of my hd failed recently, so I has to reinstall my system, but my data where on other hd that did not fail. So I want to use that data , I tried initd -D /storage/pgCluster but I get a "directory not empty" message, of course I want to use that cluster. How could I use that data? Th

Re: [GENERAL] tsearch strategy for incremental search

2008-06-29 Thread Oleg Bartunov
Pierre, you, probably, can use custom configuration, which uses pg_3chars dictionary. Oleg On Mon, 30 Jun 2008, Pierre Thibaudeau wrote: 2008/6/30 Oleg Bartunov <[EMAIL PROTECTED]>: tsearch will have prefix search support in 8.4. Thanks Oleg! That's fantastic news! In the meantime, carryi

Re: [GENERAL] tsearch strategy for incremental search

2008-06-29 Thread Pierre Thibaudeau
2008/6/30 Oleg Bartunov <[EMAIL PROTECTED]>: > tsearch will have prefix search support in 8.4. Thanks Oleg! That's fantastic news! In the meantime, carrying on with my earlier idea, here's the little function I came up with for extracting the 3-char-lexeme tsvector, in case anyone's interested:

Re: [GENERAL] Probably been asked a hundred times before.

2008-06-29 Thread Artacus
I'm using Ubuntu for my development server. The live update updated postgres either the day of or the day after 8.3.3 came out. Can't complain about that. Artacus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.

[GENERAL] tsearch strategy for incremental search

2008-06-29 Thread Pierre Thibaudeau
I am trying to implement an incremental search engine. The service should start searching when the user has typed at least 3 characters. I am thinking of using the following strategy: a) Create a function string_to_three_char_tsvector(str text) that would generate the tsvector composed of the thr

Re: [GENERAL] libpq block allocated before my malloc handler inits?

2008-06-29 Thread Russell Smith
rob wrote: > I am trying to build a small program with libpq as the interface to a > Postgre database. I am using the most current version. My program > uses malloc and free hooks to manage memory without having to request > memory from the system all the time. I expected that the init > functio

Re: [GENERAL] libpq block allocated before my malloc handler inits?

2008-06-29 Thread Alvaro Herrera
rob wrote: > Is there something that runs before my malloc init function in libpq? > If there is, is there a way to make it happen afterwards? Is there a > library interface which doesn't have hidden init functions? I don't see anything in our code that would initialize stealthily. Maybe it

Re: [GENERAL] freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?

2008-06-29 Thread Bill Moran
On Sat, 28 Jun 2008 11:35:24 +0200 hubert depesz lubaczewski <[EMAIL PROTECTED]> wrote: > On Sat, Jun 28, 2008 at 02:22:26AM -0300, Rodrigo Gonzalez wrote: > > So, read man page, and at least ktrace -C and read the output at > > ktrace.out file. > > ok, i've read it and didn't understand. it says

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

2008-06-29 Thread Greg Smith
On Thu, 26 Jun 2008, Adam Rich wrote: Is there any benefit to running a 32-bit OS (rhel 5 in this case) on a server with more than 4 GB of memory? If you have more than 3GB of memory, you should be using a 64-bit OS. While theoretically the 32-bit code might be smaller which has some advanta

Re: [GENERAL] LDAP Authentication

2008-06-29 Thread Magnus Hagander
Taha Ozket wrote: > Hi, > > I have a ldap group, "pgsql-developers". I have an user (user1) member > of this group; > > group > dn: cn=pgsql-developers,ou=Groups,o=Dep,dc=x,dc=x,dc=x > objectClass: groupOfUniqueNames > objectClass: top > cn: SVN Committers > uniqueMember: uid=user1,ou=Users,o=Dep

[GENERAL] LDAP Authentication

2008-06-29 Thread Taha Ozket
Hi, I have a ldap group, "pgsql-developers". I have an user (user1) member of this group; group dn: cn=pgsql-developers,ou=Groups,o=Dep,dc=x,dc=x,dc=x objectClass: groupOfUniqueNames objectClass: top cn: SVN Committers uniqueMember: uid=user1,ou=Users,o=Dep,dc=x,dc=x,dc=x user dn: uid=user1,ou=U

Re: [GENERAL] dblink to non postgresql dbms

2008-06-29 Thread Filip RembiaƂkowski
2008/6/29 David Rowley <[EMAIL PROTECTED]>: > > I had forgotten to say before that my instance of postgresql is running on > windows. > > I can't seem to find any evidence of freetds running on windows, I guess > there is not a great deal of need since MS's native client is there. So I'm > thinking