Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts

2018-11-18 Thread Martín Marqués
El 18/11/18 a las 04:49, Gerhard Wiesinger escribió: > Hello, > > I just read that blog article and I think switching to REDO logic is not > a good idea. I think you got it the other way around. Postgres implementes REDO, that is, move forward by REDOing the changes which are stored in WAL files

pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

2018-11-18 Thread Achilleas Mantzios
Hello, The pgconf eu 2018 entry is missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations . I am afraid the more time passes since the event the harder to get people post their slides there, so pls update this ASAP.

Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts

2018-11-18 Thread Gerhard Wiesinger
On 18.11.2018 12:14, Martín Marqués wrote: El 18/11/18 a las 04:49, Gerhard Wiesinger escribió: Hello, I just read that blog article and I think switching to REDO logic is not a good idea. I think you got it the other way around. Postgres implementes REDO, that is, move forward by REDOing the

Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts

2018-11-18 Thread Achilleas Mantzios
On 18/11/18 2:04 μ.μ., Gerhard Wiesinger wrote: On 18.11.2018 12:14, Martín Marqués wrote: El 18/11/18 a las 04:49, Gerhard Wiesinger escribió: Hello, I just read that blog article and I think switching to REDO logic is not a good idea. I think you got it the other way around. Postgres im

New timeline when starting with a restored data dir

2018-11-18 Thread Yuri Kanivetsky
Hi, I'm trying to set up Barman, and I've noticed that PostgreSQL 10 creates a new timeline when starting with a restored data dir. Particularly, when WAL files are delivered via restore_command. When WAL files are copied to pg_wal dir, no new timeline is created. Is it to be expected? Can you exp

Logical replication did not use primary key as replica identity

2018-11-18 Thread Aleš Zelený
Hello, we are using logical replication for half a year and now, when we were adding new tables to replication, we have found a unexpected issue in log file. New tables were created on publication database (Ubuntu 16.04, PG 10.6) , subscription side is PostgreSQL 10.4 (Ubuntu 10.4-2.pgdg16.04+1)

RE: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

2018-11-18 Thread Charles Clavadetscher
Hello Achilleas > -Original Message- > From: Achilleas Mantzios > Sent: Sonntag, 18. November 2018 12:23 > To: pgsql-gene...@postgresql.org > Subject: pgconf eu 2018 slides entry missing from > https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentatio > ns > > Hello, >

Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

2018-11-18 Thread Achilleas Mantzios
On 19/11/18 8:48 π.μ., Charles Clavadetscher wrote: Hello Achilleas -Original Message- From: Achilleas Mantzios Sent: Sonntag, 18. November 2018 12:23 To: pgsql-gene...@postgresql.org Subject: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_