Re: Postgresql installation problem - Mailing list pgsql-general

First thanx for the speed of your response.

The problem is that nothing's happened when I launch postmaster.
When I run postmaster - i , the system writes :

    2002-04-15 . 10:47:06  [1016] DEBUG : database system was shut down at
......
    2002-04-15 . 10:47:06  [1016] DEBUG : Checkpoint record at (0,1522276)
    2002-04-15 . 10:47:06  [1016] DEBUG : Redo record at (0,1522276) : undo
record (0,0) shutdown TRUE
    2002-04-15 . 10:47:06  [1016] DEBUG : NextTransactionId : 615 ;
NextOid:18720
    2002-04-15 . 10:47:06  [1016] DEBUG : database system is in production
state
and it does nothing else, I don't have the prompt.

when i make CTRL-C to interrupt, the sytem writes : database was shutdown.

I think the database system starts well but there is a problem that I don't
know.
I type psql template1 or createdb ...  and nothing's happen.

Thanx for your help
Pierre-Alexis

----- Original Message -----
From: "William N. Zanatta" <william@veritel.com.br>
To: "Pierre-Alexis Paquin" <papaquin@i2m.fr>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, April 15, 2002 3:58 PM
Subject: Re: [GENERAL] Postgresql installation problem


> I'm also a newbie on postgresql. The first time I installed it was last
> friday. But I'll give a shot! Any mistakes, please correct me guys!
>
> > 1. Did you initialized your database with initdb ?
>
> This step creates the base files needed to run PSQL.
> I'll assume you're running postgresql as postgres user.
> Firstly, create a directory like data in your psql home directory. Then,
> if the owner is not the postgres user, give him the ownershio of it.
> Something like:
>
>     # cd /usr/local/psql
>     # mkdir data
>     # chown postgres:users data
>     # chmod 755 data
>
> the '#' means I'm root!
>
> now, initdb...
>
>     # su postgres
>     $ pwd
>   /usr/local/psql
>     $ cd bin
>     $ ./initdb -D /usr/local/psql/data
>
> the '$' means I'm a normal user like 'postgres' in this case
>
> > 2. Have you started Postgres with postmaster -i   or pg_ctl start ?
>
> Now you must start your postgresql daemon as postgres user. YOU CANNOT
> START POSTGRESQL AS ROOT.
>
>     $ pwd
>   /usr/local/psql/bin
>     $ ./postmaster -i -D /usr/local/psql/data &
>
> ok now your daemon should be started...
>
> > 3. Have you modified parameters in $PGDATA/postgresql.conf file ?
> > Follow your answers, you have solved your problem
>
> you can do it later. for now, check if it is working as you wish.
>
>
> See ya,
>
> William Zanatta
>