This is the first version of PostgreSQL I have _ever_ installed on this
machine, so there are no existing libraries. As well, I tried -L
/usr/pgsql/lib and that didn't help the situation either. I have also added
/usr/pgsql/bin to the path with no luck.
I am running postgresql-7.0.3, which appears to be the latest version of the
release that is not still considered beta.
Please help me out if you have any ideas
--
Mike
]]]/usr/pgsql/bin/initdb -D /usr/pgsql/data
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.
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'.
Creating global relations in /usr/pgsql/data/base
ERROR: Error: unknown type 'ame'.
ERROR: Error: unknown type 'ame'.
Adding template1 database to pg_database
/usr/pgsql/bin/initdb: line 481: 739 Segmentation fault
"$PGPATH"/postgres $BACKENDARGS template1 <"$TEMPFILE"
initdb failed.
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:28106.979592772@sss.pgh.pa.us...
> "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
