Thread: RE: Postgres - trouble starting it - solved and SUM of what I did

RE: Postgres - trouble starting it - solved and SUM of what I did

From
Lars Forseth
Date:
Hi!
This is my little sum of what I did to get postgres to start up. First,
thanks to tosi (suse-linux-e list) and Aarni Ruuhhimki (pgsql-novice list).

First, from Tosi I got this little hint:
"In SuSE 7.0, there was an error in the /etc/init.d/postgres script.
Replace "~postgres/data" with "/var/lib/pgsql/data" and your'e go :-)
-tosi"

So I edited this file; but first I had trouble finding it until I discovered
it in  /etc/rc.d/init.d/. And there it was; ~postgres/data; changed that into
/var/lib/pgsql/data.

From Aarni I got this hint:
"You have run initdb ?
e.g.
initdb -r /usr/share/pgdata --pglib /usr/lib/pgsql
vbrgds,
aarni"

At first I could not get this to work, but when I reformatted this command to
initdb /var/lib/pgsql/data --pglib /usr/lib/pgsql ; and IMPORTANT ran it as
user postgres, with postgres as owner of the /var/lib/pgsql/data dir; THEN
the whole thing ran and created my template1 database + datadir for postgres!

Then as root i ran "rcpostgres start"; and postgres restartet!

So now I can conect to postgres, create databases etc.

A wish; this should have been noted somewhere on SuSE's suportdatabase. Maybe
they could make a kind of "open source" page (;-)) where people could post
this kind of thing! Then perhaps this kind of problems and the solutions to
them could be spread more efficiently!

Regards Larsf



--
--------------------------
Lars Forseth
http://www.uio.no/~forseth
MS WIN > /dev/null
TUX rules
--------------------------


Re: [SLE] RE: Postgres - trouble starting it - solved and SUM of what I did

From
Jerry Kreps
Date:
When you installed Postgres the SuSE dev staff left an email to root
explainging how to get it going.
JLK


On Wednesday 21 March 2001 15:23, Lars Forseth wrote:
> Hi!
> This is my little sum of what I did to get postgres to start up.
> First, thanks to tosi (suse-linux-e list) and Aarni Ruuhhimki
> (pgsql-novice list).
>
> First, from Tosi I got this little hint:
> "In SuSE 7.0, there was an error in the /etc/init.d/postgres
> script. Replace "~postgres/data" with "/var/lib/pgsql/data" and
> your'e go :-) -tosi"
>
> So I edited this file; but first I had trouble finding it until I
> discovered it in  /etc/rc.d/init.d/. And there it was;
> ~postgres/data; changed that into /var/lib/pgsql/data.
>
> >From Aarni I got this hint:
>
> "You have run initdb ?
> e.g.
> initdb -r /usr/share/pgdata --pglib /usr/lib/pgsql
> vbrgds,
> aarni"
>
> At first I could not get this to work, but when I reformatted this
> command to initdb /var/lib/pgsql/data --pglib /usr/lib/pgsql ; and
> IMPORTANT ran it as user postgres, with postgres as owner of the
> /var/lib/pgsql/data dir; THEN the whole thing ran and created my
> template1 database + datadir for postgres!
>
> Then as root i ran "rcpostgres start"; and postgres restartet!
>
> So now I can conect to postgres, create databases etc.
>
> A wish; this should have been noted somewhere on SuSE's
> suportdatabase. Maybe they could make a kind of "open source" page
> (;-)) where people could post this kind of thing! Then perhaps this
> kind of problems and the solutions to them could be spread more
> efficiently!
>
> Regards Larsf