Re: Is my database now too big?
От | Darren Reed |
---|---|
Тема | Re: Is my database now too big? |
Дата | |
Msg-id | 4715FD90.8020607@fastmail.net обсуждение исходный текст |
Ответ на | Re: Is my database now too big? (Darren Reed <darrenr+postgres@fastmail.net>) |
Ответы |
Re: Is my database now too big?
|
Список | 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 по дате отправления: