Thread: database's on a separate partition

Hello,

I'm running cygwin 1.3.2 and postgresql 7.3.1 on Windows XP. I
wanted to initialize postgres so the databases will be stored on a
separate partition from where cygwin and postgresql are installed.
e.g.
cygwin and postgresql are on c:
if I run :
initidb -D /cygdrive/k:/postgresql/data
where c: and k: are different partitions on the same disk.

Has anyone run into problems doing something like this, or is it not
recomended? I've searched the archives and not found anything that
says not to.

Thanks in Advance,
Jennifer

Jennifer Lee writes:

> I'm running cygwin 1.3.2 and postgresql 7.3.1 on Windows XP. I
> wanted to initialize postgres so the databases will be stored on a
> separate partition from where cygwin and postgresql are installed.

This is completely normal.

--
Peter Eisentraut   peter_e@gmx.net

Jennifer,

On Fri, Feb 21, 2003 at 04:22:51PM +0000, Jennifer Lee wrote:
> I'm running cygwin 1.3.2 and postgresql 7.3.1 on Windows XP. I
> wanted to initialize postgres so the databases will be stored on a
> separate partition from where cygwin and postgresql are installed.
> e.g.
> cygwin and postgresql are on c:
> if I run :
> initidb -D /cygdrive/k:/postgresql/data
                        ^
                        *

> where c: and k: are different partitions on the same disk.
>
> Has anyone run into problems doing something like this, or is it not
> recomended? I've searched the archives and not found anything that
> says not to.

The above is fine except for the colon.  Remove it and you should be
fine.

BTW, you can use mount points or symlinks so that things look more
Unixy.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Thanks so much.  I'll give them both a try.

cheers,
Jennifer

> Jennifer,
>
> > /cygdrive/k:/postgresql/data
>                         ^
>                         *
>
> > where c: and k: are different partitions on the same disk.
> >
> > Has anyone run into problems doing something like this, or is it not
> > recomended? I've searched the archives and not found anything that says
> > not to.
>
> The above is fine except for the colon.  Remove it and you should be
> fine.
>
> BTW, you can use mount points or symlinks so that things look more
> Unixy.
>
> Jason
>
> --