Re: GSoD - a patch for Getting Started tutorial

On Tue, Nov 19, 2019 at 11:00 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Mon, 2019-11-18 at 23:35 +0300, Liudmila Mantrova wrote:
> > > I am a bit uncomfortable about having details about the workings of
> > > binary packages for specific operating systems in the core
> documentation.
> > > Maybe I'm too sensitive there, but what about having these parts in
> the Wiki
> > > and linking there from the tutorial?
> >
> > I also had my doubts about it, but since we are only talking about PGDG
> packages that
> > the community supports, it's probably OK to have it in docs? Besides, I
> believe we
> > should be consistent here - if we are hand-holding the user through the
> source install,
> > we should have a description for binary install as well (which is even
> more useful for novices).
> > I also think it makes the tutorial self-contained, which seems to
> address one of the
> > concerns raised in the presentation you are referring to.
>
> Perhaps you are right, but I wonder if following a link into the Wiki
> would be a great hurdle for the novice.
> I personally thought that a lot of the complaints in the presentation
> were ridiculous, so we need not follow its recommendations slavishly.
>

i'm all for linking to the download page for the exact install commands
(which I did), but i see no harm in mentioning e.g. install/data
directories in documentation. It is something I myself went back to when
working on this tutorial update, so I believe the user will do too. But
let's hope we'll hear other opinions as well before I go and rework it all.

> > > Quickly skimming over the text, I have two things to comment:
> > > - The RedHat binaries use "trust" authentication by default, not
> "peer".
> >
> > Do you mean PGDG binaries or any other binaries? For a PGDG install on
> e.g. RHEL 8,
> > peer seems to be the default.
> > But now that you mentioned it, I realized that trust is the default for
> > source installs and it might be worth adding, too. I'll try to tweak
> this part again.
>
> The binaries for Fedora Linux use "trust".
>

Fedora 31 seems to be using peer. What am I missing?

# dnf install postgresql12-server
Last metadata expiration check: 0:03:09 ago on Tue Nov 19 13:11:43 2019.
Dependencies resolved.
========================================================================================================================
Package Architecture Version
Repository Size
========================================================================================================================
Installing:
postgresql12-server x86_64 12.1-1PGDG.f31
pgdg12 5.1 M
Installing dependencies:
postgresql12 x86_64 12.1-1PGDG.f31
pgdg12 1.5 M
postgresql12-libs x86_64 12.1-1PGDG.f31
pgdg12 419 k

Transaction Summary
========================================================================================================================
Install 3 Packages

[root(at)localhost ~]# /usr/pgsql-12/bin/postgresql-12-setup initdb
Initializing database ... OK
...
[root(at)localhost ~]# grep '^local' /var/lib/pgsql/12/data/pg_hba.conf
local all all peer
local replication all peer

> I think that the source installation is covered well enough.
>
> > > - I couldn't see anything about Windows.
> > > I think that particularly on Windows people would need a tutorial
> most,
> > > not because Windows people are more clueless, but because things work
> > > differently there. Many Windows users don't know how to start a
> shell.
> >
> > I think we can extend it with Windows specifics if there are no other
> major concerns.
> > (But it'll probably take some time for me to try it and figure out the
> differences.
> > Although I know how to start a shell, I'm sure I'll face other problems.
> :))
>
> I understand your reluctance.
> But if we want to cater for clueless beginners, we cannot omit Windows.
>

I wouldn't call it reluctance, it'll just take some time to figure out as
I'm not a PostgreSQL user myself. Btw, I'll also appreciate your input if
you have anything specific in mind about the differences we need to cover.
Do I get it right that you suggest adding info on EDB installer to our
docs?

>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
--
Best regards,
Liudmila Mantrova

Technical writer at Postgres Professional: http://www.postgrespro.com