Thread: initdb problems

I'm on a RedHat6.1 box.  I've built from RC4 (all sources from
tarball).  Builds/installs just fine, but when trying to do an initdb,
I get this:
[postgres@ioport postgres]$ initdb --pglib=$PWD/lib --pgdata=$PWD/data

We are initializing the database system with username postgres (uid=17).
This user will own all the files and must also own the server process.

Creating template database in /home/postgres/data/base/template1
ERROR:  Error: unknown type 'oidvector'.

ERROR:  Error: unknown type 'oidvector'.
       syntax error 12 : parse errorinitdb: could not create template database
initdb: cleaning up by wiping out /home/postgres/data/base/template1

Perhaps something needs to be looked at before release...

-- 
=====================================================================
| JAVA must have been developed in the wilds of West Virginia.      |
| After all, why else would it support only single inheritance??    |
=====================================================================
| Finger geek@cmu.edu for my public key.                            |
=====================================================================

"Brian E. Gallew" wrote:
> 
> I'm on a RedHat6.1 box.  I've built from RC4 (all sources from
> tarball).  Builds/installs just fine, but when trying to do an initdb,
> I get this:
> [postgres@ioport postgres]$ initdb --pglib=$PWD/lib --pgdata=$PWD/data
> 
> We are initializing the database system with username postgres (uid=17).
> This user will own all the files and must also own the server process.
> 
> Creating template database in /home/postgres/data/base/template1
> ERROR:  Error: unknown type 'oidvector'.
> 
> ERROR:  Error: unknown type 'oidvector'.
> 
>         syntax error 12 : parse errorinitdb: could not create template database
> initdb: cleaning up by wiping out /home/postgres/data/base/template1
> 
> Perhaps something needs to be looked at before release...

You have old Postgres executables and/or libraries in your path,
presumably due to an existing RPM installation on the machine.

Make sure you are getting the right stuff and it should work just
fine. On my laptop, which has an RPM *and* a 7.0 development tree
under my own account, I just define the following things to get
transparent access to the development version:

setenv PGPORT 12000
setenv PGROOT ~/local
setenv PGDATA $PGROOT/data
setenv PGLIB $PGROOT/lib
setenv LD_LIBRARY_PATH $PGROOT/lib
set path=($PGROOT/bin $path)

I just source this from a file, and the backend and psql fire up and
interact just fine.
                           - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California