Re: Postgresql installation problem

From: "Pierre-Alexis Paquin" <papaquin(at)i2m(dot)fr>
To: "William N(dot) Zanatta" <william(at)veritel(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgresql installation problem
Date: 2002-04-17 15:15:35
Message-ID: 001501c1e622$b98d3440$16c6cec2@i2M.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)veritel(dot)com(dot)br>
To: "Pierre-Alexis Paquin" <papaquin(at)i2m(dot)fr>
Cc: <pgsql-general(at)postgresql(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Stanfield 2002-04-17 15:54:23 Re: Incorrect password using pg_ctl
Previous Message Dima Tkach 2002-04-17 14:06:54 Re: Large table update/vacuum PLEASE HELP!