Easy,
become root,
cd /path/to/uptarred/pogsql_src/contrib
# make
# make install
# cd <yoir_fav_contrib_package_folder>
# psql -U username db_name -f name_of_contrib_package.sql ( generally)
in case of dbsize
# cd dbsize
# psql -U uname db_name -f dbsize.sql
regds
mallah.
On Wednesday 26 Mar 2003 8:15 am, Shankar K wrote:
> Hi everybody,
>
> I'm a newbie to postgres and need some advise on
> contrib/dbsize install.
>
> recently i installed 7.3.2 onto rh linux 7.3 from
> source. everything was fine created couple of test
> databases and later on i found the utilities under
> /contrib dir of the source which i didn't install it
> in first place.
>
> so can i install them now ? and to all databases.
>
> i did read the readme.doc under /contrib/dbsize and
> this is what i got into.
>
> bash-2.03$ make
> sed 's,MODULE_PATHNAME,$libdir/dbsize,g' dbsize.sql.in
>
> >dbsize.sql
>
> gcc -Wall -Wmissing-prototypes -Wmissing-declarations
> -fPIC -I. -I../../src/include -c -o dbsize.o
> dbsize.c
> /usr/ccs/bin/ld -G -Bdynamic -o dbsize.so dbsize.o
> rm dbsize.o
>
> bash-2.03$ make install
> mkdir /usr/local/pgsql/share/contrib
> make: *** [installdirs] Error 2
>
> I appreciate your help.
>
> Regards,
> Shankar
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
> http://platinum.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.