Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?

2023-01-17 Thread Magnus Hagander
they are issued/confirmed when they are synchronous. Thus terms like WAL = Write *Ahead* Log. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: pgBackrest Error : authentication method 10 not supported

2023-01-31 Thread Magnus Hagander
n you're on, which you didn't specify) -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: pgBackrest Error : authentication method 10 not supported

2023-02-02 Thread Magnus Hagander
u installed backrest from a different source than wherever you installed your postgres from, and therefor it's using those libraries. Perhaps backrest is using the actual default operating system install, and your postgres is a non-standard one? //Magnus > > On Tue, Jan 31, 2023 at 7:32 PM Ma

Re: pgBackrest Error : authentication method 10 not supported

2023-02-02 Thread Magnus Hagander
han >> wherever you installed your postgres from, and therefor it's using those >> libraries. Perhaps backrest is using the actual default operating system >> install, and your postgres is a non-standard one? >> >> //Magnus >> >> >>> >>

Re: Postgresql professional certification

2023-03-23 Thread Magnus Hagander
ow i can approach to do my Postgresql professional > certification. > > Hello! There is no official PostgreSQL certification. Some PostgreSQL related companies may have their own, but there is no standard one. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/&

Re: Impact on PostgreSQL due to Redhat acquisition by IBM

2018-11-16 Thread Magnus Hagander
ide their services in the form of creating installers. And as long as the source to the installers is open, somebody else can pick it up in case they don't. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: BDR and PostgreSQL 12 and Windows support

2018-11-16 Thread Magnus Hagander
ot work on Windows AFAIK, but it does work on a number of other non-Linux OSes. And there are other things that don't work on Windows, such as e.g. peer authentication. They are significantly more minor features though. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.

Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

2018-11-19 Thread Magnus Hagander
ular URL will produce a list of talks with links > to slides, if uploaded. That shouldn't be hard to do if someone is > interested and knows a little python/django- the code is here: > It can already be done on the session list, if one just uses the template functioinality that's the

Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

2018-11-19 Thread Magnus Hagander
On Mon, Nov 19, 2018 at 2:38 PM Magnus Hagander wrote: > On Mon, Nov 19, 2018 at 2:27 PM Stephen Frost wrote: > >> Greetings, >> >> * Charles Clavadetscher (clavadetsc...@swisspug.org) wrote: >> > >> https://wiki.postgresql.org/wiki/PostgreSQL_Conference_E

Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

2018-11-19 Thread Magnus Hagander
On Mon, Nov 19, 2018 at 4:01 PM Stephen Frost wrote: > Greetings, > > * Magnus Hagander (mag...@hagander.net) wrote: > > This has now been pushed, so both the schedule and the session list on > > pgconf.eu will now indicate which sessions have slides uploaded. > > Tha

Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

2018-11-19 Thread Magnus Hagander
ut we could at least > start there, I suppose, if someone wants to pull that together. > Yes, I do have some sort of long term idea for how to do that. I haven't figured out the details yet though, but that's where I'd like to end up eventually. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

2018-11-20 Thread Magnus Hagander
On Mon, Nov 19, 2018 at 9:04 PM Stephen Frost wrote: > Greetings, > > * Magnus Hagander (mag...@hagander.net) wrote: > > On Mon, Nov 19, 2018 at 4:01 PM Stephen Frost > wrote: > > > * Magnus Hagander (mag...@hagander.net) wrote: > > > > This has now be

Re: Full text search with more than one word

2019-01-18 Thread Magnus Hagander
On Fri, Jan 18, 2019 at 11:37 AM Ritanjali Majihee < rmaj...@247headhunting.com> wrote: > Hi Team, > > > > We have around 20 millions of records in Postgresql database. One of the > column is html document stored as Text datatype. We want Use this column in > search functionality. We have converte

Re: Full text search with more than one word

