Migration to PGLister - After

2017-11-20 Thread Stephen Frost
Greetings! This list has now been migrated to new mailing list software known as 'PGLister'. This migration will impact all users of this mailing list in one way or another. If you would like to unsubscribe from this mailing list, please click on 'Show Original' or 'Show Headers' in your client

Re: [GENERAL] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs

2017-11-20 Thread Tom Lane
Luca Ferrari writes: > I don't think it is what I'm looking for, I would like something ,like: > select unnest( histogram_bounds::text::text[] ), unnest( > most_common_freqs ) from pg_stats > but with correlation between the two array indexes. Is it something > achievable in SQL? Or should I use

Re: Migration to PGLister - After

2017-11-20 Thread John R Pierce
On 11/20/2017 6:45 AM, Stephen Frost wrote: The changes which we expect to be most significant to users can be found on the wiki here:https://wiki.postgresql.org/wiki/PGLister_Announce the current version of which is also included below. A peeve on this new configuration:    if someone does a

Re: [GENERAL] Query Using Massive Temp Space

2017-11-20 Thread Tom Lane
Cory Tucker writes: > I have a query that is using a tremendous amount of temp disk space given > the overall size of the dataset. I'd love for someone to try to explain > what PG is doing and why its using so much space for the query. > First off, the system is PG 9.6 on Ubuntu with 4 cores and

Re: Migration to PGLister - After

2017-11-20 Thread Joshua D. Drake
On 11/20/2017 09:32 AM, John R Pierce wrote: On 11/20/2017 6:45 AM, Stephen Frost wrote: The changes which we expect to be most significant to users can be found on the wiki here:https://wiki.postgresql.org/wiki/PGLister_Announce  the current version of which is also included below. A peeve o

Re: Migration to PGLister - After

2017-11-20 Thread Stephen Frost
Greetings, * John R Pierce (pie...@hogranch.com) wrote: > On 11/20/2017 6:45 AM, Stephen Frost wrote: > >The changes which we expect to be most significant to users can be found > >on the wiki here:https://wiki.postgresql.org/wiki/PGLister_Announce the > >current version of which is also included

Re: Migration to PGLister - After

2017-11-20 Thread Stephen Frost
Josh, * Joshua D. Drake (j...@commandprompt.com) wrote: > Yep, but that is why the list-id filter is bad advice (at least for > me). I filter on the list email address and it works flawlessly. Indeed, this depends on what you're looking to do. Filtering on addresses listed in the To/CC is anothe

unsubscribe

2017-11-20 Thread Matt

Re: Migration to PGLister - After

2017-11-20 Thread Rich Shepard
On Mon, 20 Nov 2017, Joshua D. Drake wrote: Yep, but that is why the list-id filter is bad advice (at least for me). I filter on the list email address and it works flawlessly. Joshua, This does not work if the procmail recipe is for pgsql-gene...@postgresql.org and the source includes the

Re: Migration to PGLister - After

2017-11-20 Thread Daniel Pocock
On 20/11/17 18:32, John R Pierce wrote: > On 11/20/2017 6:45 AM, Stephen Frost wrote: >> The changes which we expect to be most significant to users can be found >> on the wiki here:https://wiki.postgresql.org/wiki/PGLister_Announce  the >> current version of which is also included below. > > >

Re: Migration to PGLister - After

2017-11-20 Thread Stephen Frost
Greetings Rich, * Rich Shepard (rshep...@appl-ecosys.com) wrote: > On Mon, 20 Nov 2017, Joshua D. Drake wrote: > >Yep, but that is why the list-id filter is bad advice (at least for me). I > >filter on the list email address and it works flawlessly. > > This does not work if the procmail recipe

Re: Migration to PGLister - After

2017-11-20 Thread Stephen Frost
Greetings, * Daniel Pocock (dan...@pocock.pro) wrote: > On 20/11/17 18:32, John R Pierce wrote: > > On 11/20/2017 6:45 AM, Stephen Frost wrote: > >> The changes which we expect to be most significant to users can be found > >> on the wiki here:https://wiki.postgresql.org/wiki/PGLister_Announce  th

unsubscribe

2017-11-20 Thread Zacher, Stacy

unsubscribe

