CODEWITHSUNDEEP
postgresqldistributedlogging
Franz Kafka
Franz Kafka

Reputation: 10841

PostgreSQL WAL into mountain

it's more or less a simple yes or no question...

Can I configure PostgrSQL to WAL into a swiss cave somewhere in the alps and WAL localy at the same time?

If yes, can you set some soft time goal how long commits can be batched together before they are flushed into the mountain? Having tonnes of single tcp ping pong stuff might not be so efficent?

Thanks

Upvotes: 2

Views: 184

Answers (1)

Sean
Sean

Reputation: 10236

Answer: yes.

Read about the different replication solutions available for PostgreSQL before deciding on a particular backup method.

It sounds like you're looking for PostgreSQL's Continuous Archiving/PITR backup method.

And have you read the PostgreSQL WAL Log Shipping documentation?

Upvotes: 4

Related Questions