Hi Bartek
It is quite significant that your postgres log file has these entries.
Normally if a web application gets compromised allowing remote code
execution, the attacker will be able to run scripts (often via cron
and at) as the user running the web application. Typically www-data,
tomcat8 etc
I guess you can run swapoff (followed by swapon). That will free up
whatever is currently swapped. Beware if the system is actively
swapping then swapoff can take some time. But it seems not in your
case.
On Tue, 16 Oct 2018 at 10:48, Nicola Contu wrote:
>
> No it is not probably used, because
Hi Timmy
You need to use CIDR form in your pg_hba.conf. So:
host all testuser 111.222.333.444/32 md5
Most likely you would probably want to ensure ssl connection if coming
over untrusted network. So, at minimum, this is better:
hostssl all testuser 111.222.333.444/32 md5
This is better s
Hi
I have an interesting problem. I have a string field in a table which
(sometimes) is expected to contain numeric values ie. a cast of the
field to INTEGER is supposed to succeed.
My issue is that the application is running in Bangladesh, and
sometimes the users have entered values using Bang
Thanks Tom. That is what I expected to hear. Was being hopeful ...
On Mon, 25 Nov 2019 at 16:27, Tom Lane wrote:
>
> Bob Jolliffe writes:
> > I have an interesting problem. I have a string field in a table which
> > (sometimes) is expected to contain numeric values
select translate(string,'০১২৩৪৫৬৭৮৯','0123456789');
seems to do the trick.
On Mon, 25 Nov 2019 at 16:38, Bob Jolliffe wrote:
>
> Thanks Tom. That is what I expected to hear. Was being hopeful ...
>
> On Mon, 25 Nov 2019 at 16:27, Tom Lane wrote:
> >
>
I have generally favoured ubuntu LTS editions over the years, more out of
familiarity than any particular good technical reason. In the past,
postgresql on FreeBSD would have been my first goto, but it's harder to get
freebsd skills out on the market than ubuntu/debian linux.
I do have one gripe
Out of curiosity, is the pg14 running with the default jit=on setting?
This is obviously entirely due to the nature of the particular queries
themselves, but we found that for our workloads that pg versions
greater than 11 were exacting a huge cost due to the jit compiler. Once we
explicitly turn
M that
> lives on a probably-busy host).
>
> On Mon, Jan 29, 2024 at 9:18 AM Ron Johnson
> wrote:
>
>> Yes, jit=on.
>>
>> I'll test them with jit=off, to see the difference. (The application is
>> 3rd party, so will change it at the system level.)
&g
We have some users of our software who have had a good experience with
postgresql on zfs/zol. Two features which have proved useful are the
native encryption (less fiddly than luks) and compression. Interestingly,
many of our users are stuck with quite old and slow disks. Using
compression (even
10 matches
Mail list logo
