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

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