Re: Upgrading using pg_dumpall

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading using pg_dumpall
Date: 2016-09-04 16:43:47
Message-ID: alpine.LNX.2.11.1609040941070.21663@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 4 Sep 2016, Adrian Klaver wrote:

> -W is not referring to the OS user but the database superuser. Now in your
> case they have the same name, postgres. The settings in /etc/passwd are
> not relevant to what -W is doing. -W is referring to user information
> being stored in the cluster in the system tables pg_user and pg_shadow:
>
> https://www.postgresql.org/docs/9.5/static/catalogs.html

I see the pg_user in Section 49.79 but don't know how to correctly
configure it. It seems that pg_shadow is unnecessary since I don't need to
provide compatibility with versions < 8.1.

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2016-09-04 16:52:38 Re: Upgrading using pg_dumpall [FIXED]
Previous Message Rich Shepard 2016-09-04 16:38:36 Re: Upgrading using pg_dumpall [FIXED]