[H-GEN] Postgresql

[Paul Cornford]

[ Humbug *General* list - semi-serious discussions about Humbug and  ]
[ Unix-related topics.  Please observe the list's charter.           ]
[ Worthwhile understanding: http://www.humbug.org.au/netiquette.html ]



Shaun Nykvist wrote:

> [ Humbug *General* list - semi-serious discussions about Humbug and  ]
> [ Unix-related topics.  Please observe the list's charter.           ]
> [ Worthwhile understanding: http://www.humbug.org.au/netiquette.html ]
>
> Hi all
>
> ...for the postgresql experts
>
> I am new to postgresql and I need to do some work on a postgresql db, 
> but before doing this I thought I would run up postgresql on my home 
> machine before wrecking havoc.  I am very familiar with using db's and 
> use mysql most days, however can someone shed some light on the 
> postgresql setup instructions.  I am running a redhat 7.2 system with 
> the standard install of postgresql.  It seems to be loaded no problems 
> - but where to from here.....any help would be appreciated.

By "loaded" do you mean that the postmaster is running? If so, set the 
postgres password as root, su to postgres and add a user with 
"createuser" which will prompt you for the postgres password as the last 
step. Then create a database with "createdb". You can then use psql or 
pgaccess depending on they type of environment you prefer to work in. 
The man pages are pretty good on how to use these clients. If the 
postmaster in not running then you need to start it yourself. The steps 
are in the postgres documentation under Installation. The Short Version 
has always worked for me. Just be sure to use the -i parameter when 
starting the postmaster or you won't be able to use pgaccess. Have fun.

Paul Cornford.


--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.