Re: 8.4.4 locked after power failure - Mailing list pgsql-general

From Merlin Moncure
Subject Re: 8.4.4 locked after power failure
Date
Msg-id CAHyXU0wgJxg=w6LxcLditguWF0phM__m0y8fvuePpfny+8yb9w@mail.gmail.com
Whole thread Raw
In response to Re: 8.4.4 locked after power failure  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: 8.4.4 locked after power failure
List pgsql-general
2011/9/13 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
> I'm guessing I won't get much more from devs , without providing more
> info here which unfortunately has been lost.

yup -- you destroyed all the evidence.  if it happens again, try
posting some more info, particularly what's going on with locks,
pg_stat_activity, maybe an strace of any stuck processes, etc.  also
irc can be a good place to get some quick help if its time sensitive.

merlin

pgsql-general by date:

Previous
From: Ferruccio Zamuner
Date:
Subject: PostgreSQL 9.1, replica and unlogged tables
Next
From: Hannes Erven
Date:
Subject: Re: Re: Need help with what I think is likely a simple query - for each distinct val, return only one record with the most recent date.