Hello All,
I am trying to configure basic monitoring for our postgres database using
data dictionary views as below. Want to understand if these are accurate or
if I am making any mistakes here by querying this way. And also ,
it's something we want to do for the application specific sessions/queri
I got the error:
Wal control functions cannot be executed during recovery.
I need the solution that should in when streaming replication is
configured.
My postgres version is 13.20
Regards.
On Tue, 8 Apr 2025, 17:32 Kashif Zeeshan, wrote:
> Hi Atul
>
> Start by looking at the current WAL LS
You cannot connect to the Primary while connected to the Replica, except
via postgres_fdw. Even then, it might not work, since the replica
replicates _fdw definitions.
These exist on the primary:
pg_current_wal_lsn()
pg_replication_slots
pg_stat_replication
These exist on the replica:
pg_last_
On Tue, Apr 8, 2025 at 9:40 PM Achilleas Mantzios - cloud <
a.mantz...@cloud.gatewaynet.com> wrote:
> Hi
>
> timescaledb seemed mature, but also exotic, allow me the term. No way to
> use native logical replication, shortage of options to run on premise or
> self hosted, which leaves us with thos
On 8/4/25 20:37, Amitabh Kant wrote:
On Tue, Apr 8, 2025 at 9:40 PM Achilleas Mantzios - cloud
wrote:
Hi
timescaledb seemed mature, but also exotic, allow me the term. No
way to
use native logical replication, shortage of options to run on
premise or
self hosted,
In streaming replication What is the way to check which "WAL file" is
currently in use in primary and in standby ?
Regards.
On 4/8/25 13:58, Ancoron Luciferis wrote:
On 2025-04-07 15:21, Joe Conway wrote:
On 4/5/25 07:53, Ancoron Luciferis wrote:
I've been investigating this topic every now and then but to this day
have not come to a setup that consistently leads to a PostgreSQL backend
process receiving an allocati
I know I can create user steve_test with password testpassword122 as md5 by
doing:
select 'md5'||md5('testpassword122steve_test'); Returns -->
md5eb7e220574bf85096ee99370ad67cbd3
CREATE USER steve_test WITH PASSWORD 'md5eb7e220574bf85096ee99370ad67cbd3';
And then I can login as steve_test wi
On 4/9/25 04:50, Amitabh Kant wrote:
Thank you, I meant the paid/supported service not the community
version. Which of the two do you use?
I use the community version.
On 4/9/25 05:23, Brent Wood wrote:
I also use the free community edition on internal servers, but under
Ubuntu.
On Mon, Apr 7, 2025 at 5:32 AM KK CHN wrote:
> *ERROR: [082]: WAL segment 000101EB00*4B was not archived
> before the 6ms timeout
>
This is the part you need to focus on. Look at your Postgres logs and find
out why the archiver is failing. You can also test this without trying a
Hi
in continuation of "Ideas about presenting data coming from sensors"
https://www.postgresql.org/message-id/flat/8d2dd92a-da16-435b-a38e-fe72191fc9d1%40cloud.gatewaynet.com
we got the system working in single tables fashion (3 kinds of them),
since no timeseries solution seemed to fit 100% al
Hi Atul
Start by looking at the current WAL LSN and insert LSN. The
pg_current_wal_lsn is the location of the last write. The
pg_current_wal_insert_lsn is the logical location and reflects data in the
buffer that has not been written to disk. There is also a flush value that
shows what has been wr
On 2025-04-07 15:21, Joe Conway wrote:
On 4/5/25 07:53, Ancoron Luciferis wrote:
I've been investigating this topic every now and then but to this day
have not come to a setup that consistently leads to a PostgreSQL backend
process receiving an allocation error instead of being killed externally
On Tue, Apr 8, 2025 at 11:29 PM Achilleas Mantzios <
a.mantz...@cloud.gatewaynet.com> wrote:
>
> On 8/4/25 20:37, Amitabh Kant wrote:
>
> On Tue, Apr 8, 2025 at 9:40 PM Achilleas Mantzios - cloud <
> a.mantz...@cloud.gatewaynet.com> wrote:
>
>> Hi
>>
>> timescaledb seemed mature, but also exotic,
On 4/5/25 07:53, Ancoron Luciferis wrote:
I've been investigating this topic every now and then but to this day
have not come to a setup that consistently leads to a PostgreSQL backend
process receiving an allocation error instead of being killed externally
by the OOM killer.
Why this is a probl
15 matches
Mail list logo
