Re: What packages I need to install to get Postgres working

Andre Lopes wrote:
> Hi,
>
> Thanks for your reply.
>
> I have installed postgresql 8.3, and now, what I need to do to get
> things working? Install PGAdmin? Or there are other steps I need to do
> to get things working? For example, how can I define the password for
> access as sysadmin?

yourusername $ sudo su - postgres
postgres $ psql
...
postgres=# create user yourusername with createdb createrole password
'newpassword';
CREATE USER
postgres= # create database yourusername with owner yourusername;
CREATE DATABASE
postgres=# \q
postgres $ exit
yourusername $ psql
...
yourusername=# ......

this will create a postgres user with the same username as your regular
login, a password, and the privileges to create more databases and users

you might need to add the ubuntu postgres bin directory to your user's
path, I dunno (I don't use ubuntu)

you will undoubtedly want to modify the pg_hba.conf file to suit your
connection and authentication requirements. see the online
documentation for more on this, its in the introduction/tutorial section