Re: [ADMIN] How to compile contribs ...

2003-03-13 Thread A.Bhuvaneswaran
Could anybody help on how to compile the contribs? I've to copy them anywhere? How I do it? The README in corresponding contrib module must be of much help. If not, get back with the name of contrib module which you have tried. regards, bhuvaneswaran ---(end of

Re: [ADMIN] VACUUM locking for 21 hours and counting

2003-03-13 Thread Tom Lane
Halford Dace [EMAIL PROTECTED] writes: PostgreSQL 7.0.3 I believe I see your problem ;-) Try updating to 7.2 or later. There are many pressing reasons besides performance why you should not be running anything older than 7.2.4. I was just helping someone last night whose 7.1 database had gone

Re: [ADMIN] removal from list

2003-03-13 Thread Marc G. Fournier
On Thu, 13 Mar 2003, Chad R. Larson wrote: At 12:15 PM 3/13/2003 -0400, Marc G. Fournier wrote: the database (Berkeley DB is used) backend for the majordomo2 lists isn't the most stable, so we've been having periodic corruption problems where we have to rebuild it Does anyone else see the

Re: [ADMIN] How to compile contribs ...

2003-03-13 Thread Daniel Rubio
The README in corresponding contrib module must be of much help. If not, get back with the name of contrib module which you have tried. I know that README usually helps, but this is not the case for me : ( I need to compile dbsize ... regards, bhuvaneswaran ---(end of

Re: [ADMIN] How to compile contribs ...

2003-03-13 Thread Tom Lane
Daniel Rubio [EMAIL PROTECTED] writes: c. Exact failure message make: Fatal error in reader: ../../src/Makefile.global, line 23: Illegal dependencies for target `.SILENT' I'm betting that you are not using gmake (GNU make). The PG makefiles mostly don't work on vendor-supplied makes.

Re: [ADMIN] removal from list

2003-03-13 Thread Marc G. Fournier
the database (Berkeley DB is used) backend for the majordomo2 lists isn't the most stable, so we've been having periodic corruption problems where we have to rebuild it ... the problem is that the rebuild process doesn't seem to be aware of unsubscribe/set commands that were issued *after* the

[ADMIN] Regular expressions in PostgreSQL

2003-03-13 Thread Partho Bhowmick
Is the regular expression used by Postgres POSIX compliant? Regards, Partho ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]