From: | Jonathan Bartlett <johnnyb6(at)sdf(dot)lonestar(dot)org> |
---|---|
To: | Brian Kejser <bkejser(at)KAISERDIGITAL(dot)com> |
Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Now what? |
Date: | 2001-06-05 20:50:16 |
Message-ID: | Pine.LNX.4.21.0106052047580.32730-100000@sdf.lonestar.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
First, run the postmaster,
as root:
/sbin/service postgres start
(may be postgresql)
This should create an initial database.
Then, su to the user postgres and do
createuser YOURUSERNAME
and sign yourself up for all the priviledges.
Then, as yourself, do
createdb
That gives you a database with the same name as your username.
To connect to the database, just run
psql
and you're off and running!
johnnyb6(at)sdf(dot)lonestar(dot)org
SDF Public Access UNIX System - http://sdf.lonestar.org
On Tue, 29 May 2001, Brian Kejser wrote:
> Hi
>
> I'm brand new to postgresql so I apologize if this sounds a bit stupid. I
> just installed the lib and server RPMS for 7.1.1.4 on Redhat 6.2. Now what?
> What do I have to do to connect to the database? How do I create my first
> procedure?
>
> Thanks
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-05 20:50:42 | Re: Help with: my bits moved right off the end of the world! |
Previous Message | Stephan Richter | 2001-06-05 20:49:32 | setting PGDATESTYLE |