Re: [ADMIN] Documents storage

2004-08-17 Thread Oleg Bartunov
On Wed, 18 Aug 2004, Gaetano Mendola wrote: > Oleg Bartunov wrote: > > > On Tue, 17 Aug 2004, Gaetano Mendola wrote: > > > > > >>Hi all, > >>where I work some times we need to find our documents > >>searching for a couple of words. I was thinking to > >>use the tsearch2. > >> > >>Shall I use OpenF

Re: [ADMIN] new install starting backend

2004-08-17 Thread Joe Sunday
On Tue, Aug 17, 2004 at 04:23:02PM -0700, David Bear wrote: > I installed postgres from the freebsd ports collection. > > Then, after doing the initdb, I tried to run the backend as the > postgres user, ie while su'ed as pgsql. I was prompt for a password. > Since I had not change and pg_hba.conf

Re: [HACKERS] [ADMIN] SRPM for 8.0.0 beta?

2004-08-17 Thread Joe Conway
Tom Lane wrote: Joe Conway <[EMAIL PROTECTED]> writes: Hopefully the third try is a charm ;-) Version 3 is now available: fixes the init script. Previously /etc/init.d/postgresql worked the first time used (i.e. would initdb and start postgres) but not the second and subsequent times. [ blink...

Re: [HACKERS] [ADMIN] SRPM for 8.0.0 beta?

2004-08-17 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Hopefully the third try is a charm ;-) > Version 3 is now available: fixes the init script. Previously > /etc/init.d/postgresql worked the first time used (i.e. would initdb and > start postgres) but not the second and subsequent times. [ blink... ] Was

Re: [ADMIN] Documents storage

2004-08-17 Thread Gaetano Mendola
Oleg Bartunov wrote: On Tue, 17 Aug 2004, Gaetano Mendola wrote: Hi all, where I work some times we need to find our documents searching for a couple of words. I was thinking to use the tsearch2. Shall I use OpenFTS? Do you have any suggestion ? tsearch2 is ok if you have docs and db on the same

[ADMIN] new install starting backend

2004-08-17 Thread David Bear
I installed postgres from the freebsd ports collection. Then, after doing the initdb, I tried to run the backend as the postgres user, ie while su'ed as pgsql. I was prompt for a password. Since I had not change and pg_hba.conf settings, nor set a password during the initdb phase, I was surprised

Re: [ADMIN] Documents storage

2004-08-17 Thread Oleg Bartunov
On Tue, 17 Aug 2004, Gaetano Mendola wrote: > Hi all, > where I work some times we need to find our documents > searching for a couple of words. I was thinking to > use the tsearch2. > > Shall I use OpenFTS? > Do you have any suggestion ? > tsearch2 is ok if you have docs and db on the same serve

Re: [HACKERS] [ADMIN] SRPM for 8.0.0 beta?

2004-08-17 Thread Joe Conway
Joe Conway wrote: Version 2 of the source rpm is now available here: http://www.joeconway.com/postgresql-8.0.0beta1/SRPM/postgresql-8.0.0beta1-2PGDG.src.rpm I've also put up i386 binary rpms for fc1 and fc2, and x86_64 binary rpms for fc2. Hopefully the third try is a charm ;-) Version 3 is now

Re: [ADMIN] Pseudo-Off-topic-survey: Opinions about future of

2004-08-17 Thread Robert Treat
On Mon, 2004-08-16 at 11:52, Chris Browne wrote: > And the"dramatically reducing cost" and "instant grow of client base" > are both illusions. > > 1. CA doesn't save money by porting their applications to run on > Ingres; it _costs_ them money to do so. > > 2. CA doesn't instantly grow i

[ADMIN] Documents storage

2004-08-17 Thread Gaetano Mendola
Hi all, where I work some times we need to find our documents searching for a couple of words. I was thinking to use the tsearch2. Shall I use OpenFTS? Do you have any suggestion ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you se

Re: [ADMIN] [PHP] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in

2004-08-17 Thread Mark Gibson
Mark Gibson wrote: Mark Gibson wrote: Hi, I've been trying to Kerberize our Apache and PostgreSQL servers for our company's web applications. [snip] I'VE DONE IT! THE HOLY GRAIL OF WEB/DB APPS! :) All it takes it this line your PHP script: putenv("KRB5CCNAME={$_SERVER['KRB5CCNAME']}"); Then pg_

Re: [ADMIN] [PHP] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in

2004-08-17 Thread Mark Gibson
Mark Gibson wrote: Hi, I've been trying to Kerberize our Apache and PostgreSQL servers for our company's web applications. Goal: To connect from a PHP web app to a PostgreSQL database using the users credentials, so all authorization is managed via privileges within the database. Our IT dept has

Re: [ADMIN] What's the best way to use a Solid State HDD?

2004-08-17 Thread Tom Lane
Chris Gamache <[EMAIL PROTECTED]> writes: > What would you do if you had a solid state hdd to use and you wanted > to speed up PostgreSQL? "Put WAL on it" is certainly the default answer. If you are mainly concerned about speeding up writes, then this is also the correct answer. If you are mainl

Re: [ADMIN] What's the best way to use a Solid State HDD?

2004-08-17 Thread Gaetano Mendola
Chris Gamache wrote: I'm using a TiGiJet 2GB Solid State drive. How much it cost ? My thought was to place the WAL on it to speed up writes. I don't know of any > tools that exist to determine the effectiveness of this except for anecdotal > analysis (This type of query took 3 minutes yesterday

[ADMIN] What's the best way to use a Solid State HDD?

2004-08-17 Thread Chris Gamache
I'm using a TiGiJet 2GB Solid State drive. My thought was to place the WAL on it to speed up writes. I don't know of any tools that exist to determine the effectiveness of this except for anecdotal analysis (This type of query took 3 minutes yesterday, and 1 minute today) ... Sar gives me machine-w

[ADMIN] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in harmony! How?

2004-08-17 Thread Mark Gibson
Hi, I've been trying to Kerberize our Apache and PostgreSQL servers for our company's web applications. Goal: To connect from a PHP web app to a PostgreSQL database using the users credentials, so all authorization is managed via privileges within the database. Our IT dept has recently installed

Re: [ADMIN] 7.4.3 and PAM authentication failures

2004-08-17 Thread Kris Deugau
Dallas N Antley wrote: > /- On Monday (8/16/2004 19:35) Tom Lane <[EMAIL PROTECTED]> wrote: > > I think you've proven that the particular PAM modules you are > > testing with are useless for programs executing as non-root, but > > that doesn't mean the entire concept is broken. Look around ... > >

[ADMIN]

2004-08-17 Thread Jean-Max Reymond
-- Jean-Max Reymond CKR Solutions http://www.ckr-solutions.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html