Re: [ADMIN] nodeRead: did not find '}' at end of plan node

2004-03-16 Thread Tom Lane
Martin Sarsale <[EMAIL PROTECTED]> writes: > Im running debian stable/testing, postgresql 7.3.2 with a "connect by > prior" patch. Oh. You know, there's a reason why that patch isn't in the tree. Back it out... If you really want to use that patch, dump your database without the patch, install

Re: [ADMIN] nodeRead: did not find '}' at end of plan node

2004-03-16 Thread Martin Sarsale
> Can you do "select * from pg_user" in any of your databases, or does it > fail the same way in all? If it fails in each database then I'd suspect > some kind of version mismatch; if not then it's just corrupt in that > particular database. I've only 2 databases t(template1 and another one) and

Re: [ADMIN] Space Problems

2004-03-16 Thread Tom Lane
"Eduardo Naschenweng" <[EMAIL PROTECTED]> writes: > Hi, I has a problem with a production database Postgres 7.1.2. Ouch, that's pretty old (and not even the latest of the 7.1 series). > The point is : I think some system table was corrupted. Can you find any pg_class rows with OIDs matching thos

[ADMIN] Space Problems

2004-03-16 Thread Eduardo Naschenweng
Hi, I has a problem with a production database Postgres 7.1.2. Happens when finished free space disk. Some important tables were empty with no reason. I tried to find respectives files for tables with psql command :   select relfilenode from pg_classwher

Re: [ADMIN] Hardware for a database server

2004-03-16 Thread Erwin Brandstetter
Yo Scott, Greg & William! I tried to send the following message last week, but my posting never got here. Guess my provider has fucked up. So here goes again, sorry for late reply. For knowledgeable feedback I have asked, and that's what I have got. Thanx a lot. My thanks also Jim Wilson who ad