Re: problem running initdb

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mike Miller" <temp6453(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem running initdb
Date: 2001-01-15 21:06:12
Message-ID: 28106.979592772@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mike Miller" <temp6453(at)hotmail(dot)com> writes:
> Fixing permissions on pre-existing data directory /usr/pgsql/data
> Creating database system directory /usr/pgsql/data/base
> Creating database XLOG directory /usr/pgsql/data/pg_xlog
> Creating template database in /usr/pgsql/data/base/template1
> ERROR: Error: unknown type 'ame'.
>
> ERROR: Error: unknown type 'ame'.

This looks suspiciously like initdb is picking up the wrong template
files. Do you have an older PG version still installed on your machine?
Set environment variable PGLIB, or use the -L option to initdb, to point
it at the lib directory that corresponds to the version you are trying
to run. Also make sure that your PATH finds the postgres executable
that is the version you want to run.

7.1's initdb tries to verify that everything is the right version, but
in older releases you have to be careful...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-01-15 21:25:19 Re: Need "InBetween" (not just Before and After) Trigger
Previous Message Lamar Owen 2001-01-15 21:00:12 Re: Re: PGAccess (or other GUI) RPM?