Re: dbsize - Mailing list pgsql-admin

From Tom Lane
Subject Re: dbsize
Date
Msg-id 25655.1041013585@sss.pgh.pa.us
Whole thread Raw
In response to dbsize  (Andreas Schmitz <a.schmitz@cityweb.de>)
Responses Re: dbsize
List pgsql-admin
Andreas Schmitz <a.schmitz@cityweb.de> writes:
> I don't know if dbsize a part of the admin business here. I couln't find any
> contact infos in the README or the source. I have a 7.3 on solaris 8. When I
> try to execute "SELECT database_size('newsdb');" I get the following error
> message:

> ERROR:  MemoryContextAlloc: invalid request size 1684144132

Hm.  I cannot see anything wrong with the source code for database_size.
I notice though that it depends on vsnprintf, which is known to be buggy
in some releases of Solaris.  Did you use the patch suggested in the
last entry of doc/FAQ_Solaris?

> This started to happen when I increased memory sizes in the postgresql.conf.

From what, to what?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Campano, Troy"
Date:
Subject: Re: dbsize
Next
From: Ray Ontko
Date:
Subject: now() and ::date