On Fri, Feb 15, 2008 at 5:18 PM, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> > > How should I install a "contrib" without bringing down my database, or > stopping it, or doing ANYTHING to it? It's in production. I can't > touch it. Will it be installed on the side and then I simply start > using it? > You do not need to restart the database server for that purpose as all you need is the pgstattuple.so file copied to <PG-HOME>/lib folder. Do the following (in case you have installed server from source): - Go to the <PostgreSQL-source>/contrib/pgstattuple folder - run make and make install (this will copy pgstattuple.so file to the lib folder of your PostgreSQL installation) - Now from psql execute the pgstattuple.sql file for that specific database which can be found in <PG-HOME>/share/contrib folder - Once the sql file is executed now you can use the pgstattuple function -- Shoaib Mir Fujitsu Australia Software Technology [EMAIL PROTECTED]