Difference between revisions of "Importing DB Seed Manually"

Revision as of 14:32, 17 October 2025

⇐ Table of Contents | Setting up Eclipse | Importing DB Seed Manually | Configuring iDempiere within Eclipse ⇒

Please note this procedure is intended for technical people wanting to configure iDempiere to run in Eclipse, there is an easier mechanism on the installers to create the database.

Let's check the steps to create an idempiere postgres database:

Set a password for the postgres user

sudo su - postgres
psql -U postgres -c "ALTER USER postgres PASSWORD 'TheSystemPassword'"
exit

WARNING: Of course this is an insecure password, it is recommended that you set up a proper password for this user account. You need this password for the instructions below

Run console-setup-alt.sh

cd $HOME/sources/idempiere/org.idempiere.p2/target/products/org.adempiere.server.product/linux/gtk/x86_64
bash console-setup-alt.sh
# answer all questions from this program, you can choose here database name, etc, take care of the two passwords:
  Database Password [adempiere]:
    answer this question with your desired password for the adempiere user
  Database System User Password []:
    TheSystemPassword  <- answer this question with the password you set on the previous step
# at the end the program must have generated two files, move them:
mv idempiere.properties .idpass $HOME/sources/idempiere
cd $HOME/sources/idempiere
bash RUN_ImportIdempiereDev.sh

The last command must import the database and apply all the migration scripts.

NOTE: See Discussion tab for additional notes.

This How-To is brought to you by Carlos Ruiz from BX Service GmbH. Feel free to improve directly or suggest using the Discussion tab.

⇐ Table of Contents | Setting up Eclipse | Importing DB Seed Manually | Configuring iDempiere within Eclipse ⇒

@@ Line 13: / Line 13: @@
 Let's check the steps to create an idempiere postgres database:
-== Create adempiere user ==
+== Set a password for the postgres user ==
   sudo su - postgres
-  psql -U postgres -c "CREATE ROLE adempiere SUPERUSER LOGIN PASSWORD 'adempiere'"
+  psql -U postgres -c "ALTER USER postgres PASSWORD 'TheSystemPassword'"
   exit
-'''WARNING:''' Of course this is an insecure password, it is recommended that you set up a proper password for this user account
+'''WARNING:''' Of course this is an insecure password, it is recommended that you set up a proper password for this user account.  You need this password for the instructions below
-== Create the idempiere database ==
+== Run console-setup-alt.sh ==
-  createdb  --template=template0 -E UNICODE -O adempiere -U adempiere idempiere
+  cd $HOME/sources/idempiere/org.idempiere.p2/target/products/org.adempiere.server.product/linux/gtk/x86_64
-  psql -d idempiere -U adempiere -c "ALTER ROLE adempiere SET search_path TO adempiere, pg_catalog"
+  bash console-setup-alt.sh
+ # answer all questions from this program, you can choose here database name, etc, take care of the two passwords:
+   Database Password [adempiere]:
+     answer this question with your desired password for the adempiere user
+   Database System User Password []:
+     TheSystemPassword  <- answer this question with the password you set on the previous step
+ # at the end the program must have generated two files, move them:
+ mv idempiere.properties .idpass $HOME/sources/idempiere
+  cd $HOME/sources/idempiere
+ bash RUN_ImportIdempiereDev.sh
-When asked for the password please provide the adempiere password that you set up in the previous step.
+The last command must import the database and apply all the migration scripts.
 '''NOTE:''' See [[Talk:Importing_DB_Seed_Manually|Discussion]] tab for additional notes.
-== Installing UUID (required to apply some migration scripts) ==
-NOTE: This is required for release-12, but on release-13 is not required anymore
-Some migration scripts reference the function generate_uuid, unfortunately, the way to install this is different on different postgres versions, so we were not able to include it by default on the DB seed, next are the instructions per version:
-* Run the command CREATE EXTENSION "uuid-ossp" using psql
- psql -d idempiere -U adempiere -c 'CREATE EXTENSION "uuid-ossp"'
-NOTE ON WINDOWS: If the command is executed on a Windows System change the instruction with "CREATE EXTENSION \"uuid-ossp\"", see the replacement of characters (") with (\") and (') with (") on beginning and on the end statement, otherwise command goes in error.
-== Import the seed ==
- cd /tmp
- jar xvf $IDEMPIERE_REPOSITORY/org.adempiere.server-feature/data/seed/Adempiere_pg.jar
- psql -d idempiere -U adempiere -f Adempiere_pg.dmp
 ''This How-To is brought to you by [[User:CarlosRuiz|Carlos Ruiz]] from [https://www.bx-service.com/ BX Service GmbH].  Feel free to improve directly or suggest using the Discussion tab.