Hi, Community Members,
I wish to install Adempiere ERP on Debian O/S under /opt/Adempiere directory, the default
data directory location on Debian O/s is in /var/lib/postgresql/8.4/main. I also want to partition
the Harddisk to set aside a Huge Volume for Data Storage partition alone.
May I know whether can I change the Actual Database Storage Location to other directory ?
Thanks in advance for any reply, assistance.
this is more a Debian question or an PostgreSQL question than an iDempiere question. If you set up a production server you will install it new with the debian installer. The installer will give you the option to create an own partition for /var. This might be a good idea for your case. See http://www.debian.org/releases/stable/i386/ch06s03.html.en#di-partition and http://www.debian.org/releases/stable/i386/apcs03.html.en
If you want to change the configuration of PostgreSQL you have to change it in /etc/postgresql/8.4/main/postgresql.conf. There is a value "data_directory". For the first try I would copy the old data dir to the new location (first stop the postgres server!). If you want to do it in a clean, "debianish" way you can create a new cluster with the debian tools. You may start at http://wiki.debian.org/PostgreSql to do that.
And Rule 4 for idempiere knights: "Use Google!"
Happy Christmas, Thank you very much for your quick reply and assistance.
Because I want to store Huge Volume of Data, I therefore feel that I better
create a Huge partition to protect my data.
If I want to backup my Data, may I know how to backup from the default data
directory location /var/lib/postgresql/8.4/main ?
Rule 4 leads to http://www.google.com/search?q=postgresql+backup and this leads to http://www.postgresql.org/docs/9.2/static/backup.html
in short: Use pg_dump. If you really want to backup the filesystem shut down your server before.
Once again, thanks a lot for assistance in providing precious Tech-Info.
Your precious Tech-Info are really very useful. It cleared and solved my exising problems.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.