"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