Re: first steps

Donn Washburn wrote:
> I have looked at the suggestions on >
> http://www.postgresql.org/docs/8.4/static/
> But I still am confused setting up the permissions and myself as a user.
> I have seen /home/donn/.pgpsql and .pgadmin. However, I am not sure
> where to start - edit postgres's pg_hba.conf file maybe?
> /usr/bin/postmater is available. I do have pgadmin3 and it requires a
> pgsql user and password.

For instance, you may want to create new database and new user. First,
swith to postgres user:

su - postgres

Than open psql

psql

Than create database

CREATE DATABASE test_database WITH ENCODING='UTF8';

Then create user

CREATE USER donn PASSWORD 'changeme';

Then, connect to the database:

\c test_database

Then, grant privilleges to user donn:

GRANT ALL ON SCHEMA public TO donn;

Next, try to connect to the specified database with specified user:

\q
exit
psql test_database donn

If that works fine, try connecting to that same database with the same
user using pgAdmin. If both pgAdmin and PostgreSQL are on the same
machine, there is no need to modify pg_hba.conf and postgresql.conf.

Regards,
Ognjen