Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-16 Thread Michael Paquier
On Fri, Jul 14, 2017 at 9:11 PM, Jeff Janes wrote: > On Thu, Jul 13, 2017 at 10:38 AM, Michael Paquier > wrote: >> >> On Thu, Jul 13, 2017 at 7:23 PM, Jeff Janes wrote: >> > >> > I think that pg_stat_wal_receiver should be crossreferenced in >> > https://www.postgresql.org/docs/9.6/static/hot-st

Re: [GENERAL] Failed DNF dependency in Fedora

2017-07-16 Thread Devrim Gündüz
Hi Clodoaldo, On Sat, 2017-07-15 at 08:38 -0300, Clodoaldo Neto wrote: > While installing Psycopg2 for Python2 in Fedora 26 having Postgresql 9.6: > > # dnf install python-psycopg2 > Last metadata expiration check: 0:01:52 ago on Sat 15 Jul 2017 08:30:26 AM > -03. > Error: > Problem: conflictin

Re: [GENERAL] How to drop column from interrelated views

2017-07-16 Thread Karsten Hilbert
On Sat, Jul 08, 2017 at 03:18:39PM -0700, Guyren Howe wrote: > I’ve a set of interrelated views. I want to drop a column from a table and > from all the views that cascade from it. > > I’ve gone to the leaf dependencies and removed the field from them. But I > can’t remove the field from the in