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, w

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 " 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 t

[ADMIN] CFEngine policies to set up PostgreSQL

2012-12-26 Thread Ted Zlatanov
Hi, I am interested in writing CFEngine policies to configure PostgreSQL for the Database::Install sketch I maintain (https://github.com/cfengine/design-center/tree/master/sketches/databases/db_install). Currently the setup is just concerned with installing the packages and starting the default s

[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 varyin

[ADMIN] Regarding Migaration from Mysql procedures to Postgresql Functions

2012-12-26 Thread satish kumar
Hello Pgsql, I am Satish Kumar from Trimax India, I have Mysql procedure could you please provide me a solution. How to convert Mysql procedures to Postgresql Functions using migration tools. Regards, Satish Kumar

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 De

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 [email protected]. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

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 output

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, Post

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 ([email protected]) To make changes to your subscript

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 wrote: > Hi. > Your question was: > >>> We want to create a role used by a monitor to check for " 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: [email protected] To: [email protected] CC: pgsql-admin@postg