Where is Data Storage Actual Location?

  • AngKC

    AngKC - 2012-12-21

    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.


  • Thomas Bayen

    Thomas Bayen - 2012-12-21


    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,

  • AngKC

    AngKC - 2012-12-21

    Hi, Thomas
    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 ?


  • AngKC

    AngKC - 2012-12-22

    Hi, Thomas

    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.



Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks