Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
"Dirk Bade"
Date:
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 ?

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

From
Michael Fuhr
Date:
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/

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

From
Tom Lane
Date:
"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

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

From
Michael Fuhr
Date:
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/