Postgres Pro
Downloads
Home   >   mailing lists

Thread: Installation Problem

Installation Problem

From
Webb Sprague
Date:
Hi all.

I am trying to install 7.0.2 on RH 6.2.  Please help
me...  I can make fine, but when I try to initdb I get
the following:

<BEGIN QUOTE>
wsprague>initdb

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

Creating template database in
/usr/local/pgsql/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
/usr/local/pgsql/data/base/template1
[wsprague@lappi wsprague]$

<END QUOTE>

wsprague owns "data" & "base".  I get a similar error
when I su to postgres, as well.

Thanks again
W

__________________________________________________
Do You Yahoo!?
Yahoo! Mail � Free email you can access from anywhere!
http://mail.yahoo.com/

RE: Installation Problem

From
"Robert D. Nelson"
Date:
>I am trying to install 7.0.2 on RH 6.2.  Please help
>me...  I can make fine, but when I try to initdb I get
>the following:
>
><BEGIN QUOTE>
>wsprague>initdb

When you startup postgres initially, either from bootup or by manually
running "/etc/rc.d/init.d/postgres* start", do you get any errors? I have
used the second method every time I've installed postgres, prior to running
any sort of psql query.


Rob Nelson
rdnelson@co.centre.pa.us

Re: Installation Problem

From
Tom Lane
Date:
>> I am trying to install 7.0.2 on RH 6.2.  Please help
>> me...  I can make fine, but when I try to initdb I get
>> the following:

(Sorry for slow response, but I've been out of town)

The symptom sounds a lot like initdb is invoking a pre-7.0
'postgres' executable and feeding it 7.0 init files.  Check
your PATH to make sure the 7.0 bin directory appears before
any older installation.

            regards, tom lane