On Thu, 19 Jan 2006, Joshua D. Drake wrote:
What happens when you psql -U postgres template1 ?
A-ha! Welcome to psql 8.1.2 (server 7.4.3), the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit WARNING: You are connected to a server with major version 7.4, but your psql client is major version 8.1. Some backslash commands, such as \d, might not work properly. Now, it's accessing data in /usr/local/pgsql/data. So, it's now necessary to stop the old server and start the new one. I thought that I had done that, but obviously not. Your patience, Josh and Doug, is very much appreciated. I'm learning what I should probably have learned several years ago, and these messages will be kept for future reference. What's the next step? Rich -- Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic" <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match