Re: POSTGres

[MR KINJAL DIXIT <kinjal.dixit@xxxxxxxxxx>]

Somebody was asking about postgres... here is how I got it started.

First, of course, you have to see that PostGres is installed!
Next you have to see that it starts up as a system service, (try saying
'setup' at the prompt, following 'system services' and checking postgres,
save settings and 'reboot')
now you need to create one Database Administrator (DBA).  After scrambling
through the docs for a couple of minutes, here is what i did:
I create a Unix user ('adduser') say 'pgdba'.  While still root, i edit the
/etc/passwd and check the password string alongside the user 'postgres' (In
my case it was '!!').  Return to shell, and do a passwd postgres and set the
password to anything, say 'abc'.  Now login as postgres and do a
'createuser'.  Specify the user name as 'pgdba', allow the user to create
databases, and to add new users.  Log in again as root, edit the /etc/passwd
file and remove the password hash string (for 'abc') with !! (what I saw
first).
Now I can log in as pgdba and use 'pgsql' to do stuff.

regards

kinjal dixit




- --------------------------------------------------------------------
For more information on Linux in India visit http://www.linux-india.org/
The Linux India mailing list does not accept postings in HTML format.

------------------------------