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@clickspace.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@yahoo.com>
<operationsengineer1@yahoo.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
>