pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
streaming replication depends on matching glibc versions / LOCALE sort order
6+ messages / 4 participants
[nested] [flat]

* streaming replication depends on matching glibc versions / LOCALE sort order
@ 2023-06-14 15:36 PG Doc comments form <noreply@postgresql.org>
  2023-06-23 12:28 ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Joe Conway <mail@joeconway.com>
  0 siblings, 1 reply; 6+ messages in thread

From: PG Doc comments form @ 2023-06-14 15:36 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org; +Cc: danstoner@gmail.com

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/warm-standby.html
Description:

After suffering a database corruption, I went looking for mention of the
cause or "prevention tips" in the official docs.

tldr; The following section might make a great place to mention the
dependency on identical glibc versions:

https://www.postgresql.org/docs/15/warm-standby.html#STANDBY-PLANNING


There is information in a blog post:

https://postgresql.verite.pro/blog/2018/08/27/glibc-upgrade.html

and some in the wiki:

https://wiki.postgresql.org/wiki/Locale_data_changes

and some talk on the postgresql developer mailing list such as "I have been
expecting to hear about such breakage, and am
surprised we hear about it so rarely."

https://www.postgresql.org/message-id/flat/BA6132ED-1F6B-4A0B-AC22-81278F5AB81E%40tripadvisor.com

In Slack, it seems clear that this is a "well known issue" to some people on
the project, but it continues to burn people in the wild.


This seems important enough that it should be included in the official
docs.

Can I do anything to help get the documentation updated?


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: streaming replication depends on matching glibc versions / LOCALE sort order
  2023-06-14 15:36 streaming replication depends on matching glibc versions / LOCALE sort order PG Doc comments form <noreply@postgresql.org>
@ 2023-06-23 12:28 ` Joe Conway <mail@joeconway.com>
  2023-06-28 01:14   ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Dan Stoner <danstoner@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Joe Conway @ 2023-06-23 12:28 UTC (permalink / raw)
  To: danstoner@gmail.com; pgsql-docs@lists.postgresql.org

On 6/14/23 11:36, PG Doc comments form wrote:
> In Slack, it seems clear that this is a "well known issue" to some people on
> the project, but it continues to burn people in the wild.
> 
> This seems important enough that it should be included in the official
> docs.
> 
> Can I do anything to help get the documentation updated?

Absolutely! If you can suggest which doc sections should be altered and 
proposed wording, that would be a great start.

Bonus points if you send it in as a patch against the corresponding sgml 
files.

Note, I recently gave a talk on the subject -- feel free to get 
examples, etc from the slides:

https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf

I can also help with wordsmithing and committing the changes once we 
have them fully baked.

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: streaming replication depends on matching glibc versions / LOCALE sort order
  2023-06-14 15:36 streaming replication depends on matching glibc versions / LOCALE sort order PG Doc comments form <noreply@postgresql.org>
  2023-06-23 12:28 ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Joe Conway <mail@joeconway.com>
@ 2023-06-28 01:14   ` Dan Stoner <danstoner@gmail.com>
  2023-08-08 19:05     ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Dan Stoner <danstoner@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Dan Stoner @ 2023-06-28 01:14 UTC (permalink / raw)
  To: Joe Conway <mail@joeconway.com>; +Cc: pgsql-docs@lists.postgresql.org

I am interested in doing this but not sure when I will have time.

- Dan Stoner

On Fri, Jun 23, 2023 at 8:28 AM Joe Conway <mail@joeconway.com> wrote:
>
> On 6/14/23 11:36, PG Doc comments form wrote:
> > In Slack, it seems clear that this is a "well known issue" to some people on
> > the project, but it continues to burn people in the wild.
> >
> > This seems important enough that it should be included in the official
> > docs.
> >
> > Can I do anything to help get the documentation updated?
>
> Absolutely! If you can suggest which doc sections should be altered and
> proposed wording, that would be a great start.
>
> Bonus points if you send it in as a patch against the corresponding sgml
> files.
>
> Note, I recently gave a talk on the subject -- feel free to get
> examples, etc from the slides:
>
> https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf
>
> I can also help with wordsmithing and committing the changes once we
> have them fully baked.
>
> --
> Joe Conway
> PostgreSQL Contributors Team
> RDS Open Source Databases
> Amazon Web Services: https://aws.amazon.com
>





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: streaming replication depends on matching glibc versions / LOCALE sort order
  2023-06-14 15:36 streaming replication depends on matching glibc versions / LOCALE sort order PG Doc comments form <noreply@postgresql.org>
  2023-06-23 12:28 ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Joe Conway <mail@joeconway.com>
  2023-06-28 01:14   ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Dan Stoner <danstoner@gmail.com>
