On Wed, Jun 07, 2006 at 12:43:59PM -0400, mcelroy, tim wrote:
> The contrib/dbsize module will accomplish what you want. I use release
> 8.0.1 and it works for me.
>
> It provides the size of the DB, you could cron a job to take readings at
> various times and calculate the growth that way.
If
On Wed, Jun 07, 2006 at 09:25:18AM +0100, Andy Shellam wrote:
> You would need to write your own installation script that would:
> a) create the temporary data directory
> b) install Postgres with all default options
> c) modify the pg_hba.conf file to allow localhost trust access (ie. No
> passwor
You might check out Knoppix. If your app will run on Linux you could create a full bootable Knoppix CD with everything installed - then they can play around all they want and just reboot to reset everything. I am not sure if there is a Knoppix distro that can run within Windows.
I do video demos.
On Tue, 6 Jun 2006, Tom Lane wrote:
Some cursory trawling in the REL7_3 sources says that this means that
"SELECT DISTINCT loid FROM pg_largeobject" found a large object OID
that then could not be found by an indexscan of pg_largeobject. So
I'd try a REINDEX of pg_largeobject to see if that fix
Title: RE: [ADMIN] growth of a postgresql database
The contrib/dbsize module will accomplish what you want. I use release 8.0.1 and it works for me.
It provides the size of the DB, you could cron a job to take readings at various times and calculate the growth that way.
Tim
-Orig
On Wed, 2006-06-07 at 03:01, Andy Shellam wrote:
> > Hello!
> >
> > Is it possible to have a CD with database and postgres binaries
> > (win32), which can be directly run (without any installation) ? Or if it
> > is impossible to be run from read-only media, to have it as
> > self-extracting
On Tue, 6 Jun 2006 09:24:13 -0400
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Callis wrote:
Jun 6 06:12:45 Billing postgres[2296]: [1-4] You can
either reduce the request size or reconfigure the kernel
with larger SHMMAX
So did you try to increase the kernel's SHMMAX?
Yes, i have but i stil
Hello,
How can we see/calculate the growth of a postgresql database? Is there any tool
in postgresql to see the
growth (or size) of one database? If yes, beginning with which release?
Thank you
---(end of broadcast)---
TIP 3: Have you checked our
You would need to write your own installation script that would:
a) create the temporary data directory
b) install Postgres with all default options
c) modify the pg_hba.conf file to allow localhost trust access (ie. No
password) - and restart Postgres
d) load the dump of your database into Postgre
Dnia 07-06-2006, śro o godzinie 09:01 +0100, Andy Shellam napisał(a):
> You won't be able to run it all off CD no, as Postgres requires
> log/transaction files etc to be written to. It also requires a service
> user/data directory so it would have to be installed.
OK. Let's assume, that I will ha
You won't be able to run it all off CD no, as Postgres requires
log/transaction files etc to be written to. It also requires a service
user/data directory so it would have to be installed.
If you don't require the functionality etc of Postgres (and haven't
developed your solution yet) you might b
Hello!
Is it possible to have a CD with database and postgres binaries
(win32), which can be directly run (without any installation) ? Or if it
is impossible to be run from read-only media, to have it as
self-extracting archive, which can be run from any user account ?
The goal is to have
12 matches
Mail list logo
