On Jun 18, 10:44 pm, [EMAIL PROTECTED] (Alvaro Herrera)
wrote:
>
> Please check "MultiXact" id consumption. Do you mean that your server
> has crashed?
>
How do I check MilitXact id consumption ? Is it "Latest checkpoint's
NextXID:" in the output of pg_controldata ?
transaction id consumption is
Aha, google thinks it's wise to make the last postings (probably if
more than n ?) show only the poster name and make the name clickable.
Not very userfriendly :-( but now i know it ;-)
Sorry if that wasn't clear. I'm getting the same log entry as the
original
poster, i.e.: LOG: could not trunca
On Jun 18, 11:08 am, [EMAIL PROTECTED] wrote:
> On Jun 13, 2:35 pm, [EMAIL PROTECTED] wrote:
>
> Can someone tell me if I should be concerned about this log entry ? My
> database is quite large (~ 2G in PGDATA)
>
> regards
> Gerhard
BTW, I do not use autovacuum, and run vacuumdb on a weekly basis.
On Jun 13, 2:35 pm, [EMAIL PROTECTED] wrote:
> On Jun 8, 3:23 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
>
>
>
> > Gunther Mayer wrote:
> > > Hi there,
>
> > > I just found the following message in my logs:
>
> > > Jun 8 10:38:38 caligula postgres[56868]: [1-1] : LOG: could not
> > > truncate
On Jun 14, 2:18 pm, [EMAIL PROTECTED] (Michael Fuhr) wrote:
> On Thu, Jun 14, 2007 at 04:40:12AM -0700, [EMAIL PROTECTED] wrote:
> > I'd like to convert timestamps without timezone to unix epoch values
> > with at least microseconds resolution.
> > but when i do e.g.:
> > select extract (epoch from
I'd like to convert timestamps without timezone to unix epoch values
with at least microseconds resolution.
but when i do e.g.:
select extract (epoch from timestamp without time zone 'Thu 14 Jun
05:58:09.929994 2007');
i get:
1181793489.92999
so i loose the last digit. I'd expect 1181793489.92999
On Jun 8, 3:23 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> Gunther Mayer wrote:
> > Hi there,
>
> > I just found the following message in my logs:
>
> > Jun 8 10:38:38 caligula postgres[56868]: [1-1] : LOG: could not
> > truncate directory "pg_subtrans": apparent wraparound
>
> > Should I be