Skip site navigation (1) Skip section navigation (2)

Re: contrib/dbsize

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: Shankar K <shan0075(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: contrib/dbsize
Date: 2003-03-27 14:02:01
Message-ID: 200303271932.02089.mallah@trade-india.com (view raw or flat)
Thread:
Lists: pgsql-admin

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.


In response to

pgsql-admin by date

Next:From: LokiDate: 2003-03-27 15:12:09
Subject: PostgreSQL + IDS load/latency help
Previous:From: Bruce MomjianDate: 2003-03-27 04:58:43
Subject: Re: Monitoring server loads

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group