Re: Postgres installation

torsdag 22. mars 2001, 11:21, skrev du :

> Lars,
>     I too am a novice, runnining Postgresql over SuSe, can I ask if you have
> installed using Yast, or by rpm.

Yast

> Also have you isssued the 'initdb' command ?
> I believe that you have, the same problem that I ahd at the outset, and

Thinks so too!

> that was the lack of a true idiot's guide, to enable total novices a point
> from which to begin.  I had many a fraught night, trawlling all
> documentation to find where I was going wrong to stumble on the solution.

This is something they should have made at SuSE I think

As you should have seen by now I have solved my problems; but your mail was
the one who explained the problem and the solutions best! Thanks!

Regards LarsF

>The command is as follows:-
>         'initdb postgres --pglb=/usr/lib/pgsql --pgdata=/var/lib/pgsql'
>This creates the template under the ownership of 'postgres' ( the user ).
>Ensure that you have a user created called 'postgres' or whatever, and
>ensure
>that the user has a password, if you leave it as the daemon, there is no
>password allocated, and you are unable to log on as the owner.
>After that start postmaster, log on as 'postgres' the issue the command:-
>         '/usr/bi/postmaster -iS -D /var/lib/pgsql'
>This starts postmaster with an IP connection on default port 5432.