2017-11-20 Thread Arnaldo Gandol
-- Thank you Arnaldo Gandol

Re: unsubscribe

2017-11-20 Thread Chris Withers
Make it stap :'( On 20/11/2017 17:55, Zacher, Stacy wrote:

unsubscribe

2017-11-20 Thread Noel
Sent from my iPhone > On Nov 20, 2017, at 12:56 PM, Arnaldo Gandol wrote: > > -- > Thank you > Arnaldo Gandol

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

2017-11-20 Thread David Pacheco
Responding to several points below. Tom Lane wrote: > David's report isn't too clear: did the syslogger process actually run > out of memory and exit of its own volition after an ENOMEM, or did it get > killed by the dreaded OOM killer? In either case, it's unclear whether > it was really using a

unsubscribe

2017-11-20 Thread Yang, Xiaoguang

unsubscribe

2017-11-20 Thread Rasha Osman
From: Yang, Xiaoguang Sent: 20 November 2017 18:16 To: pgsql-general@lists.postgresql.org Subject: unsubscribe

unsubscribe

2017-11-20 Thread Pedro Antonio
El 20/11/2017 1:20 p.m., "Rasha Osman" escribió: > > > > -- > *From:* Yang, Xiaoguang > *Sent:* 20 November 2017 18:16 > *To:* pgsql-general@lists.postgresql.org > *Subject:* unsubscribe > > > >

Re: *subscribe

2017-11-20 Thread Martin Fernau
PLS unsubscribe via https://lists.postgresql.org/manage/ thx Am 20.11.2017 um 19:20 schrieb Rasha Osman: *From:* Yang, Xiaoguang *Sent:* 20 November 2017 18:16 *To:* pgsql-general@lists.postgresql.org *Subject:* unsub

UNSUBSCRIBE

2017-11-20 Thread Frank Cavaliero
PLEASE UNSUBSCRIBE ME TO ALL pgsql* mailing lists. Thanks. From: rammohan ganapavarapu To: gp...@free.fr, pgsql-ad...@postgresql.org Date: 11/20/2017 01:25 PM Subject:Re: [ADMIN] Can master and slave on different PG versions? Gilles, Thank you, if we set

Re: Migration to PGLister - After

2017-11-20 Thread Rich Shepard
On Mon, 20 Nov 2017, Stephen Frost wrote: Yes, for a while both of those addresses will work and therefore you'd need to handle both addresses (there's a few different ways you could do that; with a regexp, I'd suggest something more specific, eg: (lists.)? ). Stephen, Yes, I changed the po

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

2017-11-20 Thread Andres Freund
Hi, On 2017-11-20 10:13:57 -0800, David Pacheco wrote: > I expect what happened is that the syslogger process attempted to allocate > memory, failed because the system was low, and explicitly exited. That's > consistent with an exited process, no core file generated, and the "FATAL" > "out > of m

Re: Migration to PGLister - After

2017-11-20 Thread Dean Gibson (DB Administrator)
My procmail filter is now: *  H ?? ^TO_pgsql-.*@(lists.)?postgresql.org On 2017-11-20 09:49, Rich Shepard wrote: On Mon, 20 Nov 2017, Joshua D. Drake wrote: Yep, but that is why the list-id filter is bad advice (at least for me). I filter on the list email address and it works flawlessly.

Unsubscribe

2017-11-20 Thread Ramamoorthi, Meenakshi
Please unsubscribe me to all PostgreSQL mailing lists. Thanks and best regards Meenakshi Ramamoorthi From: Frank Cavaliero [mailto:fcava...@us.ibm.com] Sent: Monday, November 20, 2017 10:31 AM To: pgsql-ad...@postgresql.org; pgsql-general@lists.postgresql.org; pgsql-gene...@postgresql.org Subjec

unsubscribe

2017-11-20 Thread Ramalingam, Sankarakumar
Thank you! Kumar Ramalingam From: Zacher, Stacy [mailto:szac...@mcw.edu] Sent: Monday, November 20, 2017 12:56 PM To: pgsql-general@lists.postgresql.org Subject: unsubscribe The information contained in this e-mail and in any attachments is intended only for the person or entity to which it

To all who wish to unsubscribe