2019-01-18 Thread Magnus Hagander
(please don't top-post on the postgresql mailinglists) On Fri, Jan 18, 2019 at 3:57 PM Ritanjali Majihee < rmaj...@247headhunting.com> wrote: > Hi Magnus, > > > > exact Search keyword is ("Marketing Coordinator" OR "Marketing > Specialist" OR "Marketing Associate" ) AND "Creative Suite". > > > >

Re: Full text search with more than one word

2019-01-25 Thread Magnus Hagander
". > > Can you please help us solve this issue. > > > > > > You should look into phraseto_tsquery() for searching for phrases, and > websearchto_tsquery() for the kind of complete search with or and and in it > that you are looking for. to_tsquery doesn't do any parsing like that. > > > > //Magnus > > > -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: Calling rest service from postgresql functions and stored proc

2019-02-07 Thread Magnus Hagander
ething like multicorn to create a foreign data wrapper to access it, thereby not needing a function or procedure at all. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: CVE-2019-9193 about COPY FROM/TO PROGRAM

2019-04-01 Thread Magnus Hagander
t wasn't a violation of > Postgres' security model, and he agreed. But then they've > posted this anyway. Left hand doesn't talk to right hand there, > apparently. > I wonder if we need to prepare some sort of official response to that. I was considering writ

Re: CVE-2019-9193 about COPY FROM/TO PROGRAM

2019-04-02 Thread Magnus Hagander
On Tue, Apr 2, 2019 at 5:31 PM Andres Freund wrote: > Hi, > > On 2019-04-02 07:35:02 -0500, Brad Nicholson wrote: > > Michael Paquier wrote on 04/02/2019 01:05:01 AM: > > > > > From: Michael Paquier > > > To: "Jonathan S. Katz" > >

Re: CVE-2019-9193 about COPY FROM/TO PROGRAM

2019-04-02 Thread Magnus Hagander
On Mon, Apr 1, 2019 at 4:04 PM Jonathan S. Katz wrote: > > > On Apr 1, 2019, at 9:55 AM, Tom Lane wrote: > > > > Magnus Hagander writes: > >>> On Sat, Mar 30, 2019 at 10:16 PM Tom Lane wrote: > >>> Yeah; this is supposing that there is a security b

Re: CVE-2019-9193 about COPY FROM/TO PROGRAM

2019-04-04 Thread Magnus Hagander
lso pretty much acknowledged in comments on his blog and on twitter that it's not actually a vulnerability. (He doesn't agree with the design decision, which is apparently enough for a high scoring CVE registration). -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: Notification for Minor Release and Security Update

2019-04-11 Thread Magnus Hagander
or releases available at https://www.postgresql.org/versions.rss. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: verify checksums / CREATE DATABASE

2019-06-05 Thread Magnus Hagander
, because very likely the copy > process happens at the file level. Is that correct ? > > That is correct, it does not verify checksums when copying the template. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: pg_receivelwal vs synchronous

2019-06-27 Thread Magnus Hagander
is never > updated, and replay_lag keeps increasing. > > > What am I missing here ? > I believe your problem is remote_apply. pg_receivewal never *applies* any WAL, so it just updates the write and flush locations. Notice how the replay_lsn remains NULL. So you need synchronous_commit to be 'on' or 'remote_write', not 'remote_apply'. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: PostgreSQL in-transit compression for a client connection

2023-04-28 Thread Magnus Hagander
a useful feature to have, but it's not something that we have today or that I'm aware of being on anybodys radar. So most likely, for now you're stuck with either what you're doing today, or as Laurenz suggests handle it completely in the application. You can't do the mix. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Compiling postgres for windows with src/tools/msvc.build.bat

2023-05-02 Thread Magnus Hagander
x parameter. To install, you use the "install.bat " command -- where you specify the directory on the commandline. That's the equivalent of the combination of --prefix and "make install" on Unix/Linux. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: Regarding SSL Enablement in PostgreSQL Database on different port

2023-05-02 Thread Magnus Hagander
n make them work with how PostgreSQL is designed. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency

2023-05-02 Thread Magnus Hagander
apset/libpython2.7-64.stp > [ec2-user@ip-172-31-51-199 ~]$ > > > What am I missing? Why won't the postgresql15-contrib install find my > python shared lib? Does it have to be python3.6 only? Is 3.7, 3.8 no good? > > > This is not actually answering your question, but you shou

Re: connecting to localhost -> ::1 client_addr ?

2023-05-05 Thread Magnus Hagander
On Fri, May 5, 2023 at 9:23 AM Luca Ferrari wrote: > > Hi all, > this may be tribial, but I'm seeing connections from ::1 in > pg_stat_activity, and I've never realiuzed that psql converts > "localhost" in IPv6. > Is there a way to "force" the hostname localhost to appear as IPv4 or > am I missing

Re: pg_upgrade v15 not generating analyze_new_cluster.sh

2023-06-13 Thread Magnus Hagander
e release notes for the intermediate versions as well when looking for changes, as those will not be included in the notes for the newer version. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Active sessions does not terminated due to statement_timeout

2024-03-26 Thread Magnus Hagander
ail.com -- basically that there's some path when we're in ClientWrite that it doesn't check for interrupts properly. I've unfortunately not had time to dig into that one anymore. What version of PostgreSQL and what platform are you on? -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: \dt shows table but \d says the table doesn't exist ?

