[wellylug] How to start postgresql

Phillip Hutchings sitharus at sitharus.com
Fri Dec 15 10:24:10 NZDT 2006


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.
>
> Any assistance appreciated
>
> Colin
>
>
> --
> Wellington Linux Users Group Mailing List: wellylug at lists.wellylug.org.nz
> To Leave:  http://lists.wellylug.org.nz/mailman/listinfo/wellylug
>


-- 
Phillip Hutchings
http://www.sitharus.com/




More information about the wellylug mailing list