On Wed, May 04, 2005 at 05:21:13PM +0100, Dirk Bade wrote: > > postgresql-8.0.1.tar.gz installs fine and tests run ok. But after initdb > PG_VERSION shows 7.1 and simple commands like CREATE TABLESPACE or ALTER > TABLE return errors. What's wrong ?
It sounds like you've installed 8.0.1 but are running commands and the backend from 7.1, which presumably exist from a previous install. Might 7.1's commands be in your PATH ahead of the 8.0.1 commands? Where were the 8.0.1 files installed? What do the following commands show? which initdb initdb --version When you connect to the database, what does "SELECT version()" show? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
