Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

Since it started happening after reboot, I wonder if it's selinux related. If you previously did "setenforce 0", that wouldn't persist across reboot. On Oct 5, 2012 10:01 PM, "Phoenix Kiula" wrote: > On Sat, Oct 6, 2012 at 12:01 AM, Wolf Schwurack wrote: > > > You need to have a pgbouner d

[GENERAL] 'full_page_writes=off' , VACUUM and crashing streaming slaves...

Master/slave replication, the master and slave both have full_page_writes disabled because the system is running on ZFS. While the master was still being setup and data was being loaded, the system ran out of open file descriptors and Pg crashed a few times until this was realized and corrected

Re: [GENERAL] 'full_page_writes=off' , VACUUM and crashing streaming slaves...

Sean Chittenden writes: > While the master was still being setup and data was being loaded, the > system ran out of open file descriptors and Pg crashed a few times > until this was realized and corrected. Could you provide a bit more detail than that? Usually the behavior we see under out-of-FD

Re: [GENERAL] strange hot_standby behaviour

On Mon, Oct 1, 2012 at 11:43 AM, Andreas Pfotenhauer wrote: > OS is debian squeeze, pg installed is the latest 9.2.1 from > pgapt.debian.net. Logs where checked, no errors/warnings at all. Query plans > have been checked, no changes before/after. The changed behavior only > manifested in the drop

Re: [GENERAL] 'full_page_writes=off' , VACUUM and crashing streaming slaves...

>> While the master was still being setup and data was being loaded, the >> system ran out of open file descriptors and Pg crashed a few times >> until this was realized and corrected. > > Could you provide a bit more detail than that? Usually the behavior we > see under out-of-FDs conditions is

[GENERAL] Help with query timeout

Dear friends, I'm using Java 1.6 with Jdbc 4 driver with PostgreSQL 9.1.5 on Windows 64 and Linux 64. Trying to use setQueryTimeout(int), I get the following stack trace: Internal Exception: org.postgresql.util.PSQLException: Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(i

Re: [GENERAL] Help with query timeout

Edson Richter wrote: > Dear friends, > > I'm using Java 1.6 with Jdbc 4 driver with PostgreSQL 9.1.5 on Windows > 64 and Linux 64. > Trying to use setQueryTimeout(int), I get the following stack trace: > Internal Exception: org.postgresql.util.PSQLException: Method > org.postgresql.jdbc4.Jdbc