Re: [GENERAL] Ubuntu Packages / Config Files

2014-05-08 Thread Stephan Fabel
Stuart, thanks for your reply. On 05/08/2014 12:47 AM, Stuart Bishop wrote: > recovery.conf goes into $DATADIR, which is > /var/lib/postgresql/9.1/main in your case. I rationalize this by > considering it database state, rather than configuration, since > commands like 'pg_ctl promote' or using a

Re: [GENERAL] Ubuntu Packages / Config Files

2014-05-08 Thread Stuart Bishop
On 2 May 2014 01:40, Stephan Fabel wrote: > All, > > apologies if this has been addressed somewhere already. I don't have a > lot of experience in PostgreSQL; this is my first setup where I'm trying > to scale and provide some of the more advanced features (like WAL > shipping, master-slave sync,

Re: [GENERAL] Ubuntu Packages / Config Files

2014-05-01 Thread Steve Crawford
On 05/01/2014 11:40 AM, Stephan Fabel wrote: I'm using Ubuntu 12.04 for these deployments at the moment. The Ubuntu packages don't put the configuration files with the cluster data (by default under /var/lib/postgresql/9.1/main under 12.04), but in /etc/postgresql/9.1/main) and they start postgre

Re: [GENERAL] Ubuntu Packages / Config Files

2014-05-01 Thread Stephan Fabel
On 05/01/2014 09:35 AM, Raymond O'Donnell wrote: > You haven't made it clear that you are actually replicating to a > different PostgreSQL server (whether on the same machine or on another > one) - is that the case? Ray. Indeed that is the case. Two servers, one master, one slave. Both identical

Re: [GENERAL] Ubuntu Packages / Config Files

2014-05-01 Thread Raymond O'Donnell
On 01/05/2014 19:40, Stephan Fabel wrote: > All, > > apologies if this has been addressed somewhere already. I don't have a > lot of experience in PostgreSQL; this is my first setup where I'm trying > to scale and provide some of the more advanced features (like WAL > shipping, master-slave sync,

[GENERAL] Ubuntu Packages / Config Files

2014-05-01 Thread Stephan Fabel
All, apologies if this has been addressed somewhere already. I don't have a lot of experience in PostgreSQL; this is my first setup where I'm trying to scale and provide some of the more advanced features (like WAL shipping, master-slave sync, integrating pgbouncer, etc.), and I'm looking for help