Re: Small correction in chown command to set the owner of the pgsql data dir correctly

"David G. Johnston" writes: > On Saturday, February 6, 2021, PG Doc comments form > wrote: >> "root# mkdir /usr/local/pgsql >> root# chown postgres /usr/local/pgsql >> root# su postgres >> postgres$ initdb -D /usr/local/pgsql/data" >> If these steps are followed then it still fails to initialize

Re: Small correction in chown command to set the owner of the pgsql data dir correctly

On Saturday, February 6, 2021, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/creating-cluster.html > Description: > > "root# mkdir /usr/local/pgsql > root# chown postgres /usr/local/pgsql > root# su p

Re: The synopsis of "ALTER DEFAULT PRIVILEGES" statement is too difficult to understand

> Maybe it'd help to split the GRANT and REVOKE cases completely, > along the lines of > ALTER DEFAULT PRIVILEGES > [ FOR { ROLE | USER } target_role [, ...] ] > [ IN SCHEMA schema_name [, ...] ] > GRANT privilege_and_object_type > TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH

Small correction in chown command to set the owner of the pgsql data dir correctly

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/creating-cluster.html Description: "root# mkdir /usr/local/pgsql root# chown postgres /usr/local/pgsql root# su postgres postgres$ initdb -D /usr/local/pgsql/data" If these steps are follo