[ADMIN] authentication

1999-08-11 Thread susy
I have Postgres v. 6.3.2 installed and I need to set it for user-password authentication. I tried to change the file pg_hba.conf in the DATA directory with both "password" and "crypt" options, but when I try to access the DB with the "-u" option I get a "user authentication failed" error. Can som

RE: [ADMIN] Elapsed time in vacuum?

1999-08-11 Thread Jackson, DeJuan
I didn't have a single problem with the upgrade. The libs seem to be compatible. You just might want to kill your apache, run ldconfig, then restart it. DEJ > -Original Message- > From: Bradford L. Barrett [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, August 10, 1999 11:44 PM > To:

Re: [ADMIN] Drastic reduction in speed

1999-08-11 Thread Jeff MacDonald
If i followed this correctly, you have done this: 'upgraded' from 6.4.2 to 6.3.something why wouldn't you go to 6.5 or 6.5.1 ? On Tue, 10 Aug 1999, Darren Greer wrote: > NoI haven't vacuumed in a whilebut this change in speed happened > almost overnight. Is that possible? > > Darr

Re: [ADMIN] solaris?

1999-08-11 Thread Herouth Maoz
At 16:50 +0300 on 10/08/1999, Colin Bodor wrote: > I am installing posgresql 6.5.1 on a Ultra 10 sparq 333mhz 256 mg's > ram and Solaris 5.7 > after compiling postgres I created a user "postgres" and added the proper > paths in his .profile. > when I do a initdb it errors on pglib, pgdata, u

Re: [ADMIN] Postgres and Multiple Processors

1999-08-11 Thread Herouth Maoz
At 18:35 +0300 on 10/08/1999, Hitesh Patel wrote: > I am running Postgres on a Linux 2.2.11 box with 2 Pentium III 550 > processors. It appears that postgres is only using the first processor > and not both. Postgres is not multi-threaded. It's multi-process. Each of its processes has only one