Re: [SQL] Another postgres 'file not found' error

2002-06-13 Thread Oliver Elphick
On Thu, 2002-06-13 at 19:01, Josh Berkus wrote: > > Debian Woody with 2.4.18 Linux kernel. Postgres install from apt-get > > (7.2.1). > > Hmmm. I might suggest polling both the Debian mailing lists and the > pgsql-hackers mailing list. I remember vaguely hearing about some bug with > Postgre

Re: [SQL] Another postgres 'file not found' error

2002-06-13 Thread Tom Lane
"Ian Cass" <[EMAIL PROTECTED]> writes: > inbound=# update store set state = 0, timestamp = 'now' where timestamp < > (CURRENT_TIMESTAMP - interval '30 seconds') and accountid = '6'; > ERROR: cannot open segment 1 of relation store_ix1 (target block > 1576985508): No such file or directory and la

Re: [SQL] Another postgres 'file not found' error

2002-06-13 Thread Josh Berkus
Ian, > Debian Woody with 2.4.18 Linux kernel. Postgres install from apt-get > (7.2.1). Hmmm. I might suggest polling both the Debian mailing lists and the pgsql-hackers mailing list. I remember vaguely hearing about some bug with Postgres on Debian, but I can't remember where I heard it.

Re: [SQL] Another postgres 'file not found' error

2002-06-13 Thread Ian Cass
> Not if you don't know how to run PostgreSQL or your machines, no. > Migrating to a new platform without sufficient testing or expertise > is always unwise (sorry, but you deserved that for the dig at > Postgres). Heh. Well it's most certainly the case I'm still learning about Postgres (aren't

Re: [SQL] Another postgres 'file not found' error

2002-06-13 Thread Josh Berkus
Ian, > This is the second time within a week I've been hit by a peculiar > 'file not > found' error. I've been replacing a few existing Oracle servers with > Postgres. I'm wondering if that was a wise decision :/ Not if you don't know how to run PostgreSQL or your machines, no. Migrating to a