Hi, I've installed PostgreSQL on a RedHat 6.0 i386 box. The compile and
everything seemed to go fine. I'm now logged in as the superuser
(postgresql) following the install instructions in the docs. postmaster
is indeed running. PGLIB and PGDATA are properly set
(PGLIB=/usr/local/pgsql/lib and PGDATA=/usr/local/pgsql/data). But when I
run "createdb" to test things out I get this:
...
[postgres@catclaw bin]$ createdb
Connection to database 'template1' failed.
FATAL 1: Database template1 does not exist in pg_database
createdb: database creation failed on postgres.
...
And when I try to create a db user with createuser I get the same message:
...
[postgres@catclaw bin]$ createuser
Connection to database 'template1' failed.
FATAL 1: Database template1 does not exist in pg_database
createuser: database access failed.
...
The only thing that bothers me is that the PostgreSQL package that comes
bundled with RedHat 6.0 *was* installed when the system was initially set
up. So there's a bunch of PostgreSQL executables in /usr/bin and there's
existing PostgreSQL stuff residing in places like /var/lib. Conversely,
*I've* been working with my own install downloaded from postgresql.org,
the postgresql-6.5.1.tar.gz package. Could this problem I'm having be
related to a conflict therein?
Does anyone have any suggestions?
Thanks,
-Robin
************
