Fwd: message log merge (streaming replication)

2022-06-08 Thread Peter Adlersburg
Dear fellow DBA's, While troubleshooting one of our production replication clusters (phys. streaming replication using the patroni framework) I stumbled over a - at least for me - strange phenomenon in the postgres logs of the two cluster members: *** node-01 *** [postgres@db-node-01 main]$ gre

Re: FATAL: could not receive timeline history file from the primary server: ERROR: could not open file "pg_wal/0000000x.history": No such file or directory

2022-06-08 Thread Kyotaro Horiguchi
At Wed, 8 Jun 2022 16:43:55 +, pgdba pgdba wrote in > hello everyone, > > I want to install a two-node streaming replication with postgresql version > 11, but I'm getting this error when starting the service of my slave node. > Can you support me? I couldn't find the solution. > > FATAL:

Re:

2022-06-08 Thread Ian Lawrence Barwick
2022年6月8日(水) 19:51 Jim McNamara : > > Hi - > > Does anyone use the gawk extension? I think it is the coolest thing. > > I see that it installed .so files on my system from the fedora package > manager but there is no .sql file or control file in the extension directory. > > I searched with kfind u

Re: gawk extension linux missing stuff in package manager fedora 36

2022-06-08 Thread Daniel Verite
Jim McNamara wrote: > The package doesn't contain the sql or control file in > /usr/share/pgsql/extensions. It did install .so files though. I ran sudo > dnf repoquery -l package name and looked at the files. It's probably this library: http://gawkextlib.sourceforge.net/pgsql/gawk-pgsql.h

gawk extension linux missing stuff in package manager fedora 36

2022-06-08 Thread Jim McNamara
Hi guys- I forgot to put a subject and then when I went to correct it failed to put a subject yet again. Sorry about that. I installed gawk postgresql extension with my fedora package manager. I'd like to use create extension. The package doesn't contain the sql or control file in /usr/share/pgs

FATAL: could not receive timeline history file from the primary server: ERROR: could not open file "pg_wal/0000000x.history": No such file or directory

2022-06-08 Thread pgdba pgdba
hello everyone, I want to install a two-node streaming replication with postgresql version 11, but I'm getting this error when starting the service of my slave node. Can you support me? I couldn't find the solution. FATAL: could not receive timeline history file from the primary server: ERROR:

Fwd:

2022-06-08 Thread Jim McNamara
gawk extension for postgresql -- Forwarded message - From: Jim McNamara Date: Wed, Jun 8, 2022 at 6:51 AM Subject: To: Hi - Does anyone use the gawk extension? I think it is the coolest thing. I see that it installed .so files on my system from the fedora package manager but

[no subject]

2022-06-08 Thread Jim McNamara
Hi - Does anyone use the gawk extension? I think it is the coolest thing. I see that it installed .so files on my system from the fedora package manager but there is no .sql file or control file in the extension directory. I searched with kfind utility and didn't find anything. I can't seem to