1. 安装postgresql-12

• yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
• yum install postgresql12 postgresql12-server
• /usr/pgsql-12/bin/postgresql-12-setup initdb
• systemctl enable postgresql-12
• systemctl start postgresql-12

2. 修改用户postgres密码

• passwd postgres

3. 设置idempiere数据库

su - postgres
psql
ALTER USER postgres WITH PASSWORD '你的postgres密码';
CREATE USER adempiere WITH PASSWORD '你的密码';
CREATE DATABASE idempiere ENCODING 'UTF8'  OWNER adempiere;
GRANT ALL PRIVILEGES ON DATABASE idempiere to adempiere;

4. 安装openjdk

• yum install java-11-openjdk.x86_64 java-11-openjdk-devel.x86_64

5. 设置JAVA环境变量

export JAVA_HOME=/usr/lib/jvm/java-11-openjdk-11.0.5.10-0.el7_7.x86_64
export JRE_HOME=$JAVA_HOME/jre
export CLASSPATH=$JAVA_HOME/lib:$JRE_HOME/lib:$CLASSPATH
export PATH=/usr/local/python38/bin:/root/.local/bin:$JAVA_HOME/bin:$JRE_HOME/bin:$PATH

6. 修改/var/lib/pgsql/12/data/pg_hba.conf

• local all all md5
• host all all 127.0.0.1/32 md5
• host all all ::1/128 md5
• systemctl restart postgresql-12

7. 解压idempiere至```/opt/idempiere-server
8. ./console-setup.sh #./console-setup-alt.sh
9. 解压./data/seed/Adempiere_pg.jar
10. ./utils/RUN_ImportIdempiere.sh
11. 运行idempiere

• ./idempiere-server.sh

12. 设置开机启动

chmom +x /etc/rc.d/rc.local
systemctl start rc-local
systemctl enable rc-local
echo    "/opt/idempiere-server/idempiere-server.sh"  >> /etc/rc.d/rc.local

登录用户名及密码

su postgres
psql -d idempiere -U adempiere --password
select name, password from ad_user;