\d t: ERROR: XX000: cache lookup failed for relation

Is that considered an actionable problem? Encountered while trying to reproduce the vacuum full pg_statistic/toast_2619 bug; while running a loop around VAC FULL and more in another session: [1]- Running { time sh -ec 'while :; do psql --port 5678 postgres -qc "VACUUM FULL pg_toa

Re: Fast logical replication jump start with PG 10

On Sat, May 26, 2018 at 1:27 PM, Adrian Klaver wrote: > On 05/26/2018 06:23 AM, Olivier Gautherot wrote: > >> On Sat, May 26, 2018 at 12:11 AM, Adrian Klaver < >> adrian.kla...@aklaver.com > wrote: >> On 05/25/2018 06:35 PM, Olivier Gautherot wrote: >> [snip]

Re: Fast logical replication jump start with PG 10

On Fri, May 25, 2018 at 5:12 PM, Olivier Gautherot wrote: Is there a way to speed up the replication or should I rather stick to > streaming replication? As I have only 1 database on the server, it would > not be a show-stopper. > You have a method that works, and a client that is already twitch

Re: Fast logical replication jump start with PG 10

Hi, El 26/05/18 a las 14:27, Adrian Klaver escribió: > > I am still learning what logical replication is capable of so take the > following with that in mind. > > 1) I used > pg_basebackup(www.postgresql.org/docs/10/static/app-pgbasebackup.html) > to create a new $DATA directory for a replica in

Re: Fast logical replication jump start with PG 10

On 05/26/2018 06:23 AM, Olivier Gautherot wrote: Hi Adrian! On Sat, May 26, 2018 at 12:11 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 05/25/2018 06:35 PM, Olivier Gautherot wrote: Hi Adrian, thanks for your reply. Here is the clarification. 1) It is in

Re: Fast logical replication jump start with PG 10

On 05/26/2018 06:23 AM, Olivier Gautherot wrote: Hi Adrian! On Sat, May 26, 2018 at 12:11 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 05/25/2018 06:35 PM, Olivier Gautherot wrote: Hi Adrian, thanks for your reply. Here is the clarification. 1) It is in

Re: UPDATE from CTE syntax error

On 05/26/2018 09:21 AM, Alexander Farber wrote: Good evening, I am struggling with the syntax, please help. This query with a CTE works ok: WITH      

Re: UPDATE from CTE syntax error

Oops, I am sorry for the formatting - Mac + Terminal + Gmail :-/

UPDATE from CTE syntax error

Good evening, I am struggling with the syntax, please help. This query with a CTE works ok: WITH extract_letters AS ( SELECT mid, STRING_AGG(x->>'letter', '') AS letters

Re: Fast logical replication jump start with PG 10

Hi Adrian! On Sat, May 26, 2018 at 12:11 AM, Adrian Klaver wrote: > On 05/25/2018 06:35 PM, Olivier Gautherot wrote: > >> Hi Adrian, thanks for your reply. Here is the clarification. >> >> 1) It is indeed a pg_upgrade from 9.2 to 10.4. Depending on the test >> machine, it runs in between 15 and

Re: PostgreSQL backup issue

> > > I would conclude that pg-basebackup is placing its output in stderr > instead of stdout then... > > > Thanks. Modifying the last potion to '>>$logfile 2>&1' worked. Regards, Jayadevan