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
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
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 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 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
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 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,
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
>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
>--+
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
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
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
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 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
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
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/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
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
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
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
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 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
"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:
> "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
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
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
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
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
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
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
30 matches
Mail list logo
