Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD server

2013-05-08 Thread Achilleas Mantzios
Pretty informative Jim, thanx. Do you remember which version, when, by who, were these shortcomings (different user, different port) resolved? At the time it seemed like a very hard thing to implement in the current status of jails. So, to rephrase, did it take a major jail re-write to achieve

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-08 Thread Albe Laurenz
Bhanu Murthy wrote: handsfree wrote: We're looking to use streaming replication to a target via a secondary host using stunnel. I could think of 2 possible solutions: [...] 2. Use streaming replication config features to secure traffic (encrypted data over TCP) Master configuration

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-08 Thread handsfree
Thanks for the response. In terms of your suggestions: 1. We already have stunnel installed on MachineA and MachineB, and it would not be too difficult to install stunnel on MachineC either. What I'm unsure of is how to make MachineB a 'bridge' so the postgres target MachineC appears as an end

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-08 Thread handsfree
Laurenz, thanks for that information; I will bear in mind the problems that you encountered with SSL renegotiation. I'm not sure that this will necessarily be an issue using stunnel, but I will talk with my colleagues who have more experience of stunnel and confirm whether or not it's applicable.

Re: [ADMIN] [SQL] Encrypting PGBouncer to Postgres DB connections

2013-05-08 Thread Albe Laurenz
handsfree wrote: Laurenz, thanks for that information; I will bear in mind the problems that you encountered with SSL renegotiation. I'm not sure that this will necessarily be an issue using stunnel, but I will talk with my colleagues who have more experience of stunnel and confirm whether

Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD server

2013-05-08 Thread Jim Mercer
On Wed, May 08, 2013 at 10:03:30AM +0300, Achilleas Mantzios wrote: Pretty informative Jim, thanx. Do you remember which version, when, by who, were these shortcomings (different user, different port) resolved? At the time it seemed like a very hard thing to implement in the current status

Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD server

2013-05-08 Thread Achilleas Mantzios
On Ôåô 08 ÌáÀ 2013 08:28:31 Jim Mercer wrote: On Wed, May 08, 2013 at 10:03:30AM +0300, Achilleas Mantzios wrote: Pretty informative Jim, thanx. Do you remember which version, when, by who, were these shortcomings (different user, different port) resolved? At the time it seemed like a

Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD server

2013-05-08 Thread Jim Mercer
On Wed, May 08, 2013 at 05:29:53PM +0300, Achilleas Mantzios wrote: 1st the above links do not reveal anything new. 2nd, judging by the wiki : https://wiki.freebsd.org/Jails , jailified SysV IPC (or SysV IPC-ified jails) (the specific territory where pgsql comes in contact with jails) are

Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD server

2013-05-08 Thread Charles Sprickman
On May 8, 2013, at 11:32 AM, Jim Mercer wrote: On Wed, May 08, 2013 at 05:29:53PM +0300, Achilleas Mantzios wrote: 1st the above links do not reveal anything new. 2nd, judging by the wiki : https://wiki.freebsd.org/Jails , jailified SysV IPC (or SysV IPC-ified jails) (the specific territory

[ADMIN] Delete xlog files

2013-05-08 Thread Rodrigo Barboza
Hi, guys. I started accdentally a recovery with archive mode on and stand by server off. It created a lot of xlog files and filled my whole disk. If I decided to delete xlog files by hand, how do I know which one to delete?