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.klaver@aklaver.com