[ADMIN] User DB Access - RESTRICTIONS
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 are biting. Get more visitors on your site using Yahoo! Search Marketing.
[ADMIN] User DB Access - RESTRICTIONS
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
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 question. > > The t_cmin and t_cmax stores the insert and delete CID stamps. > the CID (command that operate on item id?) is similar to XID? where I > can find some docs about CID and its meaning? CID is shorthand for CommandId. Each tuple created or destroyed in a transaction is marked with the creation CommandId (cmin) and the destruction CommandId (cmax). A later command in the transaction should not be able to see a tuple destroyed by an earlier command; and an earlier command should not be able to see a tuple created by a later command. This mechanism is there to solve the so-called Halloween Problem. http://blogs.ittoolbox.com/database/technology/archives/what-is-the-halloween-problem-in-databases-12618 The current CommandId in a transaction is incremented each time an UPDATE/INSERT/SELECT/DELETE (etc) operation is performed. Some utility commands (CREATE TABLE, etc) may increment the command counter more than once (internal implementation detail you should not care about). -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] Abnormal storage consumption with autovacuum enabled
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_pages" to a > value over 237312. Yup, there's your problem (or a huge chunk of it anyway). > Is this measurement reliable? > We are considering to set: max_fsm_pages=40 > Could this have some sort of impact? It will require a slightly larger shared-memory segment than you have now. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Abnormal storage consumption with autovacuum enabled
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 measurement reliable? We are considering to set: max_fsm_pages=40 Could this have some sort of impact? thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] Loader
-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 files like (CSV, TXT) directly to Postgres Tables. > > > > Thanks & Regards > > > > M.AHRAM KHAN > > > > > > > > - Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED] Yahoo . yscrappy Skype: hub.orgICQ . 7615664 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (FreeBSD) iD8DBQFGVpnY4QvfyHIvDvMRAn4JAKCxqkPwcu14To6C9PpUZsmV8u8OnACglYoO o5RxLYeu6gsCHFOIfnBJViM= =caS4 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 6: explain analyze is your friend