Re: Upgrading using pg_dumpall

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

On Sun, 4 Sep 2016, Adrian Klaver wrote:

> The above is not possible. If the postmaster was not running there would be
> no rejection error.

Adrian,

Yes. I conflated when the postmaster was running -- using the 9.3.4 server
-- and now when it's not running. Now I'm wondering if I mistakenly used the
-W option to initdb which requires password use for access.

> Don't do that, you will end up right back at this point again. Find the
> pg_hba.conf files for your 9.5 cluster and your 9.3 cluster and post them
> here.

OK. But when I used 'diff -y' I saw only a paragraph of comments as
different. I'll try attaching them; they're ~100 lines each. If the
attachments are stripped off my the mlm I'll list them within the message
body.

Rich

Attachment Content-Type Size
934-pg_hba.conf text/plain 4.5 KB
954-pg_hba.conf text/plain 4.2 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2016-09-04 14:08:18 Re: Upgrading using pg_dumpall
Previous Message Adrian Klaver 2016-09-04 13:51:33 Re: Upgrading using pg_dumpall