Re: [ADMIN] create role?

2012-12-26 Thread Gary Stainburn
On Thursday 20 December 2012 18:30:24 Ray Stell wrote: I'm not really that lazy, I was just stuck in the oracle world view (grant priv to user). Your search strings don't fit in that logic. It looks like sys privs are never provided by grant, rather create or alter. Hmm, sans CONNECT,

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-26 Thread ynux
Hi. Your question was: We want to create a role used by a monitor to check for IDLE in Transaction with the most restrictive permissions we can on a 8.4.13 instance. The user has been granted connect privilege to the database and some limited permissions to user tabhles that need to be

[ADMIN] Simple Query Very Slow

2012-12-26 Thread Jose Martinez
Hello, I have the following table and indices defined: CREATE TABLE ticket ( wid bigint NOT NULL DEFAULT nextval('tickets_id_seq'::regclass), eid bigint, created timestamp with time zone NOT NULL DEFAULT now(), status integer NOT NULL DEFAULT 0, argsxml text, moduleid character

Re: [ADMIN] Setting up High Availability Group of PostgreSQL instances using RedHat Cluster Suite

2012-12-26 Thread Terry Khatri
Hey Devrim Thanks for your reply, I did some googling since my last post and finally configured the pg cluster with RedHat the way I wanted it works so well and we amazed, the link that you sent to your guide helped a lot too. Again thank you very much for your assistance. Regards Terry On 25

Re: [ADMIN] CFEngine policies to set up PostgreSQL

2012-12-26 Thread jmriera
Estaré fuera de la oficina hasta el Miércoles 02/01/2013, para cualquier asunto urgente contactar con Miguel Pérez al correo mpe...@viajesurbis.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

Re: [ADMIN] [GENERAL] Simple Query Very Slow

2012-12-26 Thread Jose Martinez
Thanks for your responses. Sorry, I forgot to mention that the query actually takes 46 seconds despite what analyze (I dont quite understand the output of explain). We did perform a vacuum last Friday and it seems to help but not too much. We'll also try to recreate the indices. Here's the

Re: [ADMIN] [GENERAL] Simple Query Very Slow

2012-12-26 Thread Spike Grobstein
Hi Jose, How much ram is in the server? Can you also post the following values from postgres config: work_mem shared_buffers Frequently when those are incorrectly configured, it can lead to significant performance issues (like 40 second queries that should be sub-second). Out of the box,

Re: [ADMIN] Regarding Migaration from Mysql procedures to Postgresql Functions

2012-12-26 Thread Kevin Grittner
satish kumar wrote: How to convert Mysql procedures to Postgresql Functions using migration tools. http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-26 Thread Robert Treat
On Fri, Dec 21, 2012 at 8:12 AM, ynux y...@gmx.net wrote: Hi. Your question was: We want to create a role used by a monitor to check for IDLE in Transaction with the most restrictive permissions we can on a 8.4.13 instance. The user has been granted connect privilege to the database and

Re: [ADMIN] log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf

2012-12-26 Thread Kong Man
So, LifeKeeper default setting of LKPGSQLDEBUG=5 on /etc/default/LifeKeeper was the culprit for this issue, probably by starting postmaster with -d5 option. Thank you for pointing us to the right direction. -Kong From: kong_mansatian...@hotmail.com To: t...@sss.pgh.pa.us CC: