[lug] Postgresql

[Michael Deck]

On a stock redhat system, start the postmaster with 
"/etc/rc.d/init.d/postgresql start". You may want to browse this script to 
see what it does before you run it. To get this script run at startup, the 
easiest thing to do is

"chkconfig --add postgresql"

as root. Linuxconf also has some startup script options but I'm not as 
familiar with it.

After you get the postmaster running, you'll undoubtedly run into one other 
thing which is that the userid you're trying to use to create the database 
isn't allowed to do so. Do this:

login as postgres (change password as root if you need to)
createuser <name>

and give that user the authority to create users and databases. "Root" 
doesn't have authority to create databases by default.

You may have to edit $PGDATA/pg_hba.conf if the preceding doesn't work. 
Whenever you change the .conf file you should restart the postmaster.

At 10:54 PM 11/30/99 -0800, you wrote:
>Hello,
>         Can someone help me?  I am relatively new to Linux.  I have a single
>computer up and running.  I can print, mount various devices etc.  I have
>tried unsuccessfully to make Postgresql work.  I have gotten a variety of
>error messages.  Is the Postmaster running Unix Socket 5432.  Postgres does
>not know where the data base is.  I have tried to create my on database
>with much the same results.  Where is the database that it is looking for.
>Perhaps I do not have enough base information to even have a handle on the
>situation.  I found a set of instructions on how to install Postgresql.  I
>tried to follow those instructions and was greated with is the postmaster
>running Unix Socket 5432.  Where is this and how do I configure it.  I have
>chased my tail aroung in circles looking for a way to correc the error
>messaes with no avail.  Is there any help for me or am I trying to bite off
>more than I can chew with my limited knowledge?
>         Thank you to any one who can steer me in to the proper direction.
>
>Tim Porter.
>
>
>
>_______________________________________________
>Web Page:  http://lug.boulder.co.us
>Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug


Michael Deck
Cleanroom Software Engineering, Inc.