[GENERAL] Is it safe to create foreign keys beforehand when logical replication is used?

Hi, I'm trying to figure out whether the following is safe or not on all conditions with logical replication: -- on the source (localhost:5432), create the tables which have foreign keys among them -- load some data and create publication CREATE TABLE rep_test (a int PRIMARY KEY); CREATE TABLE

Re: [GENERAL] A question on pg_stat_subscription view

s, > Gunce > > On 22 Oct 2017 Sun at 11:11 Önder Kalacı wrote: > >> Hi, >> >> I'm trying to understand the view pg_stat_subscription. What is the >> `latest_end_lsn` column? Is that the latest lsn flushed or lsn replied or >> something else? >> >> Thanks! >> > -- > Gunce Kaya >

[GENERAL] A question on pg_stat_subscription view

Hi, I'm trying to understand the view pg_stat_subscription. What is the `latest_end_lsn` column? Is that the latest lsn flushed or lsn replied or something else? Thanks!