Autocommit with Postgres 10

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

Page: https://www.postgresql.org/docs/10/static/ecpg-sql-set-autocommit.html
Description:

Hi,

I am currently using PG10, and link my C program to the libpq.5.10.so file
for client feature usage.

I get the following error after trying to set auto commit (as I did before)
:

2018-05-03 11:16:50.253 CEST [50141] ERROR:  unrecognized configuration
parameter "autocommit"
2018-05-03 11:16:50.253 CEST [50141] STATEMENT:  SET AUTOCOMMIT TO ON

Could you tell me how to set autocommit to ON with PG 10 client library ?

Thank you


Figures or Diagrams were missing

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

Page: https://www.postgresql.org/docs/7.3/static/arch-pg.html
Description:

Figures or Diagrams  were missing in 7.1 documentation on postgresql system
architecture


Re: Autocommit with Postgres 10

2018-05-03 Thread Craig Ringer
You are reading the documentation for the ECPG programming interface,
not normal SQL or psql.

Please see the manual for psql.
https://www.postgresql.org/docs/current/static/app-psql.html



Re: Request: Revive the security-specific section

2018-05-03 Thread Peter Eisentraut
On 5/2/18 18:59, Ian Maddox wrote:
> Google Cloud Blog recently published a guide on securing DBs in the
> cloud
> 
> and tried to link to your latest docs on hardening Postgres, but all we
> could find is this doc from version 7
> .

That seems of dubious use.  More than half the information on that page
is no longer applicable.

> It appears> that the knowledge from that page has been redistributed
across the
> manual in versions 8+, making it difficult to point to a single
> authoritative resource. I'm writing to request that a single section on
> security be revived in a future revision of the manual.

I see where you are coming from.  However, I think security concerns
exist in every aspect of the system.  So as a user when I'm dealing with
operating system integration, or schema design, or backups, or
replication, or monitoring, etc., then I want to know about the security
concerns on that subject.

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