Re: System (and DB) upgrade problem., "part 2"
W dniu 13.01.2021 o 12:28, Laurenz Albe pisze: On Wed, 2021-01-13 at 07:41 +0100, W.P. wrote: I am upgrading Fedora 24 to (now) 26, PostgreSQL stopped starting (as expected), the message from systemctl was to do "postgresql-setup --upgrade". Did installed the tool, loaunched. But it fails with (attached logs) messages, I am missing some libraries, what should I install? The logs complain about missing the "dblink" library, so you forgot to install the -contrib package. Remember to REINDEX all indexes on string columns, because the collations may have changed. Yours, Laurenz Albe 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 (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 /usr/bin -d /var/lib/pgsql/data/" BUT what should I put for option -D? ("new cluster data") Was (directory) already created for me (during system upgrade), or have I to create it somewhere (where? is best practice). There are NO logs for today trial to start in /var/lib/pgsql/data/pg_log/. Where they could be? Laurent
Re: Is it possible to compare a long text string and fuzzy match only phrases contained in?
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 something fairly complex. Thanks, Ben On Sun, Jan 17, 2021, 4:55 PM Shaozhong SHI wrote: > We are looking for working examples of comparing a long text string and > fuzzy-matching multiple words (namely, phrases) contained in. > > Any such work examples? > > Regards, > > David >
Is it possible to compare a long text string and fuzzy match only phrases contained in?
We are looking for working examples of comparing a long text string and fuzzy-matching multiple words (namely, phrases) contained in. Any such work examples? Regards, David
Re: Do we need a way to moderate mailing lists?
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? > if an image is useful for the topic at hand (say designing a > system and having a diagram showing that design) then that image should be > allowed. 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 > It's useful to be able to see who is involved in the discussion by looking > at the recipients and being able to know which of the hundreds of -general > threads that hit my inbox I actually replied to in the past and thus can > filter them to bring to my attention while leaving alone ones I'm not > involved in. I take the decision of purging or not a mail based on its subject, and after open a mail based of things like top postings (these get purged without further reading). I know the mail subjects I was involved or on which I answered or which I initiated. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub ¡Con Cuba no te metas! «» Don't mess with Cuba! «» Leg Dich nicht mit Kuba an! http://www.cubadebate.cu/noticias/2020/12/25/en-video-con-cuba-no-te-metas/
Re: Do we need a way to moderate mailing lists?
On Sun, Jan 17, 2021 at 12:05 PM Matthias Apitz wrote: > Mails to a mailing list should be text (or even ASCII) because not all > subscribers can read HTML or images and they're not needed to describe a > problem. > Its 2021; if an image is useful for the topic at hand (say designing a system and having a diagram showing that design) then that image should be allowed. > Images have the risk to have malicious content with the intention to use > bugs > in the image viewers. HTML can "phone home" with one pixel href's to > check if you opened the HTML page. > Fair points though I'd be inclined to argue whether such fears are sufficient. As doing nothing is the status quo and we haven't had incidents of this nature it seems like it not a problem in practice for whatever reason. > > > As we seem to be compiling a list for people to review upfront (the major > > points in this thread should make it to the website and be linked to by > > community responders when encountering said problematic posts). > > > > Always reply-to-all. > > Why? Why I (and other subscribers) have to have the same mail twice in > the mbox? > > It's useful to be able to see who is involved in the discussion by looking at the recipients and being able to know which of the hundreds of -general threads that hit my inbox I actually replied to in the past and thus can filter them to bring to my attention while leaving alone ones I'm not involved in. In reverse setting up a rule to ignore emails sent both to the group and myself is possible if I wish to treat any that hit the group the same and know that the ones also addressed personally are duplicates to those others. So reply-all gives people options while reply-to-list only doesn't. Options are good. David J.
Re: Do we need a way to moderate mailing lists?
El día domingo, enero 17, 2021 a las 11:11:01a. m. -0800, Adrian Klaver escribió: > You can prevent that by going here: > > https://lists.postgresql.org/manage/ > > and checking: > > Don't receive an extra copy of mails when listed in To or CC fields Thanks. I wasn't aware of it and switched it of now. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub ¡Con Cuba no te metas! «» Don't mess with Cuba! «» Leg Dich nicht mit Kuba an! http://www.cubadebate.cu/noticias/2020/12/25/en-video-con-cuba-no-te-metas/
Re: Do we need a way to moderate mailing lists?
On 1/17/21 11:04 AM, Matthias Apitz wrote: Hello, I disagree in some of the points: El día domingo, enero 17, 2021 a las 10:10:28a. m. -0700, David G. Johnston escribió: Neither images nor non-plain-text means that the content is unreadable, not useful, or problematic. Dealing with these on an email-by-email basis through the community seems fine. Mails to a mailing list should be text (or even ASCII) because not all subscribers can read HTML or images and they're not needed to describe a problem. Images have the risk to have malicious content with the intention to use bugs in the image viewers. HTML can "phone home" with one pixel href's to check if you opened the HTML page. As we seem to be compiling a list for people to review upfront (the major points in this thread should make it to the website and be linked to by community responders when encountering said problematic posts). 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: https://lists.postgresql.org/manage/ and checking: Don't receive an extra copy of mails when listed in To or CC fields Reply All is used so the folks involved in the conversation get the emails in a timely manner even if the mail server is running slow delivering to everyone else. ... matthias -- Adrian Klaver adrian.kla...@aklaver.com
Re: Do we need a way to moderate mailing lists?
Hello, I disagree in some of the points: El día domingo, enero 17, 2021 a las 10:10:28a. m. -0700, David G. Johnston escribió: > Neither images nor non-plain-text means that the content is unreadable, not > useful, or problematic. Dealing with these on an email-by-email basis > through the community seems fine. Mails to a mailing list should be text (or even ASCII) because not all subscribers can read HTML or images and they're not needed to describe a problem. Images have the risk to have malicious content with the intention to use bugs in the image viewers. HTML can "phone home" with one pixel href's to check if you opened the HTML page. > As we seem to be compiling a list for people to review upfront (the major > points in this thread should make it to the website and be linked to by > community responders when encountering said problematic posts). > > Always reply-to-all. Why? Why I (and other subscribers) have to have the same mail twice in the mbox? > ... matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub ¡Con Cuba no te metas! «» Don't mess with Cuba! «» Leg Dich nicht mit Kuba an! http://www.cubadebate.cu/noticias/2020/12/25/en-video-con-cuba-no-te-metas/
Re: Do we need a way to moderate mailing lists?
> Yes it’s unfortunately highly probable that someone asking (yet again) how to tune postgres will not first search for how to formulate a question. Not to say such info as you, David, and others propose should not be made available as it certainly should but that we may have to accept such nuisance posts as part of the cost of the truly valuable. Hopefully we agree that they are not, at least to date, unbearably frequent.
Re: Do we need a way to moderate mailing lists?
On Sun, Jan 17, 2021 at 3:30 AM Paul Förster wrote: > > On 17. Jan, 2021, at 11:23, Thiemo Kellner > wrote: > > > > I would not do that. It is the work on the wrong end with doubtful > result. Wouldn't it be better to reject non-plain-text postings? > > coming to think of it: > +1 > > Neither images nor non-plain-text means that the content is unreadable, not useful, or problematic. Dealing with these on an email-by-email basis through the community seems fine. As we seem to be compiling a list for people to review upfront (the major points in this thread should make it to the website and be linked to by community responders when encountering said problematic posts). Always reply-to-all. Don't cross-post within the lists (we have added technology to aid with this) Don't send us questions when your pgAdmin4 application isn't working right; the pgsql-admin list may contain both "pg" and "admin" in the title but that is not its purpose. David J.
Re: Do we need a way to moderate mailing lists?
Hi Thiemo, > On 17. Jan, 2021, at 11:23, Thiemo Kellner > wrote: > > I would not do that. It is the work on the wrong end with doubtful result. > Wouldn't it be better to reject non-plain-text postings? coming to think of it: +1 > While at it, is there a rule of thumb for the length of inline code - in > comparison to attaching code files in comparison to using something like > pastebin.com? I only found very coarse instructions on what to do on the > lists. Have I been missing a link to a netiquette page? no, there's no formal statement that I know of. But as you can see, I for example only quote the sentences or paragraphs I refer to, which is what the old Netiquette said and which I find makes perfect sense. I also rarely quote more than one quote level, and only when absolutely necessary. Cheers, Paul
Re: Do we need a way to moderate mailing lists?
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 select output, i.e. table data, explain plans, etc. Proportional fonts (Outlook with its darn Arial) is one of the worst... Well, one could say that with html messages one can "force" a monospaced font like consolas or courier. Then again, there is no guarantee that the receiving end does have it installed. And on top, everyone is free to have her/his mail client to display plain text in monospaced font and is only to blame her/himself if not doing so. And then there's people posting screen shots instead of copy/paste... :-( +1 I think, an automatic conversion of incoming posts to plain text and dropping all non plain text attachments would help a lot already. I would not do that. It is the work on the wrong end with doubtful result. Wouldn't it be better to reject non-plain-text postings? While at it, is there a rule of thumb for the length of inline code - in comparison to attaching code files in comparison to using something like pastebin.com? I only found very coarse instructions on what to do on the lists. Have I been missing a link to a netiquette page? Cheers Thiemo -- S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH Signal (Safer than WhatsApp): +49 1578 7723737 Threema (Safer than WhatsApp): A76MKH3J Handys: +41 78 947 36 21 | +49 1578 772 37 37 smime.p7s Description: S/MIME Signature
Re: Do we need a way to moderate mailing lists?
Hi Tim, > On 17. Jan, 2021, at 10:04, Tim Cross wrote: > > There is nothing stopping you from using a text mail program, like mutt, > on macOS. right. And what I said was not meant to be a complaint. Otherwise I would have complained long ago. It was just a wish. :-) Cheers, Paul
Re: Do we need a way to moderate mailing lists?
Hi Tim, > On 17. Jan, 2021, at 09:43, Tim Cross wrote: > > Highly recommend a mutt and imap combination. Your not locked into any > particular mail folder format, can still access things via mobile > devices and can process messages fast and efficiently. also, there's the good old elm. ;-) > He was amazed when I showed him all he needed to do was highlight the > error message, copy it and paste it into the message. This guy was one > of the senior developers on the team. > > I switched employers a few weeks later. one just can't know it all, I can understand that. But I expect a senior developer to develop good software. Knowing at least basic functionality of the tools s/he uses is one aspect of it. Copy/paste text is a basic thing which I expect a developer to know how to use, be it a terminal window or the IDE in use. The buzz-title "senior" developer/dba/whatever is very relative to what the company sees in you. I found that what is called "junior" in one company is "senior" or even "seasoned" in the next. These are only buzz words without a proper norm and classification and I don't give them much credit. With about 21 years of experience, my company calls me "Senior Oracle DBA". Still, I don't know RAC because we never had it, and know only little of Data Guard, which is way too complicated and bloated anyway. Oracle is so bug-ridden that I spend all of my day searching for fixes for databases and the OEM. Thank god, my day shifts more and more to PostgreSQL. :-) Cheers, Paul
Re: Do we need a way to moderate mailing lists?
Paul Förster writes: > Hi raf, > >> On 17. Jan, 2021, at 02:59, raf wrote: >> >> I once wrote a program to do that very thing: >> >> http://raf.org/textmail/ >> https://github.com/raforg/textmail/ > > thanks very much for the nice offer but I mostly read my Mails on a Mac, > sometimes Windows, but never Linux. I have no mail access on Linux. At home I > use Macs and at work I (have to :-() use Windows as desktops. So textmail is > not an option for me. > There is nothing stopping you from using a text mail program, like mutt, on macOS. -- Tim Cross
Re: Do we need a way to moderate mailing lists?
Paul Förster writes: > Hi Adrian, > > I'm on a Mac w/ Big Sur (macOS 11.1) and use Apple Mail. I've been on Macs > since 2003. Apple Mail is simple to use and I love it for exactly that. But > Apple Mail has everything I expect a mail client to have, it does not allow a > couple of things which other mail clients might have. Some people hate it for > exactly that. I set Mail to always compose in plain text but there is no way > of manipulating incoming mails other than that automatic displaying remote > content (HTML links, etc.) can (and should) be turned off. > > So I sometimes resort to either hit cmd-opt-u to see the mail text raw > source, or better yet, just hit reply and then drop the reply after reading. > As I set composing to plain text, it will convert any quoted parts. > Sometimes, I just copy/paste the whole mail for reading over to TextMate, > which is also sub-optimal but obviously also gives me non-proportional font > reading. > > Still, this is somewhat cumbersome as I have to do that for each mail > individually. Thank god, this doesn't happen too often. Yet, it's still > annoying enough. > I've used a number of GUI mail clients, including Apple Mail. However, I find still the fastest, most feature rich and powerful client is the text based client mutt. My other favourite is mu4e (Emacs client). While Apple Mail has reasonable keyboard shortcuts, mutt and mu4e can be fully keyboard driven and both have great (but different) abilities for customisation and dealing with large amounts of mail. The thing I hate most (and there is a lot to hate) with Outlook is the dependence on using the mouse for many operations. Being able to preview, sort, move, delete, messages and threads just using the keyboard makes dealing with mail much easier to deal with. Having a client which can do sophisticated sorting, flagging and searching messages/threads is essential and being able to easily automate where possible really helps. Highly recommend a mutt and imap combination. Your not locked into any particular mail folder format, can still access things via mobile devices and can process messages fast and efficiently. >> That is a learning curve thing. Many people don't know that copy and paste >> exists for terminals/GUI's/etc. Most people, once they are pointed in the >> right direction, will change that habit. That is why I would not advocate >> dropping non plain text attachments. Take this as a teaching moment and >> explain the reason why text is a benefit. > > I guess, they only change their behavior because copying/pasting some text is > easier to do than creating a windowshot with aligning the frame manually, > etc. But whatever the reason, thank god, some people are willing to learn > that if being told. > It is easy to forget the different experience levels and sophistication of users. I once had to help resolve a problem a developer was having with a database. I asked him to send me the exact error message. He moaned and said that was a real hassle. I couldn't understand why he found that so difficult to do. I decided to get him to show me his workflow. When the error occurred, he would take a screen shot of his window, send it to the printer, wait for the printer to send back a PDF and then send the issue with the PDF attached. He was amazed when I showed him all he needed to do was highlight the error message, copy it and paste it into the message. This guy was one of the senior developers on the team. I switched employers a few weeks later. -- Tim Cross
Re: Do we need a way to moderate mailing lists?
Hi raf, > On 17. Jan, 2021, at 02:59, raf wrote: > > I once wrote a program to do that very thing: > > http://raf.org/textmail/ > https://github.com/raforg/textmail/ thanks very much for the nice offer but I mostly read my Mails on a Mac, sometimes Windows, but never Linux. I have no mail access on Linux. At home I use Macs and at work I (have to :-() use Windows as desktops. So textmail is not an option for me. Cheers, Paul
Re: Do we need a way to moderate mailing lists?
Hi Adrian, > On 16. Jan, 2021, at 23:46, Adrian Klaver wrote: > > That is trying to put the toothpaste back in the tube. yes, but sometimes, just sometimes, things in the olden days were just better. :-) > Too many GUI email interfaces these days that use 'advanced` formatting. I > use Thunderbird and it allows me to convert incoming to plain text on the > fly. Not a perfect system, but it cuts down on a lot of the garish content. I'm on a Mac w/ Big Sur (macOS 11.1) and use Apple Mail. I've been on Macs since 2003. Apple Mail is simple to use and I love it for exactly that. But Apple Mail has everything I expect a mail client to have, it does not allow a couple of things which other mail clients might have. Some people hate it for exactly that. I set Mail to always compose in plain text but there is no way of manipulating incoming mails other than that automatic displaying remote content (HTML links, etc.) can (and should) be turned off. Asking our ex don't-be-evil friend revealed a setting for Apple Mail: defaults write com.apple.mail PreferPlainText -bool TRUE But that doesn't work (anymore?), at least not with Big Sur. So I sometimes resort to either hit cmd-opt-u to see the mail text raw source, or better yet, just hit reply and then drop the reply after reading. As I set composing to plain text, it will convert any quoted parts. Sometimes, I just copy/paste the whole mail for reading over to TextMate, which is also sub-optimal but obviously also gives me non-proportional font reading. Still, this is somewhat cumbersome as I have to do that for each mail individually. Thank god, this doesn't happen too often. Yet, it's still annoying enough. > That is a learning curve thing. Many people don't know that copy and paste > exists for terminals/GUI's/etc. Most people, once they are pointed in the > right direction, will change that habit. That is why I would not advocate > dropping non plain text attachments. Take this as a teaching moment and > explain the reason why text is a benefit. I guess, they only change their behavior because copying/pasting some text is easier to do than creating a windowshot with aligning the frame manually, etc. But whatever the reason, thank god, some people are willing to learn that if being told. Cheers, Paul