Re: installation

On Wed, Feb 4, 2009 at 9:09 AM, Kusuma Pabba <kusumap(at)ncoretech(dot)com> wrote:
> Hello all,
> i am new to postgresql, i want to create tables in this
>
> i have followed
> 10 Steps to Installing PostgreSQL which is chapter two of installing
> postgresql
>
> i could follow upto step no 7
> but i am getting errors from step 8
> while following the steps i got message like postgresql is sucessfully
> installed
>
> now my doubt if it is installed, how should i start working on it
> i used
> sudo su postgres -c psql template1
> password for my super user:**********
> then the prompt changed to postgres=#
>
> what does this implies can i start working on that or do i have to modify
> furthur

>
> sorry for such a long mail and Thanks for any help!!!!!!!
Quite short actually. Just about enough information.

So I assume it is unix/linux.
if you get postgre=# prompt, you're in psql shell. So you can start
issue queries, create users/databases etc.
For instance, try:

select version();
in that shell.

personally I would suggest following the steps:

sudo su - postgres
createuser <USER NAME>
createdb -U <USER NAME> mydb
exit

psql -U <USER NAME> mydb

HTH

--
GJ