Re: Need to fix one more glitch in upgrade to -10.2

On 02/18/2018 08:05 AM, Rich Shepard wrote:
> On Sat, 17 Feb 2018, Rich Shepard wrote:
>
>> That's what I was thinking, too. I can remove the 10.2 package, rebuild
>> and re-install it. Run initdb, then, as postgres, read in the .sql file.
>> This is probably the pragmatic thing to do.
>
>   Rather than doing this my reading of the 10.2 initdb pages suggest
> that I
> can remove /var/lib/pgsql/10.2/data/*, leaving an empty data directory
> owned
> by postgres.postgres. Then, as user postgres, I can run initdb with -D
> /full/path/to/data/ and start over. Is this appropriate?

Yes.

>
>   Looking at the backed up .sql file I see roles for databases that were
> removed a long time ago. I'll read the roles section of the 10.2 docs and

They could not have been removed as they are in the file. I am guessing
you are saying they are not in use as far as you know. Just a
warning(from experience), memory is a tricky thing and removing what is
thought to be inactive roles is a quick way to find they are not.

> edit the .sql file to clean those up.
>
>   Since I'm the only user on this host and postgres cluster would
> 'trust' be
> the appropriate method for use in pb_hba.conf; e.g., # "local" is for
> Unix domain socket connections only
> local   all             all                                     trust
> # IPv4 local connections:
> host    all             all             127.0.0.1/32            trust
>
> so I can access my databases from the desktop or portables without a
> password?

So can anyone who knows that postgres role is generally always there. If
you want to do this at least restrict the user field.

>
> Regards,
>
> Rich
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com