Re: [ADMIN] Is there an easy and safe way to migrate a database to a new tablespace?

2007-12-03 Thread Scott Marlowe
On Nov 26, 2007 3:05 PM, David Young <[EMAIL PROTECTED]> wrote: > Hi, > > I recently converted to using a postgresql engine that support tablespaces. > There's a database that I would like to move to a new tablespace for > performance reasons. What is the safe and correct way of doing this? The >

[ADMIN] How to identify the current WAL segment file

2007-12-03 Thread Tommy Cheng
Hi everyone, I am new to postgresql. So point me to somewhere else if you got the right direction. i am using PostgreSQL 8.1.9 on a linux system and i want to setup PITR. i found that the segment size is too large that the copying frequency is not high enough. So, i want to set up a cron job tha