Re: PGUSER and initdb

2019-12-11 Thread Adrian Klaver
On 12/11/19 9:06 AM, Tom Lane wrote: Adrian Klaver writes: On 12/11/19 5:18 AM, Олег Самойлов wrote: This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see Section 33.14). https://www.postgresql.org/docs/12/libpq-envars.html PGUSER behav

Re: PGUSER and initdb

2019-12-11 Thread Tom Lane
Adrian Klaver writes: > On 12/11/19 5:18 AM, Олег Самойлов wrote: > This utility, like most other PostgreSQL utilities, also uses the environment > variables supported by libpq (see Section 33.14). > https://www.postgresql.org/docs/12/libpq-envars.html > PGUSER behaves the same as the user connec

Re: PGUSER and initdb

2019-12-11 Thread Adrian Klaver
On 12/11/19 5:18 AM, Олег Самойлов wrote: This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see Section 33.14). " https://www.postgresql.org/docs/12/libpq-envars.html " PGUSER behaves the same as the user connection parameter. " This

Re: PGUSER and initdb

2019-12-11 Thread Олег Самойлов
> This utility, like most other PostgreSQL utilities, also uses the environment > variables supported by libpq (see Section 33.14). > " > > https://www.postgresql.org/docs/12/libpq-envars.html > " > PGUSER behaves the same as the user connection parameter. > " This is don't work with `initdb`

Re: PGUSER and initdb

2019-12-10 Thread Adrian Klaver
On 12/10/19 5:21 AM, Олег Самойлов wrote: PGUSER doesn't work with initdb and pg_ctl initdb. Lets explain, where this can be important. For instance in MacOS the most convenient way to manage PostgresQL is homebrew. To install PostgresQL: brew install postgresql To upgrade: brew upgrade pos

PGUSER and initdb

2019-12-10 Thread Олег Самойлов
PGUSER doesn't work with initdb and pg_ctl initdb. Lets explain, where this can be important. For instance in MacOS the most convenient way to manage PostgresQL is homebrew. To install PostgresQL: brew install postgresql To upgrade: brew upgrade postgresql this will upgrade soft and to upgr