2024-05-03 Thread Magnus Hagander
dIds". > Looks like you might need a \d "some_idIds" (include the quotes) since it has an uppercase characters? -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: \dt shows table but \d says the table doesn't exist ?

2024-05-03 Thread Magnus Hagander
On Fri, May 3, 2024 at 11:08 PM Adrian Klaver wrote: > On 5/3/24 14:06, Magnus Hagander wrote: > > > > > > On Fri, May 3, 2024 at 10:58 PM David Gauthier > <mailto:dfgpostg...@gmail.com>> wrote: > > > > psql (15.3, server 14.5) on linux > >

Re: apt-archive.postgresql.org a bit broken?

2024-07-05 Thread Magnus Hagander
access old, archived focal packages. I guess this isn't > wanted behavior? > > In case I should direct this problem report to some different place I'd > be glad if you would tell me. > The dist name should be "focal-pgdg-archive" not "focal-pgdg". --

Re: Upgrade from 11.3 to 13.1 failed with out of memory

2021-04-06 Thread Magnus Hagander
de mode". There's been some recent work on trying to find a remedy for this, but nothing is available at this point. You'll need to either trim the number of objects if you can (by maybe manually dumping them out to files before the restore and then reloading them back in later), or just add more memory/swap to the machine. Long term you should probably consider switching to using bytea columns when you have that many objects. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: The Amazon CloudFront distribution is configured to block access from your country.

2021-04-12 Thread Magnus Hagander
is download is provided externally by EDB" (very much open to input on exactly what the sentence should be)? Or were you guys thinking in the line that we should have one of those "you are now leaving postgresql.org"-steps in between with a second click? -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Vulnerability PostgreSQL 11.2

2021-04-15 Thread Magnus Hagander
erabilities between 11.2 and 11.11, as you can see on https://www.postgresql.org/support/security/11/. So it sounds like your vulnerability scanner is right and that you need to install the updates. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: DB size

2021-04-27 Thread Magnus Hagander
> (1 row) Yeah, you want to use pg_relation_filenode(oid) rather than looking directly at relfilenode. When compared to the filesystem, it's probably even easier to use pg_relation_filepath(oid). -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Open source licenses

