[GENERAL] WAL log level compatibility

2014-08-22 Thread Andy Lau
Hi everyone, Are 'wal_level = archive' vs 'wal_level = hot_standby' ok to mix? For example, let's say I had a PostgreSQL database running and creating WAL logs in the archive level. Then we switch to the hot standby level to support a hot standby, then go back to the archive level, all while

Re: [GENERAL] Best practices for cloning DB servers

2014-08-19 Thread Andy Lau
set in QA I would have thought that shipping WAL file into S3 would have been problematic - I'd be interested in the size of the data set and the experiences you've had with that Regards Bill Sent from my iPhone On Aug 14, 2014, at 12:17, Andy Lau a...@infer.com wrote: Hi everyone

[GENERAL] Best practices for cloning DB servers

2014-08-14 Thread Andy Lau
Hi everyone, I had a question about some best practices. Our situation is that we want to be able to clone a database server. Our single database server is hosted in AWS, we take EBS snapshots every so often, and upload our WAL logs to S3. We want to be able to start a new server from a snapshot,