Re: problem running initdb - Mailing list pgsql-general

From Tom Lane
Subject Re: problem running initdb
Date
Msg-id 28106.979592772@sss.pgh.pa.us
Whole thread Raw
In response to problem running initdb  ("Mike Miller" <temp6453@hotmail.com>)
List pgsql-general
"Mike Miller" <temp6453@hotmail.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

pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Re: PGAccess (or other GUI) RPM?
Next
From: Alex Pilosov
Date:
Subject: Re: SQL queries from within PL/PERL triggers?