SET ROLE documentation not entirely correct

2019-04-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-set-role.html Description: In the course of trying to sanitise our roles and permissions I found the notes in the SET ROLE docs a little misleading: "If the session user role has the

Re: Update section on NFS

2019-04-23 Thread Tom Lane
Peter Eisentraut writes: > On 2019-04-23 16:15, Joe Conway wrote: >> I don't think so. Not sure if you have an account at Red Hat, but this >> ticket covers it: >> https://access.redhat.com/solutions/48199 > That discusses the equally-named export options on the NFS server, not > the mount option

Re: Update section on NFS

2019-04-23 Thread Peter Eisentraut
On 2019-04-23 16:15, Joe Conway wrote: > On 4/23/19 9:47 AM, Peter Eisentraut wrote: >> On 2019-04-23 14:31, Joe Conway wrote: >>> Looks like you dropped the advice WRT the asynchronous mount option. >>> Isn't that is still relevant? >> >> I don't think that advice was correct. An async mounted NF

Re: Update section on NFS

2019-04-23 Thread Joe Conway
On 4/23/19 9:47 AM, Peter Eisentraut wrote: > On 2019-04-23 14:31, Joe Conway wrote: >> Looks like you dropped the advice WRT the asynchronous mount option. >> Isn't that is still relevant? > > I don't think that advice was correct. An async mounted NFS file system > will flush data on fsync, whi

Re: Update section on NFS

2019-04-23 Thread Peter Eisentraut
On 2019-04-23 14:31, Joe Conway wrote: > Looks like you dropped the advice WRT the asynchronous mount option. > Isn't that is still relevant? I don't think that advice was correct. An async mounted NFS file system will flush data on fsync, which is what one wants. -- Peter Eisentraut

Re: Update section on NFS

2019-04-23 Thread Peter Eisentraut
On 2019-04-23 13:00, Martín Marqués wrote: > Didn''t read the proposed patch, but would like to point out that I > would also add that it has to be mounted without file attribute caching. Why? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remo

Re: Update section on NFS

2019-04-23 Thread Joe Conway
On 4/23/19 6:10 AM, Peter Eisentraut wrote: > Attached is a patch that rewrites the section on NFS. The old section > was ancient and didn't seem very helpful. > > AFAIK, the only strict requirement for using NFS with PostgreSQL is the > hard mount. Anything else we should mention? > > I also r

Re: Update section on NFS

2019-04-23 Thread Martín Marqués
El 23/4/19 a las 07:10, Peter Eisentraut escribió: > Attached is a patch that rewrites the section on NFS. The old section > was ancient and didn't seem very helpful. > > AFAIK, the only strict requirement for using NFS with PostgreSQL is the > hard mount. Anything else we should mention? Didn'

Update section on NFS

2019-04-23 Thread Peter Eisentraut
Attached is a patch that rewrites the section on NFS. The old section was ancient and didn't seem very helpful. AFAIK, the only strict requirement for using NFS with PostgreSQL is the hard mount. Anything else we should mention? I also reorganized the sectioning so that information about other