PostgreSQL Bugs - BUG #1647: shows version 7.1, doesnt create tablespaces etc.

Author

BUG #1647: shows version 7.1, doesnt create tablespaces etc.

Dirk Bade

2005-05-05, 9:24 am

The following bug has been logged online:

Bug reference: 1647
Logged by: Dirk Bade
Email address: dbade@softdecc.com
PostgreSQL version: 8.0.1
Operating system: SUSE LINUX 7.3
Description: shows version 7.1, doesnt create tablespaces etc.
Details:

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 ?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Michael Fuhr

2005-05-05, 9:24 am

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

Tom Lane

2005-05-05, 9:24 am

"Dirk Bade" <dbade@softdecc.com> writes:
> 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 ?

You're still talking to a 7.1 postmaster.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Michael Fuhr

2005-05-06, 9:24 am

On Fri, May 06, 2005 at 02:35:16PM +0200, Dirk Bade wrote:
>
> YES, you were right: the 7.1-binaries were still existent in /usr/bin - I
> wonder how this postmaster could coperate with V8.0.1 !?

If the files (binaries, libraries, headers, etc.) for each version
are installed in different places and the postmasters are configured
to listen on different ports, then they should be able to coexist.
However, as you've discovered, a problem is that you might accidentally
use files for one version when you wanted the other. One way of
handling that is described in Issue #105 of the General Bits
newsletter under "Organizing Your Environment for Multiple Databases
and Installations":

http://www.varlena.com/varlena/GeneralBits/105.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Sponsored Links