| From: | Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk> |
|---|---|
| To: | Marcin Gil <marcin(dot)gil(at)audax(dot)com(dot)pl> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: transaction log location |
| Date: | 2003-09-25 07:32:40 |
| Message-ID: | Pine.LNX.4.44.0309250818260.21236-100000@RedDragon.Childs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kaarel | 2003-09-25 11:20:16 | Re: Learning pl/pgsql - good sources? |
| Previous Message | Marcin Gil | 2003-09-25 07:31:40 | Re: transaction log location |