On Tuesday 17 April 2007 07:39, Milen A. Radev wrote:
> Chuck Amadi написа:
> > I have been given a task to try a proof of concept of migrating are
> > active databases from PostgreSQL 8.0.1 to 8.2.3
> >
> > I will install and configPostgreSQL on my local w/s and replicate the
> > database users et
On Tue, 17 Apr 2007, Joshua D. Drake wrote:
adey wrote:
I found the following script useful; for calculating database size:-
select pg_database_size?
http://www.postgresql.org/docs/8.2/static/functions-admin.html
That works great for 8.1+ but I believe the OP wants to do it with 8.0.1.
If
adey wrote:
I found the following script useful; for calculating database size:-
select pg_database_size?
http://www.postgresql.org/docs/8.2/static/functions-admin.html
-- Query returns size of a database calculated from the no. 8k pages
allocated to tables
SELECT
sum( relpages*8/1024 )
I found the following script useful; for calculating database size:-
-- Query returns size of a database calculated from the no. 8k pages
allocated to tables
SELECT
sum( relpages*8/1024 ) as MB
FROM
pg_class
WHERE
-- relname != ''
-- relname = 'tablename'
relnamespace = '2200'
On 4/17/07, Chuck
Chuck Amadi написа:
> I have been given a task to try a proof of concept of migrating are
> active databases from PostgreSQL 8.0.1 to 8.2.3
>
> I will install and configPostgreSQL on my local w/s and replicate the
> database users etc etc.
>
> I have had a look inside /var/lib/pgsql/data/base and
