I'm seeing connection hang issue these days. many concurrent
connections are hanging on db. They basically do the same thing:
update different rows in same table. The sql itself should run very
fast as it's updating just one row based on an unique key. I though
it might b
No one has responded to my questions. I am wondering if anyone can point me to
where in postgresql source code I can further look into the issue and explore
the possibility of this change? Thanks.
Sent: Thursday, December 15, 2011 4:53 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] User pas
On Monday 19 December 2011 17:15:49 Scott Toland wrote:
> the problem is the old schema was
> an ASCII neutral zone, and the new server has the schema set for UTF-8
You have to convert the Dump:
http://blog.endpoint.com/2011/12/sanitizing-supposed-utf-8-data.html
HTH, Jens
--
Sent via pgsql-ad
Hi folks.
I've been struggling a while with 9.1.2 pg_upgrade on Ubuntu 10.04.3,
but I can't find a way out so I've subscribed to this ML, I hope it's
the right place.
So, I've got an 8.4 (Ubuntu packaged) postgresql cluster that needs to
be upgraded to 9.1
I can't use the Ubuntu packaged v
On 12/19/2011 01:04 PM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
This feature is close to commit as a new one for PostgreSQL 9.2:
http://archives.postgresql.org/message-id/4eeb3a2b.8090...@2ndquadrant.com
http://archives.postg
On 12/19/2011 07:46 PM, Craig James wrote:
> Backend Postgres processes run as the Postgres user, so they have
> permission to kill each other. You write an add-on function that just
> kills a process:
>
> select my_kill_backend(pid);
>
> Naturally, this is very dangerous. There are all sorts
