Re: [BUGS] BUG #7902: lazy cleanup of extraneous WAL files can cause out of disk issues

2013-02-26 Thread Jeff Janes
On Friday, February 22, 2013, wrote: The following bug has been logged on the website: Bug reference: 7902 Logged by: Jeff Frost Email address: j...@pgexperts.com javascript:; PostgreSQL version: 9.2.3 Operating system: Ubuntu 12.04 Description: While doing

Re: [BUGS] BUG #7902: lazy cleanup of extraneous WAL files can cause out of disk issues

2013-02-26 Thread Jeff Janes
On Sunday, February 24, 2013, Jeff Frost wrote: This is how the log_checkpoint output looks during the run: 2013-02-24 21:06:31.156 UTC,,,1624,,51282598.658,114,,2013-02-23 02:12:40 UTC,,0,LOG,0,checkpoint starting: immediate force wait, 2013-02-24 21:06:31.216

[BUGS] BUG #7906: pg_dump exits successfully after an error

2013-02-26 Thread adam . tomjack
The following bug has been logged on the website: Bug reference: 7906 Logged by: Adam Tomjack Email address: adam.tomj...@zuerchertech.com PostgreSQL version: 9.2.1 Operating system: Linux 2.6.32-39-server #86-Ubuntu SMP x86_64 Description: I have a database that

Re: [BUGS] BUG #7853: Incorrect statistics in table with many dead rows.

2013-02-26 Thread jimbob
So, I have some observations. Is this what you are seeing as well? So when we CLUSTER a table heavily-updated table: CLUSTER does appear to reset *n_dead_tup*, *n_tup_ins*, *n_tup_del*, *n_tup_hot_upd*, but NOT *n_live_tup* pg_stat_reset() truly clears out all the statistics counters. I

[BUGS] BUG #7904: can´t load DBI-Link

2013-02-26 Thread pedro . ferro
The following bug has been logged on the website: Bug reference: 7904 Logged by: Pedro Email address: pedro.fe...@gmail.com PostgreSQL version: 9.2.3 Operating system: Windows 64bits Description: Hi, I can not install DBI-Link in Postgresql. I have a machine with

[BUGS] BUG #7907: BEFORE DELETE TRIGGER (not instead of, my trigger BEFORE)not row delete...

2013-02-26 Thread ibrahimkocaoglutr
The following bug has been logged on the website: Bug reference: 7907 Logged by: İBRAHIM KOCAOGLU Email address: ibrahimkocaogl...@gmail.com PostgreSQL version: 9.1.0 Operating system: debian-6.stable Description: -- Function: f_is_isletme_sayim_hazirlik_delete() --

[BUGS] Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.

2013-02-26 Thread fburgess
On tuesday, February 26, 2013, Freddie Burgess wrote: We have a Postgres database that was recently upgraded from 8.4.3 to 9.1.6. We have noticed unusual growth in the data files and generated a script to perform the following actions.1. Query pg_class for all records2. Generate a file listing of

Re: [BUGS] BUG #7903: EAN13s are shown ISBN values

2013-02-26 Thread Peter Eisentraut
On 2/23/13 2:10 PM, Peter Geoghegan wrote: But then, contrib/isn also sanitises both ISBN ranges and EAN country codes using its own internal database, which ought to be kept in lockstep with an external database whose maintenance is highly decentralised - regional authorities make certain

Re: [BUGS] BUG #7902: lazy cleanup of extraneous WAL files can cause out of disk issues

2013-02-26 Thread Jeff Frost
On 02/26/13 09:08, Jeff Janes wrote: They're all number of xlog based and the first one doesn't remove any, that's not surprising, What was the state of the pg_xlog directory before you started the test? If it were not full up to check_point segments * 2, (which is likely was not,

Re: [BUGS] BUG #7903: EAN13s are shown ISBN values

2013-02-26 Thread Peter Geoghegan
On 26 February 2013 21:45, Peter Eisentraut pete...@gmx.net wrote: Have each user create their custom domain? That's likely to be the most effective solution, yes. I'd take the fact that people haven't been complaining about contrib/isn more as suggestive of people figuring this out for