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

Reply via email to