Re: Fw: Problem starting PostgreSQL

Len Morgan wrote:

> I'm not sure the standard Red Hat install (or Postgres rpm) starts the
> server with the -i option.  He didn't mention whether they were on the same
> machine or not.
>
> Len Morgan

The standard Red Hat install include the -i option but it doesn't start
at all the first time.
Here is the default command line into the init script :

su -l postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql'

So you first have to run :

/etc/rc.d/init.d/postgresql start

It will run initdb, create the database architecture into /var/lib/pgsql/
and create the famous base template1...

After that you can run psql template1 without problems.

Here is what RH done :

[root@gdarold /root]# /etc/rc.d/init.d/postgresql start
Checking postgresql installation: no database files found.

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

Creating Postgres database system directory /var/lib/pgsql/base

Creating template database in /var/lib/pgsql/base/template1

Creating global classes in /var/lib/pgsql/base

Adding template1 database to pg_database...

Vacuuming template1
Creating public pg_user view
Creating view pg_rules
Creating view pg_views
Creating view pg_tables
Creating view pg_indexes
Loading pg_description
Starting postgresql service: postmaster [1078]
[root@gdarold /root]# su - postgres
bash$ psql template1

Then all works fine

Hope this help !

Regards,