On 11/23/23 17:42, Cherry Pang wrote:
Reply to list also.
Ccing list.
Firstly, I apologize for my mistake. I meant PostgreSQL, not SQLite.
Secondly, when it comes to fuzzing tests, it refers to using
automatically generated inputs to test the security and stability of
software. In the realm o
On 11/23/23 11:18, Atul Kumar wrote:
I have postgres 12 running in centos 7 on my two machines, recently I
changed the authentication of entries of pg_hba.conf to
scram-sha-256 for localhost.
Since then in my one machine, I have started getting the below error
when I use command "psql postgre
Ron Johnson writes:
> Out of curiosity, what is the point of adding the "true" predicate no
> matter the position? Maybe I've created an incorrect truth table, but
> "true AND" (and "AND true") don't make any logical difference when added
> to (ekey > 0)*.*
Not only does it not make any logical
Am 23.11.23 um 20:18 schrieb Atul Kumar:
I am not able to understand that my both machines are resolved to IPV6
then why is my first machine is throwing this error ?
please check
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/network-flow-analysis/21
Out of curiosity, what is the point of adding the "true" predicate no
matter the position? Maybe I've created an incorrect truth table, but
"true AND" (and "AND true") don't make any logical difference when added
to (ekey > 0)*.*
On Thu, Nov 23, 2023 at 11:56 AM Zahir Lalani
wrote:
> Hello all
I have postgres 12 running in centos 7 on my two machines, recently I
changed the authentication of entries of pg_hba.conf to scram-sha-256 for
localhost.
Since then in my one machine, I have started getting the below error when I
use command "psql postgres"
no pg_hba.conf entry for host "::1", u
On Thursday, November 23, 2023, Tom Lane wrote:
> "David G. Johnston" writes:
> > On Thursday, November 23, 2023, Tom Lane wrote:
> >> This question is unanswerable as given. You have not even defined
> >> what you mean by "fail" (error? wrong query result?), let alone
> >> provided enough det
"David G. Johnston" writes:
> On Thursday, November 23, 2023, Tom Lane wrote:
>> This question is unanswerable as given. You have not even defined
>> what you mean by "fail" (error? wrong query result?), let alone
>> provided enough detail for someone else to reproduce the problem.
> The OP com
On Thursday, November 23, 2023, Tom Lane wrote:
> Zahir Lalani writes:
> > Got a really weird problem with shortcut processing on one server.
>
> This question is unanswerable as given. You have not even defined
> what you mean by "fail" (error? wrong query result?), let alone
> provided enough
Zahir Lalani writes:
> Got a really weird problem with shortcut processing on one server.
This question is unanswerable as given. You have not even defined
what you mean by "fail" (error? wrong query result?), let alone
provided enough detail for someone else to reproduce the problem.
On 11/23/23 08:55, Zahir Lalani wrote:
Hello all
Got a really weird problem with shortcut processing on one server.
We have just upgraded to PG14 from PG11. The following code works as
expected on our primary Dev server, and we recently upgraded our QA
server to the same level. However in thi
Hello all
Got a really weird problem with shortcut processing on one server.
We have just upgraded to PG14 from PG11. The following code works as expected
on our primary Dev server, and we recently upgraded our QA server to the same
level. However in this case the shortcut processing seems brok
Thanks for the explanation.
On Thu, Nov 23, 2023 at 10:55 AM Tom Lane wrote:
> Ron Johnson writes:
> > On Thu, Nov 23, 2023 at 3:37 AM Laurenz Albe
> > wrote:
> >> You can avoidwriting WAL if you set "wal_level = minimal", restart
> >> PostgreSQL
> >> and restore the dump with the --single-tra
On 11/23/23 06:02, Anthony Apollis wrote:
Please assist me?
I am trying to calculate
Current Period Prior Period Movement
from my data, the date columns are:
image.png
Please check my code for any errors, code runs, i just want to make sure
it does what it's supposed to do.
Sinc
Ron Johnson writes:
> On Thu, Nov 23, 2023 at 3:37 AM Laurenz Albe
> wrote:
>> You can avoidwriting WAL if you set "wal_level = minimal", restart
>> PostgreSQL
>> and restore the dump with the --single-transaction option.
> Why does "--single-transaction" prevent WAL writes? I'd expect _more_
>
On 11/22/23 22:56, Cherry Pang wrote:
hello!
I am a novice enthusiast in the field of fuzz testing and have an
interest in conducting fuzz testing for the SQLite protocol. I
understand that testing the logic bugs or crash bugs in Data
Manipulation Language (DML) functionalities differs signifi
On Thu, Nov 23, 2023 at 2:29 PM Daniel Westermann (DWE) <
daniel.westerm...@dbi-services.com> wrote:
> smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group
> by crart_id, chemin having count(*) > 1;
> crart_id | chemin | count
> -++---
> 350546300
Am 22.11.23 um 17:13 schrieb Ron Johnson:
Pg 9.6.24, which will change by April, but not now.
out of support since many years!
Here are the only non-default config values which I can think of that
are relevant to the question at hand:
shared_buffers = 16GB
work_mem = 300MB
maintenanc
On Thu, Nov 23, 2023 at 3:48 AM Laurenz Albe
wrote:
> On Wed, 2023-11-22 at 11:13 -0500, Ron Johnson wrote:
> > Pg 9.6.24, which will change by April, but not now.
> >
> > We've got some huge (2200 line long) queries that are many UNIONs
> of complicated
> > queries hitting inheritance-partitione
On Thu, Nov 23, 2023 at 3:37 AM Laurenz Albe
wrote:
[snip]
>
> You can avoidwriting WAL if you set "wal_level = minimal", restart
> PostgreSQL
> and restore the dump with the --single-transaction option.
>
Why does "--single-transaction" prevent WAL writes? I'd expect _more_
pg_wal growth from
Please assist me?
I am trying to calculate
Current Period Prior Period Movement from my data, the date columns
are:
[image: image.png]
Please check my code for any errors, code runs, i just want to make sure it
does what it's supposed to do.
-- View: model.IMETA_ZTRB_BRACS_Model_TA_BW_View
>smrdbprod=# select count(*) from smrr_mgr.formula where crart_id = 2150718
>and chemin = '@';
> count
>---
> 1
>(1 row)
>
>smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by
>crart_id, chemin having count(*) > 1;
> crart_id | chemin | count
>--+
Hi,
I have a very strange behavior on 14.10.
smrdbprod=# select version();
version
--
PostgreSQL 14.10 on x86_64-pc-linux-gnu, compiled by gcc
On Thu, 2023-11-23 at 09:32 +, Vijaykumar Patil wrote:
> LOG: entering standby mode
> LOG: consistent recovery state reached at 1/27000100
> LOG: database system is ready to accept read-only connections
> LOG: started streaming WAL from primary at 1/2800 on timeline 36
> LOG: recovery
Hi Laurenz,
Please find the log details :-
2023-11-22 04:32:47 EST [1278503]: user=,db=,app=,client=LOG: entering standby
mode
ERROR: [037]: archive-get command requires option: pg1-path
HINT: does this stanza exist?
ERROR: [037]: archive-get command requires option: pg1-path
HINT
On Wed, 2023-11-22 at 11:13 -0500, Ron Johnson wrote:
> Pg 9.6.24, which will change by April, but not now.
>
> We've got some huge (2200 line long) queries that are many UNIONs of
> complicated
> queries hitting inheritance-partitioned tables. They can't be refactored
> immediately,
> and mayb
On Wed, 2023-11-22 at 08:57 +, Vijaykumar Patil wrote:
> I have created streaming replication with two nodes .
>
> One is primary and 2nd one is standby but after doing any DML or DDL
> operation on
> primary Walreceiver process is terminated on standby and standby database is
> opening in r
On Wed, 2023-11-22 at 23:33 +0530, Atul Kumar wrote:
> Please can you share any command for due diligence whether ip is resolved to
> ipv6 ?.
Not a lot of diligence is due to figure out that you can use
ping localhost
Yours,
Laurenz Albe
On Wed, 2023-11-22 at 16:55 +, Efrain J. Berdecia wrote:
> Thanks, the issue we've run into, which I guess could be really a setup
> issue, with running a COPY command while executing pg_restore,
> is that if we are restoring a large table (bigger than 500GB) our WAL
> directory can grow to b
hello!
I am a novice enthusiast in the field of fuzz testing and have an interest
in conducting fuzz testing for the SQLite protocol. I understand that
testing the logic bugs or crash bugs in Data Manipulation Language (DML)
functionalities differs significantly, and as such, I am unsure about the
30 matches
Mail list logo
