Hello,
An quicker option would be to use rsync (on a stopped database of
course). You can rsync to a new directory (off the filesystem) and then
reformat the data filesystem and move it back.
J
Somasekhar Bangalore wrote:
Hi,
I too had the same problem; There was one query which used to ta
On Tue, Dec 16, 2003 at 10:29:20PM +, Jaime Casanova wrote:
> >On Fri, Dec 12, 2003 at 09:59:23AM +0530, Somasekhar Bangalore wrote:
> >>I too had the same problem; There was one query which used to take a
> >>very long time. What I did was, I took a backup of the whole database.
> >>Reinstal
On Fri, Dec 12, 2003 at 09:59:23AM +0530, Somasekhar Bangalore wrote:
> Hi,
>
> I too had the same problem; There was one query which used to take a
> very long time. What I did was, I took a backup of the whole database.
> Reinstalled postgres on a different mount point and restored the data
> b
