Re: [BUGS] log_truncate_on_rotation=on is not truncating

2012-07-15 Thread Tom Lane
I wrote: > The relevant bit of the code is > /* > * The requirements here are to choose the next time > now that is a > * "multiple" of the log rotation interval. "Multiple" can be interpreted > * fairly loosely. In this version we align to log_timezone rather than > * GM

Re: [BUGS] log_truncate_on_rotation=on is not truncating

2012-07-15 Thread Tom Lane
[ just got around to looking at this bug report, sorry for the delay ] Viswanatham Kiran Kumar writes: > Hi Chan, > I think this is configuration issue. > This issue is happening because log files will always append when > server is restarted. What I can see from your configuration,

Re: [BUGS] BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

2012-07-15 Thread Tom Lane
Mike Wilson writes: > I've had some time to examine this closer over the weekend. It > appears that pg_upgrade for 9.2b2 segfaults which more than likely has > something to do with the resulting converted database appearing to > have no rows. Yeah, more than likely :-(. Could we see a stack tra

[BUGS] Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table

2012-07-15 Thread Noah Misch
On Mon, Jul 02, 2012 at 04:16:31PM +0530, Amit Kapila wrote: > > From: pgsql-bugs-ow...@postgresql.org > > [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of > > miroslav.s...@fordfrog.com > > Sent: Saturday, June 30, 2012 4:28 PM > > test=# create table test_constraints (id int, val1 varchar

Re: [BUGS] BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

2012-07-15 Thread Mike Wilson
I've had some time to examine this closer over the weekend. It appears that pg_upgrade for 9.2b2 segfaults which more than likely has something to do with the resulting converted database appearing to have no rows. Earlier in this thread I reported that I was able to get the upgrade to work an