Re: How to extend database to another disk space

I'm having a hard time thinking of how to do this on a windows box, you
might want to ask on the -cgwyn list. I would think what you need to do
is shutdown the db, install the second hard drive. initdb on the second
hard drive, copy your data files up, then fire back up the database.
Moving the logs might be easier, you should be able to specify a new
location for log output fairly easily, and can just point this to the
new hard drive. Take it all with a grain of salt, I'm not uh.. brave(?)
enough to run windows on a production system.

Robert Treat

On Tue, 2003-02-11 at 14:18, Kevin Tsang wrote:
> Hi,
>
> I am running:
> Intel P4, 512Mb Memory, 60Gb Hard Drive
> Windows2000 Pro, Service Pack 2
> PostgreSQL 7.3
> cygwin dll 1.3.12-2
> ipc 1.11-1
>
> Can anyone tell me how to extend the database and logs to another disk
> space in case of a disk filled up?
> Many Thanks
>
> Kevin
>
>