Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Rob Sargent
Has that ever been a thing? Quoting (and trimming) the message you are replying to has been normal since at least the late 1980's (when I started to use E-Mail). Peter, My memory of email spans only a slightly larger period but no doubt yours is better than mine.  My main reader was emac's

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Bruce Momjian
On Mon, Jan 18, 2021 at 03:13:13PM -0600, Ron wrote: > On 1/18/21 2:58 PM, Bruce Momjian wrote: > > On Mon, Jan 18, 2021 at 09:53:33PM +0100, W.P. wrote: > [snip] > > > Ok, so "step-by-step": > > > 1), I copy / move "somewhere" OLD DB files (*/pgsql/data/* for -d option), > > > 2). Do initdb /

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread David G. Johnston
On Mon, Jan 18, 2021 at 2:13 PM Ron wrote: > The documents tend to assume the reader thoroughly knows Postgresql, and > that's manifestly Not True. > Maybe not, but users are still expected to read the documentation. If there remains questions or concerns after doing so then by asking such

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Ron
On 1/18/21 2:58 PM, Bruce Momjian wrote: On Mon, Jan 18, 2021 at 09:53:33PM +0100, W.P. wrote: [snip] Ok, so "step-by-step": 1), I copy / move "somewhere" OLD DB files (*/pgsql/data/* for -d option), 2). Do initdb / postgresql-10-setup to create NEW empty base (in /var/lib/pgsql/ or

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Bruce Momjian
On Mon, Jan 18, 2021 at 09:53:33PM +0100, W.P. wrote: > W dniu 18.01.2021 o 17:19, Laurenz Albe pisze: > > On Mon, 2021-01-18 at 05:33 +0100, W.P. wrote: > > > For 9.5 to 9.6 transition, it worked like charm. (except some problems > > > with parsing json data in a view, but this I will address

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread W.P.
W dniu 18.01.2021 o 17:19, Laurenz Albe pisze: On Mon, 2021-01-18 at 05:33 +0100, W.P. wrote: For 9.5 to 9.6 transition, it worked like charm. (except some problems with parsing json data in a view, but this I will address later, after upgrade to final version - Fedora 30, probably PG 10.x).

Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Matthias Apitz
On Mon, 18 Jan 2021 18:05:34 +0100, Paul Förster wrote: > Hi Peter, > >> On 18. Jan, 2021, at 17:34, Peter J. Holzer wrote: >> >> In 1990, MIME didn't exist. E-Mail was by definition US-ASCII text >> (except for uuencode or by private arrangement). People often used text >> terminals and may not

Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Paul Förster
Hi Peter, > On 18. Jan, 2021, at 17:34, Peter J. Holzer wrote: > > In 1990, MIME didn't exist. E-Mail was by definition US-ASCII text > (except for uuencode or by private arrangement). People often used text > terminals and may not have any Internet access. yes, those were the days! :-) As for

Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Tom Lane
"Peter J. Holzer" writes: > On 2021-01-17 21:25:29 +0100, Matthias Apitz wrote: >> If someone needs really an image to show a problem, it can be put on >> some server and the link could be posted, like this one showing a PANIC >> of a system http://www.unixarea.de/fbsd-panic-20210110.jpg > That

Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Peter J. Holzer
On 2021-01-17 21:25:29 +0100, Matthias Apitz wrote: > El día domingo, enero 17, 2021 a las 12:23:23p. m. -0700, David G. Johnston > escribió: > > > Its 2021; > > Yes, and for what this argument is good for? Is 2021 better than 2020 or > even worth? It's not about being better, but about what

Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Laurenz Albe
On Sat, 2021-01-16 at 18:22 +1100, Tim Cross wrote: > Hemil Ruparel writes: > > Exactly my point. We need to raise the bar of the behavior we tolerate. > > This should not be tolerated. We need to set an example. The person in > > question clearly understood english and I have never seen a person

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Laurenz Albe
On Mon, 2021-01-18 at 05:33 +0100, W.P. wrote: > For 9.5 to 9.6 transition, it worked like charm. (except some problems > with parsing json data in a view, but this I will address later, after > upgrade to final version - Fedora 30, probably PG 10.x). > > Now I have problem with 9.6 -> 10.7

Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Peter J. Holzer
On 2021-01-17 11:11:01 -0800, Adrian Klaver wrote: > On 1/17/21 11:04 AM, Matthias Apitz wrote: > > > Always reply-to-all. > > > > Why? Why I (and other subscribers) have to have the same mail twice in > > the mbox? > > You can prevent that by going here: > >

Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Peter J. Holzer
On 2021-01-17 11:23:37 +0100, Thiemo Kellner wrote: > > Also, could it be possible to make messages plain text? I see a lot of > > varying fancy fonts and I hate that. I even hate it more when people > > post messages not properly trimmed or messages that need formatting > > preserved such as

Re: Parallelism on Partitioning .

2021-01-18 Thread Thomas Markus
Hi Hi , We are trying to assign the parallel worker or execute the query in parallel manner on partitioned Tables and partitioned master table but not able to do that ,could u plz suggest . Current Postgresql version :- 9.6 Fyi, We have tried with all parameters which can allow the

Parallelism on Partitioning .

2021-01-18 Thread Brajendra Pratap Singh
Hi , We are trying to assign the parallel worker or execute the query in parallel manner on partitioned Tables and partitioned master table but not able to do that ,could u plz suggest . Current Postgresql version :- 9.6 Fyi, We have tried with all parameters which can allow the parallel query

Designing a better connection pool for psycopg3

2021-01-18 Thread Daniele Varrazzo
Hello, I've been gathering a few ideas about the connection pool I would like to provide with psycopg3. I would be happy if you would like to take a look and give some feedback. https://www.psycopg.org/articles/2021/01/17/pool-design/ Thank you very much, -- Daniele

Re: Do we need a way to moderate mailing lists?

2021-01-18 Thread Peter J. Holzer
On 2021-01-16 14:01:44 -0700, Rob Sargent wrote: > Mail has always been well threaded, retaining which message lead to which > replies.  How did we get away from relying on that (naked posting)? Has that ever been a thing? Quoting (and trimming) the message you are replying to has been normal

Re: System (and DB) upgrade problem., "part 2"

2021-01-18 Thread Peter J. Holzer
On 2021-01-18 05:33:05 +0100, W.P. wrote: > Now I have problem with 9.6 -> 10.7 (Fedora 27 -> 28) upgrade. > As expected after system upgrade, database fails to start "files > incompatible with binaries". > > Found pg_upgrade, command line options "-b /usr/lib/pgsql/postgresql-9.6/bin > -B

Re: Is it possible to compare a long text string and fuzzy match only phrases contained in?

2021-01-18 Thread Tim Clarke
On 17/01/2021 23:09, Benedict Holland wrote: You want to do NLP in postgres? I would say that you would need a tool like opennlp to get your tokens and phases, then run a fuzzy matching algorithm. Unless postgres has nlp capabilities but I am not sure I would use them. You actually want