Re: [ADMIN] build from Source: 9.0.1 / 9.1-alpha1 cannot build modules

2010-10-10 Thread Lou Picciano
Yes, that's the line. Have even edited to be sure it's got a proper CR, etc. No, haven't even touched on vpath yet... Happy to try - what to test? What to check for in Makefile.global.in? Looks pretty good in cursory overview. Time to move to SunStudio? Better binary performance? Regard

Re: [ADMIN] build from Source: 9.0.1 / 9.1-alpha1 cannot build modules

2010-10-10 Thread Tom Lane
Lou Picciano writes: > 'Wacko', indeed, no? > It's make 3.81, as packaged with OpenIndiana. gcc is 3.4.3. Hm, 3.81 is a pretty popular version, so that doesn't seem to be the answer. Did you look at exactly what was on the complained-of line? It looks to me like it should be top_srcdi

Re: [ADMIN] build from Source: 9.0.1 / 9.1-alpha1 cannot build modules

2010-10-10 Thread Lou Picciano
'Wacko', indeed, no? It's make 3.81, as packaged with OpenIndiana. gcc is 3.4.3. Though I've been traditionally very reliant on Steve Christensen's 'Good Works' over at SunFreeware, the gang at OI are working hard to be very current. Do you think it's a version thing? Am about to re-do t

Re: [ADMIN] Re: Vaccuuming every db in cluster fails to eliminate "execute a full-database VACUUM in..."

2010-10-10 Thread Robert Burgholzer
Tom, Thanks for getting in touch. Unfortunately, I thought to myself "why not drop the db in single mode under database postgres", which I did, and which worked, and thus, I can no longer produce the error, nor can I query the "phantom" table as you suggested. I can say that when I tried to vacuu

Re: [ADMIN] Re: Vaccuuming every db in cluster fails to eliminate "execute a full-database VACUUM in..."

2010-10-10 Thread Tom Lane
Robert Burgholzer writes: > So, as I mentioned, I have tried to get this straightened out by > vacuuming all in --single mode, but to no avail. I executed the > following command, to see which tables were in trouble: > SELECT relname, age(relfrozenxid) FROM pg_class WHERE relkind = 'r'; > And f

Re: [ADMIN] build from Source: 9.0.1 / 9.1-alpha1 cannot build modules

2010-10-10 Thread Tom Lane
Lou Picciano writes: > Build from scratch of 9.0.1 (and 9.1-alpha1) is not building modules for some > reason... All of core builds/installs fine. OpenIndiana (Solaris) x86. > # cd ../contrib > # make > make: Fatal error in reader: ../src/Makefile.global, line 39: Unexpected end > of line se

[ADMIN] Re: Vaccuuming every db in cluster fails to eliminate "execute a full-database VACUUM in..."

2010-10-10 Thread Robert Burgholzer
So, as I mentioned, I have tried to get this straightened out by vacuuming all in --single mode, but to no avail. I executed the following command, to see which tables were in trouble: SELECT relname, age(relfrozenxid) FROM pg_class WHERE relkind = 'r'; And found a table listed, that DOES NOT ex

[ADMIN] Vaccuuming every db in cluster fails to eliminate "execute a full-database VACUUM in..."

2010-10-10 Thread Robert Burgholzer
So, I have neglected to do the vacuum on every db for a long time, and this is a very high volume cluster. The db stopped executing requests this morning, and reported: ERROR: database is not accepting commands to avoid wraparound data loss in database "vwuds" So, I did some googling and found

[ADMIN] build from Source: 9.0.1 / 9.1-alpha1 cannot build modules

2010-10-10 Thread Lou Picciano
Hello gang! Build from scratch of 9.0.1 (and 9.1-alpha1) is not building modules for some reason... All of core builds/installs fine. OpenIndiana (Solaris) x86. Neither # make world nor cd /contrib, make, work. # cd ../contrib # make make: Fatal error in reader: ../src/Makefile.global,