Re: [GENERAL] pg_class and relfilenode

2004-02-15 Thread William ZHANG
> e.g. > pg_shadow_usename_index > pg_stat_activity > pg_stat_database > They are system views and correspond to no file. See PostgreSQL's documents. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [GENERAL] pg_class and relfilenode

2004-02-12 Thread Tom Lane
"muteki muteki" <[EMAIL PROTECTED]> writes: > And you have pointed out my concern. Even though we have WAL > enable, we have intentionally disabled both fsync and fdatasync > inside the kernel because of other reasons. [blinks...] Surely you're joking? If you insist on running a configuration a

Re: [GENERAL] pg_class and relfilenode

2004-02-11 Thread Tom Lane
"muteki muteki" <[EMAIL PROTECTED]> writes: > Since we have our systems being deployed to numerous > remote systems (psql 7.2.3), upgrading the entire database > (with data migration) will be the least preferable > solution. At the very least you should be running 7.2.4. We do not make dot-releas

Re: [GENERAL] pg_class and relfilenode

2004-02-11 Thread Andrew Sullivan
On Tue, Feb 10, 2004 at 08:29:50PM -0800, muteki muteki wrote: > Hi, > > I am currently having the corrupted tables issues > described in the following link (possibly caused by > power failure, which happens pretty often) > http://archives.postgresql.org/pgsql-admin/2003-04/msg00012.php. > Since w