Re: transaction log location
От
Peter Childs
Тема
Re: transaction log location
Дата
Msg-id
Pine.LNX.4.44.0309250818260.21236-100000@RedDragon.Childs
Ответ на
transaction log location (Marcin Gil)
Список
Дерево обсуждения
transaction log location Marcin Gil <marcin.gil@audax.com.pl>
Re: transaction log location Peter Childs <blue.dragon@blueyonder.co.uk>
Re: transaction log location Tom Lane <tgl@sss.pgh.pa.us>
Re: transaction log location Marcin Gil <marcin.gil@audax.com.pl>
On Thu, 25 Sep 2003, Marcin Gil wrote: > Have read the docs, tried to look through go(o)gles.. > came up with nothing... > > How can I make postgres to store transaction log on a different > drive? > Ie. my postgres files reside in /var/lib/pgsql (/dev/hda3).. > And I'd like to have transaction logs on a /dev/hdb1.. > > Regards > Once you have your database.... 1. Shut it down the database. 2. Move data/pg_xlog and data/pg_clog to another drive. 3. Symlink data/pg_xlog and data/pg_clog to this other drive. 4. Restart the database. Steps 1 and 4 are the most important!. One word of warning even though this is a log it can not be used to see whats happerning or as a method for backup. Peter Childs
В списке pgsql-novice по дате отправления