2021-04-29 Thread Magnus Hagander
g version of the docs (now on https://www.postgresql.org/docs/devel/install-binaries.html) will make it more clear that we also recommend using packages on for example Linux as well, when they are available. So the recommendation is generic, not Windows-specific. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"

2021-05-04 Thread Magnus Hagander
_dump. > > > Anyone seen similar issue? > > Nope, something very odd going on here. Do you by any chance have more than one version of PostgreSQL running at the same time for different clusters? It kind of sounds like it's picking up the wrong version at some point. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Sequence gaps after restart

2021-05-11 Thread Magnus Hagander
27;t believe there are any plans to change this in PostgreSQL, as it's generally not a problem. AWS Aurora however, is not PostgreSQL, it's a different database (which shares some parts, but it's fundamentally quite different) It's also not open source so there is no way for us to

Re: Plan for exclusive backup method

2021-05-19 Thread Magnus Hagander
tallations using it today are unsafe, it is recommended that you don't use it even before then. It basically exists for backwards compatibility with PostgreSQL prior to 9.6. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Fwd: Proposed Chinese Translation of Community Code of Conduct

2021-05-22 Thread Magnus Hagander
gain. It has explicitly attached the fiel to the HTML part, which means that anybody viewing the plaintext part (such as the PostgreSQL archives..) will not see it. I have no idea how to make it not do that, but AFAIK it's only Apple Mail that's shown this problem. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Null database entry in pg_stat_database on pg-12 version

2021-05-26 Thread Magnus Hagander
gathering those data and which database is responsible for this? Yes. This is new in PostgreSQL 12 (https://www.postgresql.org/docs/12/release-12.html). It tracks accesses to shared objects (https://www.postgresql.org/docs/12/monitoring-stats.html#PG-STAT-DATABASE-VIEW). -- Magnus Hagander Me:

Re: How long to get a password reset ???

2021-05-28 Thread Magnus Hagander
s like this to webmas...@postgresql.org, so they don't have to go out to thousands of people. They'll still be picked up of course, but that will be more targeted.) -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: www.postgresql-archive.org content deleted

2021-06-22 Thread Magnus Hagander
ent third party. The official PostgreSQL archives are on https://www.postgresql.org/list/ -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Need suggestions about live migration from PG 9.2 to PG 13

2021-07-07 Thread Magnus Hagander
thing goes wrong, but just keep an extra standby node around to fail over to if everything blows up and you have that covered. The fact that pg_upgrade *doesn't* take ages to deal with medium size databases and up is the main reason it *exists*. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: returning setof from insert ?

2021-07-14 Thread Magnus Hagander
> insert into bar(f,b) values(foo,bar) returning * into v_row; > return v_row; > END; > $$ language plpgsql; You can write that either as: RETURN NEXT v_row; (the NEXT being the missing keyword) Or just the whole thing as RETURN QUERY INSERT INTO ... RETURNING * and get

Re: Getting pg_stat_database data takes significant time

2021-08-12 Thread Magnus Hagander
second. Second call in the same connection, different txn, > 0.8s. > > Second call in the same transaction as first - 0.053ms. > > So it definitely suggests that loading the stats file is the problem. Yes, definitely. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Getting pg_stat_database data takes significant time

2021-08-12 Thread Magnus Hagander
On Thu, Aug 12, 2021 at 4:38 PM hubert depesz lubaczewski wrote: > > On Thu, Aug 12, 2021 at 11:32:15AM +0200, Magnus Hagander wrote: > > Which database are you connected to? If you just want to look at the > > global stats, it might help to be connected to a database that is

Re: Licensing

2021-08-19 Thread Magnus Hagander
nd add it to https://www.postgresql.org/about/licence/ -- similar to how we explain that we're not going to change license... Like a "what does this mean" section or something.. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Choosing an index on partitioned tables.

2021-09-07 Thread Magnus Hagander
eploy with cron. And FWIW, in reference to the discussions about AWS, it is supported on RDS. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Choosing an index on partitioned tables.

2021-09-07 Thread Magnus Hagander
by *postgresql*. (And of course, AWS or Azure or whomever do whatever they want, but I assume they're including pg_partman because it's a very popular extension) -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Choosing an index on partitioned tables.

2021-09-07 Thread Magnus Hagander
link you get to https://github.com/docker-library/postgres which clearly explains what "type of official" it is. That said, as long as you use the debian based version of their container, it should be trivial to add any extension that's supported on Debian, which definitely inclu

Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

2021-09-20 Thread Magnus Hagander
uilt > that way: each row INSERTed means a round trip between PostgreSQL and Oracle. > Just as a note, with PostgreSQL 14 the FDW APIs allow batch insert. It should be possible to update oracle_fdw to take advantage of that as well, right? -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: Force re-compression with lz4

2021-10-17 Thread Magnus Hagander
e db. > > Is there a smarter way to do this ? > > It should be enough to VACUUM FULL the table. (but it has to be VACUUM FULL, not a regular vacuum). Or CLUSTER. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: Force re-compression with lz4

2021-10-18 Thread Magnus Hagander
cases when > looking at the compression type of the vacuumed table attributes: > Oh dang, I missed that this was reverted. Thanks for pointing that out! -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: Python3 for PostgreSQL 14

2021-10-27 Thread Magnus Hagander
ian packaging team packages both the packages for debian and those for apt.postgresql.org, so it's still the same people that does. So there's actually a lot more crossover there than when you look at the EDB provided packages for example, where the team is completely indepdendent. --

Re: Tab-completion error...?

2021-12-22 Thread Magnus Hagander
t's using a system-default version of libpq.so which is from an older version. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2

2021-12-30 Thread Magnus Hagander
o I tried to build > llvm-toolset-clang from scratch, but that doesn't solve the problem. Note that the PGDG repositories are not supported on Amazon Linux. https://www.postgresql.org/download/linux/redhat/ has a list of supported platforms for them. On CentOS, which is, you need to r

Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2

2022-01-01 Thread Magnus Hagander
have worked "by chance". The llvm dependency comes from the JIT functionality, which was added in PostgreSQL 11, so it not being a dependency in an older version than that makes perfect sense. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
t it was a flaw in the migration not the > user wondering why they are currently getting spammed because their filters > no longer work. > 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

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
This is why you can send an emtil to say pgsql-general-unsubscr...@lists.postgresql.org to unsubscribe. You can also click the unsubscribe link that's in the list headers, which also does not require you to log in - you just have to click the confirmation button. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
https://blog.hagander.net/ mail-agents-in-the-postgresql-community-233/. And gmail does automatically show an unsubscribe link on these mails. See attached screenshot for the mail from Jonathan earlier today as an example. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

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 >

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 color

Re: To all who wish to unsubscribe

2017-11-20 Thread Magnus Hagander
web based ones do a decent job today. They certainly didn't use to do that... And it's internal threading is way more complex than just using subject. But the inability to override how it does that is definitely one of my biggest gripes about gmail. But that only affects the user of gmai

Re: Migration to PGLister - After

2017-11-20 Thread Magnus Hagander
time to go through it and make sure we're not accidentally leaking something that shouldn't be leaked. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: unsubscribe

2017-11-21 Thread Magnus Hagander
unsubscribe requests that ended up getting moderated, and people who posted publicly. During this time, the systems have also processed 282 unsubscriptions from people who managed to read and work with the instructions. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: unsubscribe

2017-11-21 Thread Magnus Hagander
;t make it to the list because of those. > But really, a nightmare? Yeah, it's a pain, but I think that's laying it > on a bit strong. Personally I appreciate the hard and usually thankless > work the infrastructure and admin team do. > Thanks! -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: migrations (was Re: To all who wish to unsubscribe)

2017-11-21 Thread Magnus Hagander
ching the list members. > > This is already the case, but clearly this rule was a bit too restrictive to avoid too many false positives. One big drawback to it was that it didn't filter on the subject, only on the body. This was rapidly fixed once the flood was started, but in some ways

Re: migrations (was Re: To all who wish to unsubscribe)

2017-11-21 Thread Magnus Hagander
x27;re a lot less likely to be one of the users who just blackholed emails, to have them suddenly reappear. For -admin you might subscribe to ask one or two questions and not really care about the rest. You can do that for hackers too of course, but I would guess it's a lot less likely. --

Re: duplicate primary key

2017-11-22 Thread Magnus Hagander
> 18319 | (9982129,2) | 14875 | 3149449600 | 3152681810 > 18319 | (9976870,49) | 14875 | 3149448769 | 3152328995 > > > > I don't understand how this could have happened > > What is your postgres version, and what's the "version histor

Re: a back up question

2017-12-06 Thread Magnus Hagander
em. You should then instead use pg_basebackup, or if you need even more functionality and performance than this provides, look at the external tools like pgbackrest or pgbarman. These tools don't need to be any more complicated to use than pg_dump, but will give you a much better backup.

Re: Replication questions - read-only and temporary read/write slaves

2017-12-15 Thread Magnus Hagander
t, but you cannot do it with just PostgreSQL functionality. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: psycopg2 and java gssapi questions

2017-12-21 Thread Magnus Hagander
be present in that users environment, and will be used by the libpq client. (it might look slightly different for a Java client, but the principle is the same) -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: Migration to PGLister - After

2017-12-21 Thread Magnus Hagander
On Mon, Nov 20, 2017 at 10: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 Frost >> wrote: >> >>> >>> This list has now been migrated to new mailing

Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices

2017-12-22 Thread Magnus Hagander
QUERY PLAN > ---- > > Index Scan using index_translations_on_locale_and_key on translations > (cost=0.41..2.63 rows=1 width=234) >Index Cond: (((locale)::text = 'de'::text) AND ((key)::text = > 'extranet.options.places.age_brackets_hints.a'::text)) > (2 rows) > > > > The upgrade guide states that only hash indices should be rebuilt after > the upgrade, not btree ones. > > > What platform are you on, how was PostgreSQL installed, and exactly how was pg_upgrade executed? (or is, since it's reproducible) -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: Mailing list archiver

2018-01-03 Thread Magnus Hagander
ell you how it differs from the one Jordan is posting, because if I go to that site I just get empty templates and it's failing to load the javascript properly from here. But I'm sure you've seen the archives, and can compare yourself! I'm sure it has good points to it, otherwise

Re: Mailing list archiver

2018-01-03 Thread Magnus Hagander
people who specifically use the IRC channel to avoid posting to a public list, and they should be allowed to do so without a public archive. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

2018-02-06 Thread Magnus Hagander
age for > 10 so neither of the modules is installable. What did I miss? > pgcrypto and uuid-ossp are both in the core package for PostgreSQL 10. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: New Copy Formats - avro/orc/parquet

2018-02-12 Thread Magnus Hagander
sing also becomes useful to file_fdw automatically (or at least optionally). -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15

2025-05-13 Thread Magnus Hagander
bz2 09-May-2025 19:58 350884 >> >> Not sure where the Filesize:350996 [weak] and Release file created at: >> Mon, 28 Apr 2025 16:16:01 + is coming from? >> > > Me neither, I'll confess - possibly a version in use that *didn't* receive > an update? > If you still have the issue, or f it reappears, can you please provider the header output from basically a "curl -I " for th different URLs involved at the time of failure? And also note the exact timestamp of when you're doing it, to correlate with logs. -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

<    1   2