Re: Location of Database

[Phil Rhoades <..hidden..>]

Dave,


On Thu, 2007-12-06 at 14:24 +0200, Dave Coventry 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?


I do that to simplify backup procedures.  If postgresql has been set up
in the usual way, do the following as root:

	service postgresql stop

move the datadir :

	mv /var/lib/pgsql/data /home/

and symlink:

	ln -s /home/data /var/lib/pgsql/data

- that should do what you want.

Phil.


> Many Thanks,
> 
> Dave Coventry
> 
> -------------------------------------------------------------------------
> 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 
-- 
Philip Rhoades

Pricom Pty Limited  (ACN 003 252 275  ABN 91 003 252 275)
GPO Box 3411
Sydney NSW      2001
Australia
Fax:     +61:(0)2-8221-9599
E-mail:  ..hidden..