On Dec 6, 2007 4:24 AM, Dave Coventry <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm setting up a server which I've partitioned into /, /home and swap.
>
> I plan to keep, all data on the /home partition, is there a way I can
> specify that Postgres keeps it's database on that partition?
Yes.
When you set up the server, you can specify a location via the initdb
command. You also need to adjust your startup scripts to use the new
location.
Now, if you want more advanced options (for example, specifying that certain
tables are stored on one disk array and others on another) you can use
PostgreSQL tablespaces. See the PostgreSQL documentation for more on this
topic.
Phil's approach also works, FWIW.
Best Wishes.
Chris Travers
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
