Re: Images in the official documentation

2018-02-23 Thread Peter Eisentraut
On 2/23/18 11:21, Tom Lane wrote:
> In the distant
> past, as I recall, we had a GIF or two; but we abandoned that on the
> grounds that it was unmaintainable and also incompatible with some
> documentation output formats.  I'm not too sure what the state of
> play is on the latter point, now that we've switched to XML.

The complications with the image formats in the past were mainly around
what ((pdf)jade)tex would accept.  The tools have shifted a bit now, and
the zoo formats is a different one.  Nothing that a few make rules
couldn't address, though, I think.

The issue of how to manage the sources is still the same, though.

-- 
Peter Eisentraut  http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



improve man pages build speed

2018-02-23 Thread Peter Eisentraut
The attached patch improves the build speed for the man pages on my
system from about 50 seconds to about 15 seconds.

It looks like the stylesheets are spending a lot of time counting the
links in the man pages so that it can put them into numbered endnotes,
but we don't have anything like that anyway, so we can save a lot of
time by turning this off.  (I suppose we'd have to turn it back on if we
have have content like that, but we've never had anything like that
before, so it doesn't seem particularly pressing.)

-- 
Peter Eisentraut  http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From e3fc5a79c3ec44e0b72db8ab107a611de1a6db73 Mon Sep 17 00:00:00 2001
From: Peter Eisentraut 
Date: Fri, 23 Feb 2018 19:52:30 -0500
Subject: [PATCH] doc: Improve man build speed

Turn off man.endnotes.are.numbered parameter, which we don't need, but
which increases performance vastly if off.  Also turn on
man.output.quietly, which also makes things a bit faster, but which is
also less useful now as a progress indicator because the build is so
fast now.
---
 doc/src/sgml/stylesheet-man.xsl | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/stylesheet-man.xsl b/doc/src/sgml/stylesheet-man.xsl
index e9c407230c..691196525a 100644
--- a/doc/src/sgml/stylesheet-man.xsl
+++ b/doc/src/sgml/stylesheet-man.xsl
@@ -12,11 +12,13 @@
 
 0
 0
+0 
 
 
-
+
 32 
 40 
+
  
 
 

Re: Images in the official documentation

2018-02-23 Thread Tom Lane
Daniel Westermann  writes:
> Is there an agreement not to include that pictures for any reason?

This has been discussed repeatedly (see the archives).  We'd surely
like the ability to include figures, but we've not found any tools that
met the varying requirements people wanted to set --- mainly, that it
be possible to commit readable source text for figures into our git
repo and have updates that were reviewable (ie, didn't amount to a 100%
replacement of one set of gibberish with another one).  In the distant
past, as I recall, we had a GIF or two; but we abandoned that on the
grounds that it was unmaintainable and also incompatible with some
documentation output formats.  I'm not too sure what the state of
play is on the latter point, now that we've switched to XML.

regards, tom lane



Images in the official documentation

2018-02-23 Thread Daniel Westermann
Hi %, 

I am working with PostgreSQL documentation quite a few years now and I am 
almost happy. What I think is completely missing (especially if you compare to 
commercial product documentation) are pictures that illustrate a topic, e.g. 
the relation of instance->database->user/role->schema->objects. 

Is there an agreement not to include that pictures for any reason? I can not 
promise that I find time for that in the near future but if that will be 
appreciated I am willing to spend time on that to make the documentation even 
better. 

Regards 
Daniel 


Re: pg_hba_file_rules permission issue

2018-02-23 Thread Joby John
Ok, thank you very much Michael

Joby

On 23 Feb 2018 2:09 pm, "Michael Paquier"  wrote:

> On Fri, Feb 23, 2018 at 09:41:27AM +, PG Doc comments form wrote:
> > According to the documentation, I assume normal users will be able to
> view
> > pg_hba_file_rules once they are granted select privileges. But for the
> > privileged user it's giving following error while trying to view records:
> >
> > ERROR:  permission denied for function pg_hba_file_rules
> > SQL state: 42501
>
> I think that you need as well execution rights on pg_hba_file_rules() to
> give access to it.
> --
> Michael
>


Re: pg_hba_file_rules permission issue

2018-02-23 Thread Michael Paquier
On Fri, Feb 23, 2018 at 09:41:27AM +, PG Doc comments form wrote:
> According to the documentation, I assume normal users will be able to view
> pg_hba_file_rules once they are granted select privileges. But for the
> privileged user it's giving following error while trying to view records:
> 
> ERROR:  permission denied for function pg_hba_file_rules
> SQL state: 42501

I think that you need as well execution rights on pg_hba_file_rules() to
give access to it.
--
Michael


signature.asc
Description: PGP signature


pg_hba_file_rules permission issue

2018-02-23 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/view-pg-hba-file-rules.html
Description:

Hi,

According to the documentation, I assume normal users will be able to view
pg_hba_file_rules once they are granted select privileges. But for the
privileged user it's giving following error while trying to view records:

ERROR:  permission denied for function pg_hba_file_rules
SQL state: 42501

Thanks,
Joby