On 07/20/2018 04:56 PM, Stephen Frost wrote:

+1.  I'd personally like to see improvements to the tutorials, and
patches could certainly be submitted or specific ideas discussed over on
-docs.

A few ideas around that would be:

- Setting up async replication
- Setting up sync replication, with quorum-based sync
- Cascading replication
- Parallel pg_dump-based backup/restore (with pg_dumpall for globals)
- Using various important extensions (pg_stat_statements,
   pg_buffercache, pageinspect, pg_freespacemap, pg_visibility)
- Using pg_basebackup to build replicas
- Using pg_receivewal to have a WAL archive

I think this is a pretty good list. I would add:

Practical Role management

JD

--

Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
***  A fault and talent of mine is to tell it exactly how it is.  ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
*****     Unless otherwise stated, opinions are my own.   *****


Reply via email to