Bug 217964 - pg_activity 1.3.0 not work with Postgresql 9.6.2
Summary: pg_activity 1.3.0 not work with Postgresql 9.6.2
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Many People
Assignee: freebsd-ports-bugs (Nobody)
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-03-20 18:56 UTC by Marcelo Moreira Martins
Modified: 2017-03-21 20:01 UTC (History)
2 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 2017-03-21 19:59:57 UTC
Thanks for the report!
-jgh
Comment 3 commit-hook freebsd_committer 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 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