On Wed, Mar 17, 2021 at 01:09:24AM +0200, Andrus wrote:
> Should I try install Visual C++ , compile and replace postgres.exe file in
> AMD server.
Mostly. That's the annoying part:
https://www.postgresql.org/docs/devel/install-windows-full.html
It is also possible to compile the code on a first
Hi!
>Those ten seconds are coming from RemoveXlogFile(), where pgrename()
loops 100 times for 100ms before giving up. So something holding up
the file's handle prevents the removal to happen.
I tried sysinternals
handle pg_wal
It shows that only postgres processes have opened files in pg_wa
On Tue, Mar 16, 2021 at 01:59:07PM +0200, Andrus wrote:
> I have two Windows 2019 servers. In Intel Xeon Cold 6226R server it occurs
> after every 10 seconds. Last logs:
>
> 2021-03-16 13:48:12 EET checkpointer LOG: could not rename file
> "pg_wal/000100110097": Permission denied
Ruslan writes:
> I wrote parser for COPY binary encoding. Everything is great but one thing
> worries me. It seems like the time offset field has reversed digit sign.
> I'm referring to this function
> https://github.com/postgres/postgres/blob/REL_13_STABLE/src/backend/utils/adt/date.c#L2150-L215
Hi folks,
Apologies if it's the wrong place to ask. I have a question for postgres
developers.
I wrote parser for COPY binary encoding. Everything is great but one thing
worries me. It seems like the time offset field has reversed digit sign.
I'm referring to this function
https://github.com/pos
So, right now I have configuration of replication slots:
On master:
postgres=# select * from pg_replication_slots ;
slot_name | plugin | slot_type | datoid | database | temporary |
active | active_pid | xmin | catalog_xmin | restart_lsn |
confirmed_flush_lsn
--++--
Andrew Anderson writes:
>> What's using it?
> As I think, streaming replication is using this slot. Does anybody know how
> to fix it ?
Unless you need another replica that's downstream of the standby,
you should not be maintaining a replication slot on the standby.
There may be a way to have a
You're right, restart_lsn on slave does not changes.
> What's using it?
As I think, streaming replication is using this slot. Does anybody know how
to fix it ?
вт, 16 мар. 2021 г. в 17:44, Tom Lane :
> Andrew Anderson writes:
> >> - replication slot (you said that is not it)
>
> > The replicatio
Thank you all for taking the time to respond. As always, great community
support.
On Mon, Mar 15, 2021 at 5:10 PM Tom Lane wrote:
> Fred Habash writes:
> > Based on my research, There are the options I have identified to allow
> user
> > 'John' to drop a trigger on a table owner by 'Chad' ..
>
Andrew Anderson writes:
>> - replication slot (you said that is not it)
> The replication slot is the same on master:
> postgres=# select * from pg_replication_slots ;
> slot_name | plugin | slot_type | datoid | database | temporary |
> active | active_pid | xmin | catalog_xmin | restart_
On Tue, 2021-03-16 at 16:11 +0200, Andrew Anderson wrote:
> postgres=# show wal_keep_segments;
> wal_keep_segments
> ---
> 32
> (1 row)
Ok, then I am out of ideas.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
> - replication slot (you said that is not it)
The replication slot is the same on master:
postgres=# select * from pg_replication_slots ;
slot_name | plugin | slot_type | datoid | database | temporary |
active | active_pid | xmin | catalog_xmin | restart_lsn |
confirmed_flush_lsn
On Tue, 2021-03-16 at 15:31 +0200, Andrew Anderson wrote:
> вт, 16 мар. 2021 г. в 14:21, Laurenz Albe :
> > On Tue, 2021-03-16 at 09:49 +0200, Andrew Anderson wrote:
> > > 2021-03-16 09:44:03.997 EET [97581] [] [] [] []DEBUG: attempting to
> > > remove WAL segments older than log file 000
In pg_wal catalog there is no file by that name:
$ ls pg_wal/ | grep 013E0097
$
but there is files with very old time of creation:
$ ls -lart pg_wal/
total 30933220
-rw--- 1 postgres postgres 299 Dec 30 05:44
0002013E0097.0108.backup
-rw--- 1 postgres
On Tue, 2021-03-16 at 09:49 +0200, Andrew Anderson wrote:
> 2021-03-16 09:44:03.997 EET [97581] [] [] [] []DEBUG: attempting to remove
> WAL segments older than log file 013E0097
That was the entry I was hoping to see.
So, are all older WAL segments deleted or recycled?
Is that
Hi
Where you getting the Postgres binaries from?
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
If we provide a patch, could you test it?
Yes
This would require that you do your own build,
unfortunately, but having an environment where this is easily
reproducible is a
Hi Andrus,
On Wed, Mar 10, 2021 at 03:20:47PM +0200, Andrus wrote:
> After re-starting postgres service problem persists.
Where you getting the Postgres binaries from? If we provide a patch,
could you test it? This would require that you do your own build,
unfortunately, but having an environme
postgres=# show checkpoint_timeout;
checkpoint_timeout
5min
(1 row)
Added log_checkpoints = on to postgresql.conf on slave, and here is the log
from slave:
2021-03-16 09:43:42.509 EET [97581] [] [] [] []DEBUG: checkpointer updated
shared memory configuration values
2021-03
The situation didn't changes, WAL segments not removing automatically. The
streaming replication works fine, here is the log files:
from master:
2021-03-16 06:28:51.787 EET [94341] [walreceiver] [pgadmin] [[unknown]]
[2.2.2.2]DEBUG: write 145/ED10A8E8 flush 145/ED10A8E8 apply 145/ED10A8E8
2021-03
On Tue, 2021-03-16 at 09:33 +0200, Andrew Anderson wrote:
> The situation didn't changes, WAL segments not removing automatically.
> The streaming replication works fine, here is the log files:
>
> from master:
> [log with debug2, but without WAL segment delete messages]
Could you set "log_checkp
20 matches
Mail list logo
