Re: URGENT pg_xlog full impossible to restart ...
От | Scott Marlowe |
---|---|
Тема | Re: URGENT pg_xlog full impossible to restart ... |
Дата | |
Msg-id | 1090112323.3429.0.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: URGENT pg_xlog full impossible to restart ... (Hervé Piedvache <footcow@noos.fr>) |
Ответы |
Re: URGENT pg_xlog full impossible to restart ...
|
Список | pgsql-general |
Did you have a long running transaction? That's usually the cause of this kind of thing. On Sat, 2004-07-17 at 17:37, Hervé Piedvache wrote: > OK it's running again many thanks ! :o) > > But Tom ... could you clearly explain me what is the parameter to set in the > postgresql.conf to never have my pg_xlog partition's going full ?? > > I have 1.8 Gb dedicated to pg_xlog and I have set those options : > checkpoint_segments = 3 # in logfile segments, min 1, 16MB each > checkpoint_timeout = 300 # range 30-3600, in seconds > #checkpoint_warning = 30 # 0 is off, in seconds > #commit_delay = 0 # range 0-100000, in microseconds > #commit_siblings = 5 # range 1-1000 > > And I was only creating an index ... > > I'm a little disapointed !? > > regards, > > Le dimanche 18 Juillet 2004 00:19, Tom Lane a écrit : > > =?iso-8859-1?q?Hervé_Piedvache?= <footcow@noos.fr> writes: > > > Tom, > > > > > > Le samedi 17 Juillet 2004 23:06, Tom Lane a écrit : > > >> =?iso-8859-15?q?Hervé_Piedvache?= <footcow@noos.fr> writes: > > >>> How to solve this ??? My pg_xlog partition is full ... :o( > > >> > > >> ... so free up some space ... > > > > > > But my pg_xlog partition is dedicated to the WAL files ... so I can't > > > delete them ?? > > > > Sure you can; all you need are the one(s) that the postmaster will try > > to read at restart. Since your log excerpt shows a clean shutdown, the > > only one you actually have to have is the one containing the shutdown > > checkpoint record, which is probably the one with the latest file mod > > time (but check against the checkpoint position shown in the log). > > > > > So pg_resetxlog -f /usr/local/pgsql/data ?? > > > > That would work too. > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly
В списке pgsql-general по дате отправления: