RE: database crash during pgbench run

2018-12-11 Thread Greg Clough
hat OS you're on or how PostgreSQL was installed. Greg Clough. This e-mail, including accompanying communications and attachments, is strictly confidential and only for the intended recipient. Any retention, use or disclosure not expressly authorise

RE: pgbench results arent accurate

2018-12-14 Thread Greg Clough
> I installed a new postgres 9.6 on both of my machines. Where is your storage? Is it local, or on a SAN? A SAN will definitely have a cache, so possibly there is another layer of cache that you’re not accounting for. Greg Clough. This e-mail, includ

RE: upgrade to PG11 on secondary fails (no initdb was launched)

2019-05-23 Thread Greg Clough
> 2019-05-23 04:17:02 EDT 23593 DETAIL: The database cluster was initialized > with PG_CONTROL_VERSION 960, but the server was compiled with > PG_CONTROL_VERSION 1100. It appears that you have not upgraded the standby server, so either use "rsync" or simply destroy and rebuild it from scratc