Bug 217964

Summary: pg_activity 1.3.0 not work with Postgresql 9.6.2
Product: Ports & Packages Reporter: Marcelo Moreira Martins <m3systemmm>
Component: Individual Port(s)Assignee: freebsd-ports-bugs (Nobody) <ports-bugs>
Status: Closed FIXED    
Severity: Affects Many People CC: jgh, w.schwarzenfeld
Priority: ---    
Version: Latest   
Hardware: Any   
OS: Any   

Description Marcelo Moreira Martins 2017-03-20 18:56:06 UTC
Whe I update the PostgreSQL to 9.6.2 the pg_activity 1.3.0 stop to working.

I use the ports to install pg_activity 1.3.0

When a run the pg_activity 1.3.0 the erro came up

M3System-MatrizBSD[root@matrizbsd103 ~]# pg_activity -U postgres
FATAL: column pg_stat_activity.waiting does not exist
LINE 11:         pg_stat_activity.waiting AS wait,
                 ^

Best RegardĀ“s
Marcelo M Martins - SE System Engineer
Comment 1 Walter Schwarzenfeld freebsd_triage 2017-03-21 18:20:17 UTC
found this (fixed in new release):
https://github.com/julmon/pg_activity/releases/tag/v1.3.1
Comment 2 Jason Helfman freebsd_committer freebsd_triage 2017-03-21 19:59:57 UTC
Thanks for the report!
-jgh
Comment 3 commit-hook freebsd_committer freebsd_triage 2017-03-21 20:00:42 UTC
A commit references this bug:

Author: jgh
Date: Tue Mar 21 19:59:40 UTC 2017
New revision: 436632
URL: https://svnweb.freebsd.org/changeset/ports/436632

Log:
  - update to 1.3.1
  - while here regenerated patch file (portlint warning)

  PR:		217964
  Reported by:	Marcelo Moreira Martins <m3systemmm@gmail.com>

Changes:
  head/databases/pg_activity/Makefile
  head/databases/pg_activity/distinfo
  head/databases/pg_activity/files/patch-setup.py
Comment 4 commit-hook freebsd_committer freebsd_triage 2017-03-21 20:01:45 UTC
A commit references this bug:

Author: jgh
Date: Tue Mar 21 20:01:19 UTC 2017
New revision: 436633
URL: https://svnweb.freebsd.org/changeset/ports/436633

Log:
  MFH: r436632

  - update to 1.3.1
  - while here regenerated patch file (portlint warning)

  PR:		217964
  Reported by:	Marcelo Moreira Martins <m3systemmm@gmail.com>

  Approved by:	ports-secteam (with hat)

Changes:
_U  branches/2017Q1/
  branches/2017Q1/databases/pg_activity/Makefile
  branches/2017Q1/databases/pg_activity/distinfo
  branches/2017Q1/databases/pg_activity/files/patch-setup.py