From: | Gilles DAROLD <gilles(at)darold(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fw: Problem starting PostgreSQL |
Date: | 2000-08-23 08:01:50 |
Message-ID: | 39A384EE.62A83A9@darold.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)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(at)gdarold /root]# su - postgres
bash$ psql template1
Then all works fine
Hope this help !
Regards,
From | Date | Subject | |
---|---|---|---|
Next Message | Gilles DAROLD | 2000-08-23 08:09:17 | Re: hidden data fields |
Previous Message | richard excite | 2000-08-23 07:08:00 | 2-phase commit |