Re: Writing WAL files

2020-10-05 Thread Robert Inder
Indeed. Once upon a time, my signature use to be along the lines of So what? It's easier for me, so I'll do it! > > What's wrong with top posting? > It makes it hard to see comments in context. Robert. -- Robert Inder,0131 2

Re: Writing WAL files

2020-10-04 Thread Robert Inder
need to > change your configuration so that it uses streaming replication instead > of pg_standby and rsync, but that's far more convenient so it's a good > change anyway.) > Maybe, but it's forcing me to spend time understanding stuff t

Re: Writing WAL files

2020-10-04 Thread Robert Inder
On Sun, 4 Oct 2020 at 18:01, Adrian Klaver wrote: > On 10/4/20 9:54 AM, Robert Inder wrote: > > I am moving a database from PSQL 9 (!) on CentOS 6 to PSQL 12 on CentOS 7 > > It would help to know what the x in 9.x is? Before version 10 of > Postgres, the second number denot

Writing WAL files

2020-10-04 Thread Robert Inder
hanges. So what am I missing? How CAN I get postgresql 12 to write "unnecessary" WAL files every couple of minutes? Robert. -- Robert Inder,0131 229 1052 / 07808 492 213 Interactive Information Ltd, 3, Lauriston Gardens, Edinburg

Basic question about structuring SQL

2020-07-07 Thread Robert Inder
I'm an experienced programmer but really new to SQL, and I'm wanting a pointer to "the SQL way" to structure/organise chunks of code. A while back, I wrote a chunk of SQL to Do Something Useful. I put it in a file (do-something-useful.sql). And, to protect against getting into a weird state, I wra