PGUSER and initdb

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: PGUSER and initdb
Date: 2019-12-10 13:21:46
Message-ID: FC8A3161-2401-4786-B3BF-35F1422EE4CE@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 upgrade DB

brew postgresql-upgrade-database

The later command do: install previous version of PostgresQL, move postgresql dir to postgesql.old, run pg_upgrade and so on. Convenient.

But this command don't have option to define name of superuser. The only variant to set name off superuser is to use PGUSER environment variable. But PGUSER understand only pg_upgrade, but not initdb.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Олег Самойлов 2019-12-10 13:27:44 PostgreSQL vs PostgresQL
Previous Message Олег Самойлов 2019-12-10 12:53:31 tcp keep alive don't work when the backend is busy