[ADMIN] Log message: recycled transaction log file...

2004-08-09 Thread Bill Chandler
Hello, Sorry if this is a too basic or is a FAQ. I've done some research but it's still unclear if this is something I should be concerned about. Running PostgreSQL 7.4.2 on Solaris 8. I'm getting a lot of the following messages in my log file: LOG: recycled transaction log file

[ADMIN] VACUUM ANALYZE and REINDEX

2004-07-19 Thread Bill Chandler
Hello, I'm sorry if this too basic. I searched the web but could not find an answer. Q1: When you do a VACUUM ANALYZE does it update the statistics for existing indexes on the table? Or do you have to do an explicit REINDEX command on the index (or possibly drop and recreate the index)?

[ADMIN] Using PL/pgSQL with statically built PostgreSQL binaries

2004-07-13 Thread Bill Chandler
Hi, I built my Solaris PostgreSQL 7.4.2 installation using: configure --disable-shared My reason was so that clients that install it would have everything there in one binary tar file and would not have to install any gcc lib patches, etc. Anyway, everything seemed to work great until I

Re: [ADMIN] Missing or errooneous pg_hba.conf file

2004-05-24 Thread Bill Chandler
and not on others. Does anybody know of any system config parameters that would affect this? Enironment variables? Config files in /etc? Very strange. Thanks, Bill --- Bill Chandler [EMAIL PROTECTED] wrote: I am in the process of having the Solaris 8 machine upgrading w/ latest patches. I will let you

Re: [ADMIN] Missing or errooneous pg_hba.conf file

2004-05-20 Thread Bill Chandler
I am in the process of having the Solaris 8 machine upgrading w/ latest patches. I will let you know if it fixes the problem. Thanks. Bill --- Tom Lane [EMAIL PROTECTED] wrote: Bill Chandler [EMAIL PROTECTED] writes: LOG: invalid entry in pg_hba.conf file at line 60, token 255.255.255.255

[ADMIN] Missing or errooneous pg_hba.conf file

2004-05-19 Thread Bill Chandler
Hello, Running 7.4.2 on Solaris 8 (binaries were built on a different Solaris 8 box). I keep getting the following message when trying to connect to server: FATAL: missing or erroneous pg_hba.conf file HINT: see server log for details. Server log contains message: LOG: invalid entry in