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

2008-07-21 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

Re: [ADMIN] auto vacuum for opentaps

2008-07-21 Thread Alvaro Herrera
Ernesto Eduardo Medina Núñez escribió: Hi, > *autovacuum = on * # enable autovacuum subprocess? > #autovacuum_naptime = 60# time between autovacuum runs, in > secs > #autovacuum_vacuum_threshold = 1000 # min # of tuple updates before >

Re: [ADMIN] auto vacuum for opentaps

2008-07-21 Thread Scott Marlowe
On Mon, Jul 21, 2008 at 9:41 AM, Ernesto Eduardo Medina Núñez <[EMAIL PROTECTED]> wrote: > Hi I installed the open source ERP Opentaps which have 802 tables and using > PostgreSQL as backend, and also filled the tables with demo data. > > When I browse the tables using PgAdmin3 I get messages sayin

[ADMIN] auto vacuum for opentaps

2008-07-21 Thread Ernesto Eduardo Medina Núñez
Hi I installed the open source ERP Opentaps which have *802* tables and using PostgreSQL as backend, and also filled the tables with demo data. When I browse the tables using PgAdmin3 I get messages saying that:* The estimated row count on the table "some_table" deviates significantly from the act