Re: Is my database now too big? - Mailing list pgsql-admin

From Darren Reed
Subject Re: Is my database now too big?
Date
Msg-id 4715FD90.8020607@fastmail.net
Whole thread Raw
In response to Re: Is my database now too big?  (Darren Reed <darrenr+postgres@fastmail.net>)
Responses Re: Is my database now too big?
List pgsql-admin
Darren Reed wrote:
> For better or worse, it seems to be behaving itself again for a while...
>
> There was, however, one change to my procedure and that was to
> drop the triggers/functions when restoring the data (using copy into).

Perhaps I spoke too soon...

# /usr/pkg/bin/pg_dumpall -O -U postgres -a > /data/dumpall
pg_dump: [archiver (db)] connection to database "template1" failed:
FATAL:  out of memory
DETAIL:  Failed on request of size 20.
pg_dumpall: pg_dump failed on database "template1", exiting

...for better or worse, I'm interfacing to postgresql using perl's DBI
interface.
Are there likely to be any issues from that?  (Although I can't see how
a client
should be able to cause the server to become corrupt unless there's a bug in
the server.)

Darren


pgsql-admin by date:

Previous
From: "Moiz Kothari"
Date:
Subject: Re: Is there a way to kill a connection from the pg_stat_activitly list?
Next
From: Kevin Kempter
Date:
Subject: Re: running a SQL command at startup time