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
>
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! |