Re: 1st Linux Attempt -> I'm Discombobulated...

If you just set the owner of the database to some_user that should
probably take care of it.

Looks to me like you're doing a Ruby on Rails tutorial :-)

I created a single rails database and used schemas when I went
through that tutorial. Actually I'm still going through it. :-)

I added the following to my database.yml file:

schema_search_path: depot_dev

e.g.:

development:
adapter: postgresql
database: rails
schema_search_path: depot_dev
username: someuser
password: somepassword
host: localhost

test:
adapter: postgresql
database: rails
schema_search_path: depot_test
username: someuser
password: somepassword
host: localhost

production:
adapter: postgresql
database: rails
schema_search_path: depot_prod
username: someuser
password: somepassword
host: localhost

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 | brendan(at)clickspace(dot)com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G 0V9

http://www.clickspace.com

On May 6, 2006, at 12:15 AM, <operationsengineer1(at)yahoo(dot)com>
<operationsengineer1(at)yahoo(dot)com> wrote:

> okay, i'm a bit lost here.
>
> 1. i have postgresql installed on my system.
> 2. postgres user exists.
> 3. i created 3 dbs:
>
> depot_development
> depot_test
> depot_production
>
> 4. i log into postgres user
> 5. psql -l yields
>
> sh-3.1$ psql -l
> List of databases
> Name | Owner | Encoding
> -------------------+----------+----------
> depot_development | postgres | LATIN1
> depot_production | postgres | LATIN1
> depot_test | postgres | LATIN1
> postgres | postgres | LATIN1
> template0 | postgres | LATIN1
> template1 | postgres | LATIN1
> (6 rows)
>
> i want to grant all privileges to user "user_name".
>
> as per the tutorial i'm working off of, the mysql
> version is...
>
> grant all on depot_development.* to
> 'user_name'@'localhost'
>
> i was on irc and they said there is no pgsql
> equivalent command. i tried to fire up pgadmin3 to
> set grant via the gui, bit i can't login. postgres
> can't read some log and root requests a password file
> when logging in as postgres (no password is set).
>
> i'm kinda lost and a helping hand would be
> appreciated.
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>