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/>
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/>
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
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
>>
>>
>>>
>>
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/&
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/>
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.
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
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
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
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/>
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
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
(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".
>
>
>
>
".
>
> 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/>
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/>
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
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"
> >
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
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/>
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/>
, 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/>
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/>
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/
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/>
n make them work with how PostgreSQL is
designed.
--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/
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
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
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/
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/>
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/>
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
> >
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".
--
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/
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/
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/
> (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/
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/
_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/
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
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/
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/
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:
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/
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/
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/
> 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
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/
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
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/
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/
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/
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
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/
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/>
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/>
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.
--
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/>
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
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/
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
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/>
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/>
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
>
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
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
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/>
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/>
;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/>
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
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.
--
> 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
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.
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/>
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/>
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
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/>
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
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/>
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/>
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/>
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/>
101 - 182 of 182 matches
Mail list logo