Re: GSoD - a patch for Getting Started tutorial - Mailing list pgsql-docs
| From | Liudmila Mantrova |
|---|---|
| Subject | Re: GSoD - a patch for Getting Started tutorial |
| Date | |
| Msg-id | CAEkD-mB2E90p_hH4qSkxqMQ1KDA_owy3zHz_V3zcwAxZVRKwDA@mail.gmail.com Whole thread Raw |
| In response to | Re: GSoD - a patch for Getting Started tutorial (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Responses |
Re: GSoD - a patch for Getting Started tutorial
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: GSoD - a patch for Getting Started tutorial (Laurenz Albe <laurenz.albe@cybertec.at>) |
| List | pgsql-docs |
On Tue, Nov 19, 2019 at 11:00 AM Laurenz Albe <laurenz.albe@cybertec.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@localhost ~]# /usr/pgsql-12/bin/postgresql-12-setup initdb
Initializing database ... OK
# 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@localhost ~]# /usr/pgsql-12/bin/postgresql-12-setup initdb
Initializing database ... OK
...
[root@localhost ~]# grep '^local' /var/lib/pgsql/12/data/pg_hba.conf
local all all peer
local replication all peer
[root@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
pgsql-docs by date: