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-standby.html, near the
>> > same
>> > place which it crossreferences table 9-79.  That would make it more
>> > discoverable.
>>
>> Hm. Hot standby may not involve streaming replication. What about a
>> paragraph here instead?
>>
>> https://www.postgresql.org/docs/devel/static/warm-standby.html#streaming-replication
>>
>> In the monitoring subsection, we could tell that on a standby the WAL
>> receiver status can be retrieved from this view when changes are
>> streamed. What do you think?
>
>
> That works for me.

What do you think about the patch attached?

 
  You can retrieve a list of WAL sender processes via the
- 
+ 
  pg_stat_replication view. Large differences between
In the previous paragraph I have noticed that the link reference is
incorrect. pg_stat_replication is listed under
monitoring-stats-dynamic-views-table.
-- 
Michael


walreceiver-doc.patch
Description: Binary data

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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: conflicting requests
>   - nothing provides postgresql94-libs needed by
> python-psycopg2-2.7.1-1.f26.x86_64
> 
> Psycopg2 for Python3 installs cleanly.

Ouch. I just replaced the packages in the repo. They will sync in next 45 mins.
 Can you please try again, after cleaning the metadata?

dnf clean metadata
dnf install python-psycopg2

Thanks!

Regards,

-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

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 intermediate views because Postgres doesn’t 
> appear to be clever enough to see that the leafs no longer depend on the 
> column. Or did I just miss one?
> 
> In general, this seems like a major weakness expressing a model in Postgres 
> (I get that any such weakness derives from SQL; that doesn’t stop me wanting 
> a solution).

Not that it helps much with your immediate problem but this
is typically the point where one realizes that database
definitions should live under version control.

That doesn't enable easy dropping of a column from
interrelated views but does allow for more convenient ways of
writing the required DDL change script.

Regards,
Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general