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.