[GENERAL] 9.3 migration issue

I am in the process of migrating several PostgreSQL databases from a 32-bit V9.1.4 environment to a 64-bit V9.3 environment. I have used pg_dump and pg_restore (or postgis_restore.pl) as required by the combination of version and word size migration and the results have been (superficially) go

Re: [GENERAL] pg advisory locks

Also I noticed that executing the following query: SELECT * FROM ( SELECT DISTINCT age(now(), query_start) AS age, pg_stat_activity.pid,pg_locks.granted,pg_stat_activity.application_name,pg_stat_activity.backend_start, pg_stat_activity.xact_start, pg_stat_activity.state_change, pg_stat_activ

[GENERAL] pg advisory locks

Hi, I am executing pg_advisory_locks using the following set of statements: SELECT pg_advisory_lock(317,2); UPDATE posts SET dislikers = array_remove(dislikers, 7) WHERE id = 317; update posts set num_dislikes = icount(dislikers), updated_at = now() where id = 317; WITH update_likers AS (SELE