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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
