Re: [ADMIN] server lacks of instrumentation functions in CentOS

2008-07-20 Thread Devrim GÜNDÜZ
On Sat, 2008-07-19 at 15:06 -0600, Ernesto Eduardo Medina Núñez wrote: > I know That i need to run the admin81.sql script, but I don't know if > my distribution has compiled postgresql to support that functions. > I installed the postgresql-contrib, but I don't know what is the > module that I need

Re: [ADMIN] Created non-owner user cannot see database

2008-07-20 Thread Niklas Johansson
On 20 jul 2008, at 16.09, Daniel J. Summers wrote: I just tried "GRANT CONNECT", and the problem still exists. If you try to login to the database using psql, instead of phpPgAdmin, what does it tell you? Error messages? Sincerely, Niklas Johansson -- Sent via pgsql-admin mailing l

Re: [ADMIN] Created non-owner user cannot see database

2008-07-20 Thread Daniel J. Summers
Niklas Johansson wrote: On 20 jul 2008, at 04.47, Daniel J. Summers wrote: grant usage on database custom_database to user_no_2; Now, none of these commands failed - they all came back with "CREATE ROLE" (or the appropriate response). Are you sure? 'GRANT USAGE ON DATABASE...' is invalid s

Re: [ADMIN] Created non-owner user cannot see database

2008-07-20 Thread Niklas Johansson
On 20 jul 2008, at 04.47, Daniel J. Summers wrote: grant usage on database custom_database to user_no_2; Now, none of these commands failed - they all came back with "CREATE ROLE" (or the appropriate response). Are you sure? 'GRANT USAGE ON DATABASE...' is invalid syntax. You probably want