On Mon, Sep 22, 2003 at 02:21:43PM -0400, Alvaro Herrera wrote:
On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote:
On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I hope I guessed the right syntax...
% pg_filedump -R
There was a thread on missing pg_clog files caused due to dodgy practices in
glibc *last year*. I am seeing something similar *now* with a server
PostgreSQL 7.4beta1 on i386-unknown-netbsdelf1.6X, compiled by GCC 2.95.3
accessed by a similar client and a client
PostgreSQL 7.4devel on
Patrick Welche [EMAIL PROTECTED] writes:
select * from olddata02_03vac offset 2573719 limit 1;
ERROR: could not access status of transaction 1664158221
DETAIL: open of file /usr/local/pgsql/data/pg_clog/0633 failed: No such file or
directory
# ls -l pg_clog
total 32
-rw--- 1
On Mon, Sep 22, 2003 at 10:50:22AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
select * from olddata02_03vac offset 2573719 limit 1;
ERROR: could not access status of transaction 1664158221
DETAIL: open of file /usr/local/pgsql/data/pg_clog/0633 failed: No such file
Patrick Welche [EMAIL PROTECTED] writes:
I hope I guessed the right syntax...
% pg_filedump -R 71716 data/base/17148/283342
Yes, but this doesn't give all the available info. Add -i and -f
options. A plain -d dump might be interesting too.
regards, tom lane
On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I hope I guessed the right syntax...
% pg_filedump -R 71716 data/base/17148/283342
Yes, but this doesn't give all the available info. Add -i and -f
options. A plain -d dump might be
Patrick Welche [EMAIL PROTECTED] writes:
Indeed, the plain -d dump says that I have a chunk of /var/mail/prlw1
in 1000-13ff. No wonder postgres complained!
Yipes. We have seen this sort of thing once or twice in the past.
I don't know whether you are looking at a disk drive fault (dropping
the
On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote:
On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I hope I guessed the right syntax...
% pg_filedump -R 71716 data/base/17148/283342
Yes, but this doesn't give all the