Re: installation

On Wed, Feb 4, 2009 at 9:09 AM, Kusuma Pabba <kusumap@ncoretech.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