Re: [ADMIN] Problem with regression testing

[Robin's Postgres List Archive]

Problem solved, thank you for the responses!
Yes, I had run initdb as outlined in the instructions.
Then I received a tip from someone on the list suggesting:

"do: rpm -qa | grep postgres
then, for each package it returns: rpm -e <PACKAGE NAME>"

Which I did.  At that point, running createdb gave me a *new* error
message that didn't refer to pg_database or template1.

On a whim I ran initdb again and got this response from the system which
is understandable since I had already run it:

>>>
We are initializing the database system with username postgres (uid=100).
This user will own all the files and must also own the server process.

initdb: error: File /usr/local/pgsql/data/PG_VERSION already exists.
This probably means initdb has already been run and the 
database system already exists.

If you want to create a new database system, either remove 
the directory /usr/local/pgsql/data or run initdb with a --pgdata option 
other than /usr/local/pgsql/data.
<<<

So I removed the directory /usr/local/pgsql/data and ran initdb again.
It did it's thing again with pg_database and template1.

At this point running createdb gave me an error about not being able to
open the postgres libraries, so I added the libraries' path to
/etc/ld.so.conf and from there was off and running!

Thanks again for the help,

-Robin

On Fri, 10 Sep 1999, Jacques B. Dimanche wrote:

> At 07:42 PM 9/9/99 -0700, Postgres Mailing List wrote:
> >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:
> >FATAL 1:  Database template1 does not exist in pg_database
> 
> Hmmmm... sounds like you forgot to run "initdb" which will create the 
> template1 database for you and set things up.  Did you run that first?
> 
> Sincerely Yours,
> 
>       Jacques Dimanche
>       VP of Research and Development
>       Tridel Technologies, Inc.
> 
> ************
> 



************