Re: Duplicate values found when reindexing unique index

["Mason Hale" <masonhale(at)gmail(dot)com>]

>
>
> I think you misread Mason's post of 20:23 GMT-6 where he says the
> created_at values are the *same*, not different. Mason's previous bug
> report 3724 also had duplicate rows with matching created_at values.
>

Yes, to confirm, the created_at values are the same. The *only* values that
are different are updated_at and that value is set via trigger.

Another data point that may or may not be relevant: I've been working to set
up a warm standby server and have run into some weird behavior there as
well. The symptom is the server encounters an error during the file restore,
then pre-maturely exits recovery mode. I'm using the pg_standby program for
the restore_command in my recovery.conf on the standby server.

The error message from the standby server was:

Last week I had turned my attention away from the database restore, and
didn't notice that our standby server had exited recovery mode on 12/20.
Here's the last few lines from the log file (full log attached).

2007-12-20 04:11:43 CST () LOG:  restored log file
"000000010000042200000057" from archive
2007-12-20 04:13:09 CST () LOG:  restored log file
"000000010000042200000058" from archive
2007-12-20 04:14:40 CST () LOG:  restored log file
"000000010000042200000059" from archive
2007-12-20 04:14:40 CST () LOG:  invalid info bits 0001 in log file 1058,
segment 89, offset 0
2007-12-20 04:14:40 CST () LOG:  redo done at 422/58FFEE38
2007-12-20 04:14:40 CST () LOG:  restored log
file "000000010000042200000058" from archive
2007-12-20 04:14:40 CST () LOG:  archive recovery complete
2007-12-20 04:24:57 CST () LOG:  database system is ready

thanks,
Mason