| From: | Kenneth Porter <shiva(at)sewingwitch(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Access rights for tablespaces, phpPgAdmin versus PgAdmin |
| Date: | 2007-11-15 02:45:54 |
| Message-ID: | 30B2769BD722F9F4FD7848F2@[10.169.6.155] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I'm coming from MySQL and still trying to get my head around the PostgreSQL
approach to authentication and access control.
I got postgres installed on CentOS 5 with yum, started the server (which
creates the initial database), and installed phpPgAdmin on the same server
under Apache. I then installed PgAdmin 1.8.0 on my XP box on my LAN. Using
psql, I created a login role with all rights except superuser.
I got my head around pg_hba.conf so I can log into both phpPgAdmin and
PgAdmin from my XP system using my new role account.
I then proceeded to create a new database in which to copy existing tables
from another (Windows-based) application. (I plan to use the ODBC
connector.) (As I type this, I just tried this with phpPgAdmin and it
worked. I'll continue, though....) PgAdmin refuses to let me create the new
DB, telling me "permission denied for tablespace pg_default". Some googling
suggests that this is intentional, that if one wants to create a new table
one needs to change the default tablespace permissions to allow it, or
create a new tablespace.
So why does phpPgAdmin succeed, and PgAdmin fail? What's the correct
procedure to follow here? (I don't need a separate tablespace at this time,
although I don't have a problem with creating one.) Do I need to change
permissions on pg_default, and if so, how? I don't see where I can change
permissions on a tablespace in PgAdmin.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenneth Porter | 2007-11-15 03:10:26 | Re: http://localhost/phpPgAdmin/ |
| Previous Message | Kenneth Porter | 2007-11-15 02:30:48 | Re: populating arrays with default values |