2017-11-20 Thread Martin Fernau
*PLS unsubscribe via **https://lists.postgresql.org/manage/* Today I received dozens of unsubscribe mails, spamming my mail account :-) thx Am 20.11.2017 um 19:42 schrieb Ramalingam, Sankarakumar: Thank you! Kumar Ramalingam *From:* Zacher, Stacy [mailto:szac...@mcw.edu] *Sent:* Monday, Nov

Unsubscribe

2017-11-20 Thread MARTIN PAREDES
Please unsubscribe me to all PostgreSQL mailing lists. Thanks and best regards [http://www.firmasdecorreo.com/dyndata/images/firmasdecorreo.com-2013-11-09_17:06:25_8847-02.jpg] ING. MARTIN PAREDES DOMINGUEZ MAPASAC & MAPASOFT ERP-SOFTWARE-DEVELOPER FREELANCE SENIOR DEVELOP

Re: To all who wish to unsubscribe

2017-11-20 Thread Vick Khera
Did the list software change? All my messages from here are not being properly auto-files by the filter I have set up. > On Nov 20, 2017, at 13:48, Martin Fernau wrote: > > PLS unsubscribe via https://lists.postgresql.org/manage/ > > Today I received dozens of unsubscribe mails, spamming my m

Re: Unsubscribe

2017-11-20 Thread Alain Rodriguez Arias
Please unsubscribe me from all PostgreSQL mailing lists. Thanks and best regards On Mon, Nov 20, 2017 at 12:57 PM, MARTIN PAREDES wrote: > Please unsubscribe me to all PostgreSQL mailing lists. > > Thanks and best regards > > > > > > > ING. MARTIN PAREDES DOMINGUEZ > *MAPASAC & MAPASOFT

RE: Unsubscribe

2017-11-20 Thread Vadlamudi, Chandhra
I tried multiple ways to remove myself from groups but no luck. Please remove me from groups and communication lists. From: MARTIN PAREDES [mailto:map...@hotmail.com] Sent: Monday, November 20, 2017 10:58 AM To: pgsql-ad...@postgresql.org; pgsql-general@lists.postgresql.org; pgsql-gene...@postgre

Re: Unsubscribe

2017-11-20 Thread Haluk Durmus
Do it yourself guys ... Am Montag, 20. November 2017, 19:58:05 MEZ hat MARTIN PAREDES Folgendes geschrieben: Please unsubscribe me to all PostgreSQL mailing lists.  Thanks and best regards    |       | | |     |   ING. MARTIN PAREDES DOMINGUEZ   MAPASAC & MAPASOFT   E

Re: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

2017-11-20 Thread Natacha . Brosius
Hi, Please unsubscribe me to all PostgreSQL mailing lists. Thanks and best regard Natacha Brosius Le 20 nov. 2017 à 20:02, Vadlamudi, Chandhra mailto:chandhra.vadlam...@blueshieldca.com>> a écrit : I tried multiple ways to remove myself from groups but no luck. Please remove me from groups

Re: To all who wish to unsubscribe

2017-11-20 Thread Tom Lane
Vick Khera writes: > Did the list software change? All my messages from here are not being > properly auto-files by the filter I have set up. Yes - did you not see either of the "migration to pglister" messages? There's a summary of the changes at https://wiki.postgresql.org/wiki/PGLister_Anno

RE: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

2017-11-20 Thread Jaimi McEntire
To all wanting to unsubscribe. Go here to do it and quit flooding our mail boxes: https://www.postgresql.org/list/ From: Natacha.Brosius Sent: Monday, November 20, 2017 1:08:41 PM To: Vadlamudi, Chandhra Cc: pgsql-ad...@postgresql.org; pgsql-general@lists.postg

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

2017-11-20 Thread David Pacheco
Thanks again for looking at this issue. On Mon, Nov 20, 2017 at 10:34 AM, Andres Freund wrote: > Hi, > > On 2017-11-20 10:13:57 -0800, David Pacheco wrote: > > I expect what happened is that the syslogger process attempted to > allocate > > memory, failed because the system was low, and explicit

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

2017-11-20 Thread Andres Freund
Hi, On 2017-11-20 11:12:08 -0800, David Pacheco wrote: > > > This is a critical point. As far as I can tell, all that's necessary > > > for this deadlock to occur is: > > > > > > - the syslogger is unable to make forward progress (e.g., because it > > > segfaulted) > > > > This specific case I do

Re: To all who wish to unsubscribe

2017-11-20 Thread Vick Khera
On Mon, Nov 20, 2017 at 2:11 PM, Tom Lane wrote: > Vick Khera writes: > > Did the list software change? All my messages from here are not being > properly auto-files by the filter I have set up. > > Yes - did you not see either of the "migration to pglister" messages? > There's a summary of the

Re: To all who wish to unsubscribe

2017-11-20 Thread Joshua D. Drake
On 11/20/2017 11:11 AM, Tom Lane wrote: Vick Khera writes: Did the list software change? All my messages from here are not being properly auto-files by the filter I have set up. Yes - did you not see either of the "migration to pglister" messages? There's a summary of the changes at I certa

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
On Mon, Nov 20, 2017 at 8:37 PM, Joshua D. Drake wrote: > On 11/20/2017 11:11 AM, Tom Lane wrote: > >> Vick Khera writes: >> >>> Did the list software change? All my messages from here are not being >>> properly auto-files by the filter I have set up. >>> >> Yes - did you not see either of the "

unsubscribe

2017-11-20 Thread Ronny Abraham
Best regards, Ronny Abraham From: Pedro Antonio [mailto:pedro.osp...@gmail.com] Sent: Monday, November 20, 2017 1:22 PM To: Rasha Osman Cc: pgsql-general@lists.postgresql.org Subject: unsubscribe El 20/11/2017 1:20 p.m., "Rasha Osman" mailto:rash...@hotmail.com>> escribió:

Re: To all who wish to unsubscribe

2017-11-20 Thread Alban Hertroys
> On 20 Nov 2017, at 20:11, Tom Lane wrote: > > Those looking to unsubscribe should also read that page. Sending > "unsubscribe" messages to the list will not accomplish anything > except to annoy the rest of the list membership. I imagine that some people might think along the lines of: "Anno

RE: To all who wish to unsubscribe

2017-11-20 Thread Mengxuan Xia
A common feature in modern Email client is to allow users to unsubscribe in one line. This works by sending a email titled "unsubscribe" to the listserv, which most listserv these days are able to understand and unsubscribe the user. -Original Message- From: Alban Hertroys [mailto:haram.

Re: To all who wish to unsubscribe

2017-11-20 Thread Joshua D. Drake
On 11/20/2017 11:40 AM, Magnus Hagander wrote: https://wiki.postgresql.org/wiki/PGLister_Announce Those looking to unsubscribe should also read that page.  Sending "unsubscribe" messages to the list will not ac

unsubscribe

2017-11-20 Thread Ibram Remzi
Please unsubscribe me from the list.

Re: To all who wish to unsubscribe

2017-11-20 Thread Joshua D. Drake
On 11/20/2017 11:45 AM, Joshua D. Drake wrote: So do you have any suggestions for actually fixing that? Given that we have more lists to migrate, if you can figure out a way to make those changes without peoples filters not matching, we'd be happy to hear it.. I was thinking about that. I w

Re: To all who wish to unsubscribe

2017-11-20 Thread Tom Lane
"Joshua D. Drake" writes: > On 11/20/2017 11:40 AM, Magnus Hagander wrote: > One thing I would note is that there is no longer a footer > that tells people what to do if they want to unsubscribe. Perhaps one > thing that could be done is a header (for a temporary time period) that > says: > The

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
On Mon, Nov 20, 2017 at 8:57 PM, Joshua D. Drake wrote: > On 11/20/2017 11:45 AM, Joshua D. Drake wrote: > >> >> So do you have any suggestions for actually fixing that? Given that we >>> have more lists to migrate, if you can figure out a way to make those >>> changes without peoples filters not

Re: To all who wish to unsubscribe

2017-11-20 Thread Joshua D. Drake
On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to be DKIM-compatible and thus help avoid becoming classified as spammers, we can't mangle message content anymore, just like we can't mangle the Subject: line. Ugh, o.k. In princi

Unsubscribe

2017-11-20 Thread Marek Przywara
Please unsubscribe me from all PostgreSQL mailing lists. Best regards, Marek Przywara

Re: To all who wish to unsubscribe

2017-11-20 Thread Edson Carlos Ericksson Richter
Em 20/11/2017 17:45, Joshua D. Drake escreveu: On 11/20/2017 11:40 AM, Magnus Hagander wrote:     https://wiki.postgresql.org/wiki/PGLister_Announce     Those looking to unsubscribe should also read that page.  Sending     "uns

Re: To all who wish to unsubscribe

2017-11-20 Thread Tom Lane
Magnus Hagander writes: > Right. This is why you can send an emtil to say > pgsql-general-unsubscr...@lists.postgresql.org to unsubscribe. Oh? First I've heard of that, and I do not see it mentioned on the PGLister_Announce wiki page. It definitely should be. regards, t

Re: To all who wish to unsubscribe

2017-11-20 Thread John R Pierce
On 11/20/2017 11:45 AM, Joshua D. Drake wrote: Perhaps one thing that could be done is a header (for a temporary time period) that says: The mailing list software of Postgresql.org has changed. Please see this page on instructions on how to manage your subscription and filters. vast majorit

Re: To all who wish to unsubscribe

2017-11-20 Thread John R Pierce
On 11/20/2017 11:44 AM, Mengxuan Xia wrote: A common feature in modern Email client is to allow users to unsubscribe in one line. This works by sending a email titled "unsubscribe" to the listserv, which most listserv these days are able to understand and unsubscribe the user. thats a featur

Re: To all who wish to unsubscribe

2017-11-20 Thread John R Pierce
On 11/20/2017 12:07 PM, Joshua D. Drake wrote: I use Thunderbird which I imagine most people on the lists are using. I can't find where these would work to unsubscribe. In Thunderbird, ctrl-U shows the full headers, but the List-Unsubscribe links are NOT shown as hotlinks, so you have to copy

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
On Mon, Nov 20, 2017 at 9:07 PM, Joshua D. Drake wrote: > On 11/20/2017 12:03 PM, Tom Lane wrote: > >> Unfortunately, the removal of the footer is a feature not a bug. >> In order to be DKIM-compatible and thus help avoid becoming classified >> as spammers, we can't mangle message content anymore

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
On Mon, Nov 20, 2017 at 9:12 PM, Tom Lane wrote: > Magnus Hagander writes: > > Right. This is why you can send an emtil to say > > pgsql-general-unsubscr...@lists.postgresql.org to unsubscribe. > > Oh? First I've heard of that, and I do not see it mentioned on the > PGLister_Announce wiki page.

Re: Migration to PGLister - After

2017-11-20 Thread Ben Coleman
On 11/20/2017 09:45 AM, Stephen Frost wrote: > Greetings! > > This list has now been migrated to new mailing list software known as > 'PGLister'. This migration will impact all users of this mailing list > in one way or another. I note the conspicuous absence of pgsql-annou...@postgresql.org in

Re: Migration to PGLister - After

2017-11-20 Thread Tom Lane
Ben Coleman writes: > On 11/20/2017 09:45 AM, Stephen Frost wrote: >> This list has now been migrated to new mailing list software known as >> 'PGLister'. This migration will impact all users of this mailing list >> in one way or another. > I note the conspicuous absence of pgsql-annou...@postgr

unsubcribe

2017-11-20 Thread Ricardo Hiroshi Sakamoto
 unsubcribe ricardohiroshisakam...@yahoo.com.brRicardo Hiroshi Sakamoto

Re: Unsubscribe

2017-11-20 Thread CLAUDIO LIVIO CANDIANI
Please unsubscribe me from all PostgreSQL mailing lists. Best regards, Claudio 2017-11-20 18:07 GMT-02:00 Marek Przywara : > Please unsubscribe me from all PostgreSQL mailing lists. > > Best regards, > > Marek Przywara >

RE: To all who wish to unsubscribe

2017-11-20 Thread Leavitt, Ted
Vick, I thought it was just me. Yes, the sender changed: pgsql-general-ow...@postgresql.org -> pgsql-general@lists.postgresql.org I have updated my rules accordingly. -Ted From: Vick Khera [mailto:vi...@kh

Re: To all who wish to unsubscribe

2017-11-20 Thread Edson Carlos Ericksson Richter
Em 20/11/2017 18:07, Joshua D. Drake escreveu: On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to be DKIM-compatible and thus help avoid becoming classified as spammers, we can't mangle message content anymore, just like we can't

Re: To all who wish to unsubscribe

2017-11-20 Thread Joshua D. Drake
On 11/20/2017 12:20 PM, Magnus Hagander wrote: On Mon, Nov 20, 2017 at 9:07 PM, Joshua D. Drake > wrote: Not even remotely. People use gmail. See https://blog.hagander.net/mail-agents-in-the-postgresql-community-233/

Re: Migration to PGLister - After

2017-11-20 Thread Michael Nolan
On Mon, Nov 20, 2017 at 9:45 AM, Stephen Frost wrote: > > This list has now been migrated to new mailing list software known as > 'PGLister'. This migration will impact all users of this mailing list > in one way or another. > Is there more information available about PGLister somewhere, ie, is

Re: Unsubscribe

2017-11-20 Thread Jimmy Griffin
Me as well. Thanks Get Outlook for iOS From: Marek Przywara Sent: Monday, November 20, 2017 3:07:49 PM To: pgsql-ad...@postgresql.org; pgsql-general@lists.postgresql.org; pgsql-gene...@postgresql.org Subject: Unsubscribe Please unsubscribe

Re: To all who wish to unsubscribe

2017-11-20 Thread John R Pierce
On 11/20/2017 12:20 PM, Magnus Hagander wrote: Not even remotely. People use gmail. See https://blog.hagander.net/mail-agents-in-the-postgresql-community-233/ . its rather hard to tell some of those colors apart on my mon

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
On Mon, Nov 20, 2017 at 9:49 PM, John R Pierce wrote: > On 11/20/2017 12:20 PM, Magnus Hagander wrote: > > Not even remotely. People use gmail. See https://blog.hagander.net/ > mail-agents-in-the-postgresql-community-233/. > > > its rather hard to tell some of those colors apart on my monitor. >

Re: To all who wish to unsubscribe

2017-11-20 Thread John R Pierce
On 11/20/2017 12:49 PM, John R Pierce wrote: Sigh, not surprised about gmail, its amazing how many .com's and .org's use it now.  I'm not at ALL a fan of how the web client handles a bunch of stuff like replies, & hiding your own messages from yourself. oh and my biggest gripe, gmail seems to

declarative partition by list, "other values" syntax

2017-11-20 Thread legrand legrand
Hello, I was trying to create a partitionned table by list, that has on special partition for "other values" for exemple create table wiki_data_part( category varchar(20), tim_id bigint, pag_id bigint, requests int, size bigint ) PARTITION BY LIST (category ); CREATE TABLE wiki_d

Re: To all who wish to unsubscribe

2017-11-20 Thread Alvaro Herrera
Edson Carlos Ericksson Richter wrote: > I've been affected also, in a minor way, because I used to receive digest  2 > or 3 times a day, and now I'm receiving every e-mail again. > This is, at least, annoying. > would be better to keep the user options when migrating from one software to > another

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
On Mon, Nov 20, 2017 at 9:58 PM, John R Pierce wrote: > On 11/20/2017 12:49 PM, John R Pierce wrote: > >> Sigh, not surprised about gmail, its amazing how many .com's and .org's >> use it now. I'm not at ALL a fan of how the web client handles a bunch of >> stuff like replies, & hiding your own

Re: Migration to PGLister - After

2017-11-20 Thread Magnus Hagander
On Mon, Nov 20, 2017 at 9:31 PM, Michael Nolan wrote: > > > On Mon, Nov 20, 2017 at 9:45 AM, Stephen Frost wrote: > >> >> This list has now been migrated to new mailing list software known as >> 'PGLister'. This migration will impact all users of this mailing list >> in one way or another. >> >

Unsubscribe

2017-11-20 Thread Juan Camilo Marín
Please unsubscribe me from all PostgreSQL mailing lists

Unsubscribe

2017-11-20 Thread Jeferson Kasper
Please unsubscribe me from all PostgreSQL mailing lists

Re: Migration to PGLister - After

2017-11-20 Thread Rob Sargent
Kinda looking like you should have unsubscribed everybody and those of us that would miss the feed would re-connect. On 11/20/2017 02:09 PM, Magnus Hagander wrote: On Mon, Nov 20, 2017 at 9:31 PM, Michael Nolan > wrote: On Mon, Nov 20, 2017 at 9:45 AM, Stephen F

Re: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

2017-11-20 Thread Bennett Hitchcox-Lain
Yeah, that link is pretty much useless... The go to this other link for what you want, but then go to another link, and login, then go to. Why can I just put in my email and click unsubscribe. On Mon, Nov 20, 2017, 11:11 AM Jaimi McEntire wrote: > To all wanting to unsubscribe. Go here to do

RE: Migration to PGLister - After

2017-11-20 Thread Haiming Zhang
Unsubscribe me please. Thank you. [cid:Logowithtag3_c8588261-4850-42c1-9103-c228f2d961f9.jpg] Haiming Zhang | Engineer | Redflex IM haiming.zh...@redflex.com.au 31 Market Street, South Melbourne VIC 3205, Australia www.redflex.com If you ar

Re: Migration to PGLister - After

2017-11-20 Thread Stephen Frost
Mike, * Michael Nolan (htf...@gmail.com) wrote: > On Mon, Nov 20, 2017 at 9:45 AM, Stephen Frost wrote: > > This list has now been migrated to new mailing list software known as > > 'PGLister'. This migration will impact all users of this mailing list > > in one way or another. > > Is there mor

Re: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

2017-11-20 Thread Keith
The link to this simple form below is right at the top of the other link where it says "How to Subscribe or Unsubscribe, Fill out this form." https://www.postgresql.org/community/lists/subscribe/ On Mon, Nov 20, 2017 at 4:25 PM, Bennett Hitchcox-Lain wrote: > Yeah, that link is pretty much

Re: To all who wish to unsubscribe

2017-11-20 Thread Daniel Verite
Magnus Hagander wrote: > So do you have any suggestions for actually fixing that? Given that we have > more lists to migrate, if you can figure out a way to make those changes > without peoples filters not matching, we'd be happy to hear it.. I guess it's a bit late at this point, but in

Re: To all who wish to unsubscribe

2017-11-20 Thread Stephen Frost
Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > In principle, the List-Unsubscribe: headers that are now included in > mailing list headers allow MUAs to offer convenient unsubscribe > buttons. Not sure how many of the people who are complaining use > mail agents that don't handle that. Quit

Re: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

2017-11-20 Thread John R Pierce
On 11/20/2017 1:42 PM, Keith wrote: The link to this simple form below is right at the top of the other link where it says "How to Subscribe or Unsubscribe, Fill out this form." https://www.postgresql.org/community/lists/subscribe/ that form is for the legacy system.  for the new system, it

Test 501, please don't reply

2017-11-20 Thread Steve Litt
-- SteveT Steve Litt November 2017 featured book: Troubleshooting: Just the Facts http://www.troubleshooters.com/tjust

Re: Test 501, please don't reply

2017-11-20 Thread Stephen Frost
Greetings, Steve, and everyone, Located at https://lists.postgresql.org/manage/ is a little button just to the right of each list which you are subscribed to that says "Sent test mail." This will send an email, just to you, with the exact headers as the regular emails that are sent through the sy

Procmail recipe for new setup

2017-11-20 Thread Steve Litt
Hi all, The following procmail recipe works for me: === :0: * ^(To|Cc).*pgsql-gene...@postgresql.org .Postgres/ === In the preceding, the slash at the end of the destination (.Postgres) is because Procmail is inserti

Re: Procmail recipe for new setup

2017-11-20 Thread Rich Shepard
On Mon, 20 Nov 2017, Steve Litt wrote: The following procmail recipe works for me: === :0: * ^(To|Cc).*pgsql-gene...@postgresql.org .Postgres/ === Hi, Steve! Here's an alternative recipe: :0: * ^TO_.*pgsql-gen

Re: Procmail recipe for new setup

2017-11-20 Thread Joshua D. Drake
On 11/20/2017 02:10 PM, Steve Litt wrote: Hi all, The following procmail recipe works for me: === :0: * ^(To|Cc).*pgsql-gene...@postgresql.org .Postgres/ === You may want to use TO ... See here: https://www.mhona

Re: To all who wish to unsubscribe

2017-11-20 Thread Piotr Stefaniak
On 2017-11-20 21:03, Tom Lane wrote: > "Joshua D. Drake" writes: >> On 11/20/2017 11:40 AM, Magnus Hagander wrote: >> One thing I would note is that there is no longer a footer that >> tells people what to do if they want to unsubscribe. Perhaps one >> thing that could be done is a header (for a

Re: Procmail recipe for new setup

2017-11-20 Thread Piotr Stefaniak
On 2017-11-20 23:10, Steve Litt wrote: > The following procmail recipe works for me: I use this: :0 * ^List-Id: \/.* { :0 * $MATCH ?? [<]+\/.*[^>]+ $MATCH/ :0 $MATCH/ }

Re: Procmail recipe for new setup

2017-11-20 Thread Stephen Frost
Greetings Piotr, * Piotr Stefaniak (postg...@piotr-stefaniak.me) wrote: > On 2017-11-20 23:10, Steve Litt wrote: > > > The following procmail recipe works for me: > > I use this: > > :0 > * ^List-Id: \/.* > { > :0 > * $MATCH ?? [<]+\/.*[^>]+ > $MATCH/ > > :0 > $MATCH/

Re: Procmail recipe for new setup

2017-11-20 Thread Stephen Frost
Greetings Rich, all, * Rich Shepard (rshep...@appl-ecosys.com) wrote: > On Mon, 20 Nov 2017, Steve Litt wrote: > > >The following procmail recipe works for me: > > > >=== > >:0: > >* ^(To|Cc).*pgsql-gene...@postgresql.org > >.Postgres/ > >==

Re: To all who wish to unsubscribe

2017-11-20 Thread Steve Atkins
> On Nov 20, 2017, at 2:18 PM, Piotr Stefaniak > wrote: > > On 2017-11-20 21:03, Tom Lane wrote: >> "Joshua D. Drake" writes: >>> On 11/20/2017 11:40 AM, Magnus Hagander wrote: >>> One thing I would note is that there is no longer a footer that >>> tells people what to do if they want to unsub

Re: To all who wish to unsubscribe

2017-11-20 Thread Jan Claeys
On Mon, 2017-11-20 at 18:12 -0200, Edson Carlos Ericksson Richter wrote: > Seems that Thunderbird (latest stable version) doesn't understand > the unsubscribe header. > Or, perhaps, it is wrong. Or maybe you need an addon. -- Jan Claeys

Re: To all who wish to unsubscribe

2017-11-20 Thread Gavin Flower
On 21/11/17 09:20, Magnus Hagander wrote: On Mon, Nov 20, 2017 at 9:07 PM, Joshua D. Drake > wrote: On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to be DKIM-compatible and thus

Re: unsubscribe

2017-11-20 Thread Amila Jayasooriya
Please unsubscribe me from the list. Thanks and Regards Amila Jayasooriya On Tue, Nov 21, 2017 at 3:48 AM, Ibram Remzi wrote: > Please unsubscribe me from the list. >

Re: unsubscribe

2017-11-20 Thread Danyelle Davis
On Mon, Nov 20, 2017 at 9:29 PM, Amila Jayasooriya < amilajayasoor...@gmail.com> wrote: > Please unsubscribe me from the list. > > Thanks and Regards > Amila Jayasooriya > > On Tue, Nov 21, 2017 at 3:48 AM, Ibram Remzi > wrote: > >> Please unsubscribe me from the list. >> >> Please look at the l

Re: unsubscribe

2017-11-20 Thread Ryan
Hi, All right, so not for lack of trying, I cannot figure out how to unsubscribe. I've tried three different things, but they've either been ineffective or result in me getting an automatic email that the attempt failed. Kindly help? I enjoyed my daily digest of PostgreSQL messages, but this has b

Re: To all who wish to unsubscribe

2017-11-20 Thread Carl Karsten
On Mon, Nov 20, 2017 at 1:11 PM, Tom Lane wrote: > Vick Khera writes: > > Did the list software change? All my messages from here are not being > properly auto-files by the filter I have set up. > > Yes - did you not see either of the "migration to pglister" messages? > There's a summary of the

  1   2   >