Talk:PostgreSQL/QuickStart

From Gentoo Wiki
Jump to:navigation Jump to:search
Note
This is a Talk page - please see the documentation about using talk pages. Add newer comments below older ones, sign comments using four tildes (~~~~), and indent successive comments with colons (:). Add new sections at the bottom of the page, under a heading (== ==). Please remember to mark sections as "open for discussion" using {{talk|open}}, so they will show up in the list of open discussions.

Troubleshooting section

Talk status
This discussion is still ongoing.

Most of the problems here are very old and relate to ebuilds for very old and unsupported versions.

  • Missing config files in /etc/postgresql-9.x and /var/lib/postgresql/9.x/data
  • "ERROR: timezone directory stack overflow" or "FATAL: too many private dirs demanded

The problem Server lacks instrumentation functions only related to pgadmin.

I would remove that. --Anfr (talk) 15:02, 21 December 2023 (UTC)

10 bata's are out

Talk status
This discussion is done.

Any news here about new settings? — The preceding unsigned comment was added by Bw (talkcontribs)

Not any that need to be mentioned in this guide. --TitanOfOld (talk) 10:09, 29 August 2017 (UTC)

8.x is long dead

Talk status
This discussion is done.

Is there any reason to keep reference to 8.4 upgrade over 6 months after it is EOL and out of tree?

Petteyg (talk) 21:47, 7 February 2015 (UTC)

Some companies are not as timely about updating their servers or services as we would like. Further, that this page references any version that is not the latest and greatest does not negate it's usefulness. While we could update the slots or versions, it's hardly a useful change and just makes more work for the translators. --TitanOfOld (talk) 20:36, 17 February 2015 (UTC)

updates toward systemd

Talk status
This discussion is done as of 15 July 2022.

regarding: PostgreSQL/QuickStart#Give_It_a_Go.21

I think it should point to using systemd as it seems to be default on new installs.

I've used this systemd service descriptor template: [1]

the command would then be

sudo systemctl start postgresql-9.0

— Preceding unsigned comment added by Gauthier (talkcontribs)

No, the default is OpenRC. systemd is an option, but I have no confidence in the files used by systemd. I do not recommend using systemd to anyone. --TitanOfOld (talk) 13:03, 9 May 2014 (UTC)
As the default is still OpenRC, and the article explains at the end how to use PostgreSQL with systemd (PostgreSQL/QuickStart#Systemd), this discussion can be closed. --Blacki (talk) 00:37, 15 July 2022 (UTC)

changing USE Flags table

Talk status
This discussion is done as of 2022-08-02.

I saw that gentoo wiki is currently recommend to use USEFlags template, but this document contains USE Flags table which is written by hand. so my having question is "is it just better to change current USEFlags table?"

Korean translation has applied latest template temporarily (and there contents in template seems to have lacked something). -- Darkcircle (talk) 19:30, 14 February 2016 (UTC)

The USEflags template is now implemented in every article. If there are translations still out of sync, please since them with the latest English base. I will be sure to mark the article for translation. This discussion can now be closed. --Maffblaster (talk) 22:22, 2 August 2022 (UTC)

Reference to pgAdmin 4

Talk status
This discussion is done.

Section 6 (Utilities) refers pgAdmin III. There is already pgAdmin 4 available for some time so maybe it should be mentioned? — The preceding unsigned comment was added by Blubber (talkcontribs)

I'm just has removed III :) --Cronolio (talk) 21:51, 30 August 2018 (UTC)

Versions selected for migration examples could be more helpful

Talk status
This discussion is done as of 2022-08-02.

"There are only two reasons you would need to perform a migration: When moving from one major version to another, e.g. , from PostgreSQL 8.4.7 to 9.0.3, but not from 9.0.2 to 9.0.3" - these examples makes it clear that a major version upgrade requires a migration and a patch level upgrade does not, but they do not illustrate the same for a minor version upgrade. — The preceding unsigned comment was added by Mikenerone (talkcontribs)

Technically, it does illustrate the minor version. The major versions prior to 10 was express as X.Y, for some number X and Y. Then, the last digit is the minor version, X.Y.Z for some number Z. They've never had a patch number. This is explained under the heading "About the Ebuilds", and also directs the reader to read the versioning policy from PostgreSQL. --TitanOfOld (talk) 00:50, 20 October 2018 (UTC)
If there is any issue with the documentation please kindly add whatever clarity is necessary. Thank you! --Maffblaster (talk) 22:23, 2 August 2022 (UTC)