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_

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, >

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)

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

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

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

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 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