[ADMIN] User DB Access - RESTRICTIONS

2007-05-25 Thread Marsha Ramsey
Hello all, How to make a postgres user have access to only one database, and to set that access as read only? Thanks...Marsha - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. - The fish

[ADMIN] User DB Access - RESTRICTIONS

2007-05-25 Thread Marsha Ramsey
Hello all, How to make a postgres user have access to only one database, and to set that access as read only? Thanks...Marsha - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.

Re: [ADMIN] Question about HeapTupleHeaderData

2007-05-25 Thread Alvaro Herrera
Federico escribió: > Hi, > I'm writing some papers about PostgreSQL physical storage and I'm > bumping into the HeapTupleHeaderData layout as descripted here > http://www.postgresql.org/docs/8.2/static/storage-page-layout.html > > Reading the source code in src/include/access/htup.h I got a quest

Re: [ADMIN] Abnormal storage consumption with autovacuum enabled

2007-05-25 Thread Tom Lane
Nicola Mauri <[EMAIL PROTECTED]> writes: >> What do you have max_fsm_pages set to? > Currently, max_fsm_pages=2 > Running VACUUM VERBOSE reports: > NOTICE: number of page slots needed (237312) exceeds max_fsm_pages (2) > HINT: Consider increasing the configuration parameter "max_fsm

Re: [ADMIN] Abnormal storage consumption with autovacuum enabled

2007-05-25 Thread Nicola Mauri
What do you have max_fsm_pages set to? Currently, max_fsm_pages=2 Running VACUUM VERBOSE reports: NOTICE: number of page slots needed (237312) exceeds max_fsm_pages (2) HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 237312. Is this measuremen

Re: [ADMIN] Loader

2007-05-25 Thread Marc G. Fournier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sounds like you want to look at the COPY command ... - --On Friday, May 25, 2007 12:14:17 +0530 "Khan, Mahmood Ahram" <[EMAIL PROTECTED]> wrote: > > > > > Is there any Loader in Postgres like SQL Loader? Through which I can load > data from flat f