[plug] Postgresql help && RH6.2

[Anthony J. Breeds-Taurima]

On Wed, 26 Jul 2000, James Robert New wrote:

> HI All
> 
> I have installed postgresql with my last full install
> but have never used it before.
> I now need to use it and am unsure about the docs I have read.
> could someone tell me how to use it?
> {I just need to do a few sql assignments and it would be handy
> to do it wiyhout logging into the schools sql account}

It's knida hard to tell what your oing here and as what user you are doing it.

Here's a rought guide to what I do it assumes you are logged into the machine
as yourself NOT root.

$ su -                                          # Get root
install RPMS
# /etc/rc.d.init.d/postrgesql start             # Start Daemons
# su - postgres                                 # postgres is the ONLY user
                                                # currently configured.
$ createuser root                               # Now so is root.
                                                # make sure you make root
                                                # a superuser
$ exit                                          # back to root
# createuser <your uname>                       # Now you too will have access
                                                # to the power of postgres
                                                # make sure to make your
                                                # database
# exit                                          # back to you
$ psql                                          # Yay :)

Now you are ready for SQL action.

Yours Tony.

/*
 * "The significant problems we face cannot be solved at the 
 * same level of thinking we were at when we created them."
 * --Albert Einstein
 */