[wellylug] How to start postgresql

William Hamilton william.hamilton at gmail.com
Fri Dec 15 10:41:57 NZDT 2006


Phillip Hutchings wrote:
> Postgres likes hiding in the background. I'm not sure how Debian
> packages it, but it generally goes somthing like this:
> 
> # Get a root shell
> sudo -s
> # Change to Postgres' superuser
> su - postgres
> # Create yourself a user account, replace myname with your account name
> createuser myname
> # Answer yes when it asks if the account should be a superuser
> # and drop back to your account name
> exit
> exit
> # Create a database. If you want to name it then put the name on the
> command line,
> # otherwise it will  have the same name as your account
> createdb
> # Then load the psql shell. Again supply the DB name if you don't want
> the default
> psql
> 
> On 12/15/06, Colin & Josephine Lewis <cjlewis at slingshot.co.nz> wrote:
>> I am wanting to start to get to know Postgresql, but cannot figure out
>> the command to start a new postgres session and establish myself as a
>> valid user.  I know the Postgres server is starting when my machine
>> boots, but nothing appears in the Gnome menus to indicate its presence,
>> so figure I must drive it from a terminal.  I am running the latest
>> version of Debian if that helps.

In addition to the above posting it could be worth also checking out teh 
following sites.

#Manuals
http://www.postgresql.org/docs/7.3/static/sql-createuser.html
http://www.postgresql.org/docs/current/static/sql-createuser.html

#GUI tool
http://www.pgadmin.org/download/debian.php

good luck

W




More information about the wellylug mailing list