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,
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
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
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
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:
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
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,
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
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
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:
10 matches
Mail list logo