On Thu, Oct 12, 2023 at 09:42:47AM +0900, Abhishek Bhola wrote:
> For most of the Postgres errors, translating it to WARNING level in syslog
> works, however, I wanted to translate *ERROR codes XX000/1/2* in Postgres
> to be ERROR in syslog as well, so that it triggers the alert system and I
> can
Hi
The Postgres errors when sent to syslog have their severity levels
translated as follows:
https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-SEVERITY-LEVELS
I have a system which raises an alert every time syslog receives an ERROR
(or higher severity level).
On 10/11/23 17:24, Atul Kumar wrote:
Hi,
I have postgres 12 running on centos 7.
i have configured streaming replication having one primary and one standby.
It is strange to see that the logs are not getting generated on standby.
I have checked the log directory using show command and it
Hi,
I have postgres 12 running on centos 7.
i have configured streaming replication having one primary and one standby.
It is strange to see that the logs are not getting generated on standby.
I have checked the log directory using show command and it shows the
correct output.
I also
On 10/11/23 12:07, Ron wrote:
On 10/11/23 09:52, Eugen Konkov wrote:
But why do you want to do that, if all that you have to do is specify
"recovery_target = 'immediate'" to recover to the end of the backup?
Because automation scripts do not know if transactions are available
after some point
That's why you /attach/ files, not paste text.
On 10/11/23 16:19, Sasmit Utkarsh wrote:
Thanks Tom, It did work, and yeah I do have indentation in my editor,
there was some formatting issue due to the copy and paste of the code.
:)
Regards,
Sasmit Utkarsh
+91-7674022625
On Thu, Oct 12, 2023
Thanks Tom, It did work, and yeah I do have indentation in my editor, there
was some formatting issue due to the copy and paste of the code.
:)
Regards,
Sasmit Utkarsh
+91-7674022625
On Thu, Oct 12, 2023 at 2:07 AM Tom Lane wrote:
> Sasmit Utkarsh writes:
> > Like for an ex: I have provided
Sasmit Utkarsh writes:
> Like for an ex: I have provided the test run for a file which has 4
> duplicate entries in the input file and below is the leak reported. I have
> followed
> consistently using PQclear to free all PGresult objects.
No you haven't: you've got two PQexec-something calls
HI Adrian,
I have a main program which actually parses the input data from the files
and inserts them to a table in postgres db. The input can have many
duplicates and we cannot avoid it for now but we have to achieve the
insertions of the records as quickly as possible. Below are the functions
On 10/11/23 12:15, Sasmit Utkarsh wrote:
Hi Team,
I'm trying to insert multiple duplicate rows into the table using libpq
in C. I'm getting a memory leak reported from addresssanitizer tool.
Please let me know if i can share the code snippet
That is the only way you are going to get an
Hi Team,
I'm trying to insert multiple duplicate rows into the table using libpq in
C. I'm getting a memory leak reported from addresssanitizer tool. Please
let me know if i can share the code snippet
Regards,
Sasmit Utkarsh
+91-7674022625
Hello,
I am new to PostgreSQL and having to migrate a Cassandra cluster to PostgreSQL.
Have a reasonable amount of experience with MySQL and use Master -> Master
MySQL replication quite successfully.
I am trying to understand what configuration/option to pick for PostgreSQL that
will provide
Tables (on the primary) pg_stat_replication and (on the secondary)
pg_stat_wal_receiver do that for you.
On 10/11/23 12:50, Atul Kumar wrote:
Yes, I meant streamed, I need to log those wal files that are getting
streamed and replayed on standby servers in error logs of primary as well
as
Yes, I meant streamed, I need to log those wal files that are getting
streamed and replayed on standby servers in error logs of primary as well
as standby servers.
So that I can cross check that whichever file is streamed has been replayed
on standby.
I need to keep a track of these wal files in
On 10/11/23 09:52, Eugen Konkov wrote:
But why do you want to do that, if all that you have to do is specify
"recovery_target = 'immediate'" to recover to the end of the backup?
Because automation scripts do not know if transactions are available
after some point in time or not. But automation
On Wed, 2023-10-11 at 22:15 +0530, Atul Kumar wrote:
> I need to log all wal files that are getting transferred to all standby
> servers in the postgresql error logs.
WAL files are not transferred to standby servers...
WAL is streamed, so what would you want to log?
Yours,
Laurenz Albe
On Wed, 2023-10-11 at 11:34 +, Zwettler Markus (OIZ) wrote:
> if you want to retrieve data by means of pg_dump / pg_restore from a database
> with
> locale de_CH.UTF8 into a database with locale en_US.UTF8 are there any other
> things
> to consider than the behavior implications mentioned
Hi,
I need to log all wal files that are getting transferred to all standby
servers in the postgresql error logs.
I also need to log those wal files that are being applied in standbys.
My postgres version is 12 and running on centos 7.
I am unable to understand the proper parameters in the
>But why do you want to do that, if all that you have to do is specify
"recovery_target = 'immediate'" to recover to the end of the backup?
Because automation scripts do not know if transactions are available
after some point in time or not. But automation scripts know that
backup was completed
On 10/11/23 04:46, Anthony Apollis wrote:
I have a table that i populate using joins.
One of the tables don't insert its data. Tables are:
My Test to see if the data has been inserted:
image.png
I get blanks or no output for above test.
My Source Tables have data:
image.png
Can't seem to
Israr Khan writes:
> I am facing the postgresql database access issue after doing vacuum on a
> table.
There has to have been more to it than that.
> Error : FATAL: cache lookup failed for relation 1247
1247 is pg_type, so this looks like rather nasty catalog corruption.
If you're really
hi,
if you want to retrieve data by means of pg_dump / pg_restore from a database
with locale de_CH.UTF8 into a database with locale en_US.UTF8 are there any
other things to consider than the behavior implications mentioned in the
documentation:
On Wed, 2023-10-11 at 14:08 +0300, Олег Самойлов wrote:
> There are two common practice to drop partition from partitioned table: just
> drop or detach-drop.
> But simple drop don't work if exist foreign key. Example script attached.
That is working as designed. You cannot detach a partition of
On 2023-Oct-11, Олег Самойлов wrote:
> There are two common practice to drop partition from partitioned
> table: just drop or detach-drop. But simple drop don't work if exist
> foreign key. Example script attached.
Yeah. Detach it first, then you should be able to drop it.
> psql:test.sql:15:
Hi all.
There are two common practice to drop partition from partitioned table: just
drop or detach-drop. But simple drop don't work if exist foreign key. Example
script attached.
test.sql
Description: Binary data
$ psql -p 5416 -a -f test.sql
\setenv PSQL_EDITOR 'vim'
\setenv
Hey PgSQL ,
I am facing the postgresql database access issue after doing vacuum on a
table.
Please help and suggest as soon as possible.
Error : FATAL: cache lookup failed for relation 1247
Thank you
Israr
--
Disclaimer : This message (including any attachments) is sent on behalf of
Amnex
On Tue, 2023-10-10 at 11:46 -0400, Eugen Konkov wrote:
> [wants to avoid
> FATAL: recovery ended before configured recovery target was reached
> that is issued in v13 and later]
>
> 1. Why here (in experiment2.txt) redo done at 0/728 when recovery
> target name "2023-10-10 15:07:37" is at
27 matches
Mail list logo
