From: | Ognjen Blagojevic <ognjen(at)etf(dot)bg(dot)ac(dot)rs> |
---|---|
To: | Donn Washburn <n5xwb(at)comcast(dot)net> |
Cc: | PostgreSQL Novice elist <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: first steps |
Date: | 2010-04-14 15:21:20 |
Message-ID: | 4BC5DD70.6090408@etf.bg.ac.rs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Please, post to the mailing list, not private.
When are you asked for password? At "psql" or "psql test_database donn"?
-Ognjen
Donn Washburn wrote:
> I assume the password is <enter> but that fails. So does any other
> guess I try. This is a 11.3 M4 rpm based 8.4 postgres install
>
> On 04/14/2010 03:35 AM, Ognjen Blagojevic wrote:
>> 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
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | peter | 2010-04-14 15:58:42 | Upgrading from PostgreSQL 7.4.3 |
Previous Message | Devrim GÜNDÜZ | 2010-04-14 08:40:36 | Re: PostgreSQL Linux Distro |