problem running initdb
I am having a problem running initDB. I followed installation instructions
exactly and have the data directory made and CDOWNed to postgre user. Why
is it an unknown type ame? Did I miss something?
Thanks in advance;
--
Mike (PS: Transcript of output follows)
]]]/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.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
"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
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...
Show quoted text
"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
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
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Import Notes
Resolved by subject fallback