Hello,
I have some questions about the PostgreSQL database:
1- If I want to distribute the PostgreSQL database on several servers at the
same time. what should I do? Something similar to high availability.
2- Is there any special guard to protect PostgreSQL?
Thank you.
Hi. The doc states:
>From https://www.postgresql.org/docs/current/libpq-copy.html:
> Data is always returned one data row at a time;
> if only a partial row is available, it is not returned
I'm doing a COPY TO STDOUT WITH (FORMAT BINARY).
The record format allows up to int16_t columns. (16K or 32
Hi,
For the context, debug_parallel_query has three states (according to the
documentation):
on: use parallel if safe
off:use parallel if improves performance
regress:use parallel if safe + suppress context line + hide
gather node in explain output
I am looking for
On Tue, 27 Feb 2024 at 23:23, Rafsun Masud Prince
wrote:
> I am looking for a combination of the 'off' and 'regress' state, which is:
> use parallel if improves performance + suppress context line (if
> parallel is used)
>
> Our project, Apache AGE, has a regression test for cypher MATCH queri
Hi.
For the first time, I'm checking the OIDs returned
(via the result set's PQftype API), by "regular" SELECT:
`select ... from tab`
and by a COPY TO BINARY:
`COPY (
select ...
from tab
) TO STDOUT WITH (FORMAT BINARY)`
And to my surprise, they are not!
The ones from the COPY are all zero
On Tue, Feb 27, 2024 at 3:43 AM Jason Long wrote:
> Hello,
> I have some questions about the PostgreSQL database:
>
> 1- If I want to distribute the PostgreSQL database on several servers at
> the same time. what should I do? Something similar to high availability.
>
HA replication is native in
Hi,1- Both split-brain protection and security. Any tool?
2- Consider a database related to a website, which data is regularly entered.
Now you want to transfer this database to another server. What's the solution?
On Tue, Feb 27, 2024 at 5:39 PM, Ron Johnson wrote:
On Tue, Feb 27, 2024
On 2/27/24 07:08, Jason Long wrote:
Hi,
1- Both split-brain protection and security. Any tool?
2- Consider a database related to a website, which data is regularly
entered. Now you want to transfer this database to another server.
What's the solution?
https://www.postgresql.org/docs/current/
On 2/27/24 07:50, Siraj G wrote:
Hello All!
Can you please assist me with highlighting the bad area in the execution
plan attached. I am kind of new to PgSQL and trying to get some help
with troubleshooting a query.
Little background. DB was migrated from Oracle to AlloyDB. The SQL that
u
Hi,Should I read
https://www.postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP
for question number 2?
On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver
wrote: On 2/27/24 07:08, Jason Long wrote:
> Hi,
> 1- Both split-brain protection and security. Any tool?
>
> 2- Consider
Dominique Devienne writes:
> For the first time, I'm checking the OIDs returned
> (via the result set's PQftype API), by "regular" SELECT:
> ...
> And to my surprise, they are not!
> The ones from the COPY are all zeros.
> Is that normal?
The CopyInResponse and CopyOutResponse messages don't car
Hi
I am surprised that my before insert trigger function does not insert
any rows into NODE_GOOD.
I was under the impression that the trigger function would do the insert
with the new and possibly adapted values. In my case, to me at least, it
is very simple. Only records of node type "Drop-
On Tue, Feb 27, 2024 at 6:11 PM Tom Lane wrote:
> Dominique Devienne writes:
> > For the first time, I'm checking the OIDs returned
> > (via the result set's PQftype API), by "regular" SELECT:
> > ...
> > And to my surprise, they are not!
> > The ones from the COPY are all zeros.
>
> > Is that n
I used this web page to implement hot standby via physical streaming. This
command sets up everything for you:
pg_basebackup \
--pgdata=$PGDATA \
--dbname=service=basebackup \
--verbose --progress \
--checkpoint=fast \
--write-recovery-co
You may need to expand on / rephrase question 2.
On 2/27/24 9:49 AM, Thiemo Kellner wrote:
Hi
I am surprised that my before insert trigger function does not insert
any rows into NODE_GOOD.
I was under the impression that the trigger function would do the
insert with the new and possibly adapted values. In my case, to me at
least, it is v
Hi. I just tried adding the xmin pseudo-column to my COPY,
and I get an error. Using a regular SELECT works fine.
Is that normal? that's a `COPY tab(xmin, cols...) ...`
Do I need to switch to a `COPY (select xmin, cols... from tab) ...` to
access xmin?
And if I do that, any performance implicati
On 2024-Feb-27, Dominique Devienne wrote:
> Hi. I just tried adding the xmin pseudo-column to my COPY,
> and I get an error.
I suggest you find some other way to achieve whatever it is you think
you'll achieve with this. It's not reliable and you'll regret it
eventually. Maybe take a step back
On Tue, Feb 27, 2024 at 7:26 PM Alvaro Herrera
wrote:
> On 2024-Feb-27, Dominique Devienne wrote:
>
> > Hi. I just tried adding the xmin pseudo-column to my COPY,
> > and I get an error.
>
> I suggest you find some other way to achieve whatever it is you think
> you'll achieve with this. It's no
On Wed, Feb 21, 2024 at 5:29 AM Adrian Klaver
wrote:
> > 4)Never created or maintained any partition table in postgres. Here we
> > want to daily range partition the both tables based on column
> > "PARENT_CREATE_TIMESTAMP", so is it advisable to create the individual
> > future partitions post t
Thanks.
27.02.2024 19:09:50 Adrian Klaver :
>
> On 2/27/24 9:49 AM, Thiemo Kellner wrote:
>> Hi
>>
>> I am surprised that my before insert trigger function does not insert any
>> rows into NODE_GOOD.
>>
>> I was under the impression that the trigger function would do the insert
>> with the n
Hi,
We have two different types of DBA group in current on-premise Oracle
databases, one who deploy code in prod and highest level of privileges
(i.e having write access to the database objects, performing backup
recovery, export/import and performing other database maintenance jobs etc).
and oth
On 2/27/24 12:40, veem v wrote:
Hi,
We have two different types of DBA group in current on-premise Oracle
databases, one who deploy code in prod and highest level of privileges
(i.e having write access to the database objects, performing backup
recovery, export/import and performing other dat
Hi,Do I have to run this command on the server where the main database is
located?
Suppose you want to transfer the database of a website like Amazon.com to a new
server and delete the old one. Many users are buying and selling on this
website at the same time and it is not possible to turn off
Am 27.02.2024 um 21:42 schrieb Adrian Klaver:
Also not sure what this:
select NODE_TYPE⠒NAME into V⠒NODE_TYPE⠒NAME
from NODE⠒V
where 1 = 1
and ID = new.NODE⠒ID
and 1 = 1;
is supposed to be doing especially the 1 = 1 tests?
The selec
On 2/27/24 14:11, Thiemo Kellner wrote:
Am 27.02.2024 um 21:42 schrieb Adrian Klaver:
Also not sure what this:
select NODE_TYPE⠒NAME into V⠒NODE_TYPE⠒NAME
from NODE⠒V
where 1 = 1
and ID = new.NODE⠒ID
and 1 = 1;
is supposed to be doin
Am 27.02.2024 um 23:20 schrieb Adrian Klaver:
On 2/27/24 14:11, Thiemo Kellner wrote:
It is a habit of mine to pad conditions in the where clause. This way,
it is easy to comment/uncomment parts of the clause for testing
purposes. Coming from Oracle, I missed that using "true" is also
possib
On 2/27/24 14:38, Thiemo Kellner wrote:
Am 27.02.2024 um 23:20 schrieb Adrian Klaver:
I am not sure, what you want me to show with your test case. And I am
not sure whether I could not make myself clear. Please bear with me if I
try to make things clearer with an example.
Your comment wa
UNOFFICIAL
Thank you for your reply. I can confirm there were no changes made to the
config of the replica.
We have had a further two occurrences of a walreceiver failing - each
occurrence is in a different cluster, however, both clusters are on the same
set of hardware. In each of the new case
On Wed, 28 Feb, 2024, 2:14 am Adrian Klaver,
wrote:
> On 2/27/24 12:40, veem v wrote:
> > Hi,
> > We have two different types of DBA group in current on-premise Oracle
> > databases, one who deploy code in prod and highest level of privileges
> > (i.e having write access to the database objects,
As before, I encourage you to read
https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/
.
On Tue, Feb 27, 2024 at 3:48 PM Jason Long wrote:
> Hi,
> Do I have to run this command on the server where the main database is
> located?
>
> Suppose you want to transfer the da
At Wed, 28 Feb 2024 03:23:37 +, Mark Schloss
wrote in
> Thank you for your reply. I can confirm there were no changes made to the
> config of the replica.
Okay.
> Is there any significance in the parameters in the commit record -
> 'inval msgs: catcache 21; sync'.
I think it is not relev
32 matches
Mail list logo
