database's on a separate partition

Lists: pgsql-cygwin
From: "Jennifer Lee" <jlee(at)scri(dot)sari(dot)ac(dot)uk>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: database's on a separate partition
Date: 2003-02-21 16:22:51
Message-ID: 2FD8D92697@law.scri.sari.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

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


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jennifer Lee <jlee(at)scri(dot)sari(dot)ac(dot)uk>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: database's on a separate partition
Date: 2003-02-21 19:04:04
Message-ID: Pine.LNX.4.44.0302212003440.2067-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

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(at)gmx(dot)net


From: Jason Tishler <jason(at)tishler(dot)net>
To: Jennifer Lee <jlee(at)scri(dot)sari(dot)ac(dot)uk>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: database's on a separate partition
Date: 2003-02-21 21:43:48
Message-ID: 20030221214347.GF1408@tishler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

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


From: "Jennifer Lee" <jlee(at)scri(dot)sari(dot)ac(dot)uk>
To: Jason Tishler <jason(at)tishler(dot)net>, pgsql-cygwin(at)postgresql(dot)org
Subject: Re: database's on a separate partition
Date: 2003-02-24 11:15:07
Message-ID: 72B9E1577D@law.scri.sari.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

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
>
> --