From: | Brendan Duddridge <brendan(at)clickspace(dot)com> |
---|---|
To: | <operationsengineer1(at)yahoo(dot)com> <operationsengineer1(at)yahoo(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: 1st Linux Attempt -> I'm Discombobulated... |
Date: | 2006-05-06 08:37:36 |
Message-ID: | 039194AC-970C-45F5-8B2E-22616F2B61B1@clickspace.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2006-05-06 15:27:09 | Re: Switch to Linux Dev Questions |
Previous Message | Andrej Ricnik-Bay | 2006-05-06 06:40:17 | Re: Switch to Linux Dev Questions |