@ 2023-08-08 19:05     ` Dan Stoner <danstoner@gmail.com>
  2023-08-08 19:47       ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Joe Conway <mail@joeconway.com>
  2023-08-16 06:11       ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Peter Eisentraut <peter@eisentraut.org>
  0 siblings, 2 replies; 6+ messages in thread

From: Dan Stoner @ 2023-08-08 19:05 UTC (permalink / raw)
  To: Joe Conway <mail@joeconway.com>; +Cc: pgsql-docs@lists.postgresql.org

I'm circling back around to this.

I've cloned the postgresql git repo and started looking thru
doc/src/sgml directory, looking thru the developer FAQ on the wiki,
etc.

For documentation updates such as this, where would I submit the
patch(es)?  Is the process the same as other code commits?

https://wiki.postgresql.org/wiki/Submitting_a_Patch


Thanks,

- Dan Stoner

On Tue, Jun 27, 2023 at 9:14 PM Dan Stoner <danstoner@gmail.com> wrote:
>
> I am interested in doing this but not sure when I will have time.
>
> - Dan Stoner
>
> On Fri, Jun 23, 2023 at 8:28 AM Joe Conway <mail@joeconway.com> wrote:
> >
> > On 6/14/23 11:36, PG Doc comments form wrote:
> > > In Slack, it seems clear that this is a "well known issue" to some people on
> > > the project, but it continues to burn people in the wild.
> > >
> > > This seems important enough that it should be included in the official
> > > docs.
> > >
> > > Can I do anything to help get the documentation updated?
> >
> > Absolutely! If you can suggest which doc sections should be altered and
> > proposed wording, that would be a great start.
> >
> > Bonus points if you send it in as a patch against the corresponding sgml
> > files.
> >
> > Note, I recently gave a talk on the subject -- feel free to get
> > examples, etc from the slides:
> >
> > https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf
> >
> > I can also help with wordsmithing and committing the changes once we
> > have them fully baked.
> >
> > --
> > Joe Conway
> > PostgreSQL Contributors Team
> > RDS Open Source Databases
> > Amazon Web Services: https://aws.amazon.com
> >





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: streaming replication depends on matching glibc versions / LOCALE sort order
  2023-06-14 15:36 streaming replication depends on matching glibc versions / LOCALE sort order PG Doc comments form <noreply@postgresql.org>
  2023-06-23 12:28 ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Joe Conway <mail@joeconway.com>
  2023-06-28 01:14   ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Dan Stoner <danstoner@gmail.com>
  2023-08-08 19:05     ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Dan Stoner <danstoner@gmail.com>
@ 2023-08-08 19:47       ` Joe Conway <mail@joeconway.com>
  1 sibling, 0 replies; 6+ messages in thread

From: Joe Conway @ 2023-08-08 19:47 UTC (permalink / raw)
  To: Dan Stoner <danstoner@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org

On 8/8/23 15:05, Dan Stoner wrote:
> I'm circling back around to this.
> 
> I've cloned the postgresql git repo and started looking thru
> doc/src/sgml directory, looking thru the developer FAQ on the wiki,
> etc.
> 
> For documentation updates such as this, where would I submit the
> patch(es)?  Is the process the same as other code commits?
> 
> https://wiki.postgresql.org/wiki/Submitting_a_Patch


Yes. Basically send a patch 
(https://wiki.postgresql.org/wiki/Creating_Clean_Patches) with your 
changes to the list and register the patch for the next "Open" commitfest:

https://commitfest.postgresql.org/

Currently:

   2023-09 (Open - 2023-09-01 - 2023-09-30)

"Open" means it is open for submission of patches to be considered, and 
the dates (all of September) are the beginning and end of the commitfest 
during which the patch would be reviewed, discussed, and hopefully 
committed. Once the Commitfest is started (2023-09-01) it is no longer 
Open for new submissions (I forget the exact state name, but it is 
In-progress or something similar)

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: streaming replication depends on matching glibc versions / LOCALE sort order
  2023-06-14 15:36 streaming replication depends on matching glibc versions / LOCALE sort order PG Doc comments form <noreply@postgresql.org>
  2023-06-23 12:28 ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Joe Conway <mail@joeconway.com>
  2023-06-28 01:14   ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Dan Stoner <danstoner@gmail.com>
  2023-08-08 19:05     ` Re: streaming replication depends on matching glibc versions / LOCALE sort order Dan Stoner <danstoner@gmail.com>
@ 2023-08-16 06:11       ` Peter Eisentraut <peter@eisentraut.org>
  1 sibling, 0 replies; 6+ messages in thread

From: Peter Eisentraut @ 2023-08-16 06:11 UTC (permalink / raw)
  To: Dan Stoner <danstoner@gmail.com>; Joe Conway <mail@joeconway.com>; +Cc: pgsql-docs@lists.postgresql.org

On 08.08.23 21:05, Dan Stoner wrote:
> I'm circling back around to this.
> 
> I've cloned the postgresql git repo and started looking thru
> doc/src/sgml directory, looking thru the developer FAQ on the wiki,
> etc.

Great!

> For documentation updates such as this, where would I submit the
> patch(es)?  Is the process the same as other code commits?

Either to pgsql-hackers or to pgsql-docs.






^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2023-08-16 06:11 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-14 15:36 streaming replication depends on matching glibc versions / LOCALE sort order PG Doc comments form <noreply@postgresql.org>
2023-06-23 12:28 ` Joe Conway <mail@joeconway.com>
2023-06-28 01:14   ` Dan Stoner <danstoner@gmail.com>
2023-08-08 19:05     ` Dan Stoner <danstoner@gmail.com>
2023-08-08 19:47       ` Joe Conway <mail@joeconway.com>
2023-08-16 06:11       ` Peter Eisentraut <peter@eisentraut.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox