Re: dbsize

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: a(dot)schmitz(at)cityweb(dot)de
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: dbsize
Date: 2002-12-27 18:26:25
Message-ID: 25655.1041013585@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)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

In response to

  • dbsize at 2002-12-27 14:37:19 from Andreas Schmitz

Responses

  • Re: dbsize at 2002-12-30 09:42:52 from Andreas Schmitz

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Ontko 2002-12-27 22:06:07 now() and ::date
Previous Message Campano, Troy 2002-12-27 14:49:49 Re: dbsize