Importing DB Seed Manually - Revision history

CarlosRuiz at 12:35, 17 October 2025

2025-10-17T12:35:28Z

CarlosRuiz: Document how to use RUN_ImportIdempiereDev.sh

2025-10-17T12:32:35Z

Document how to use RUN_ImportIdempiereDev.sh

CarlosRuiz: /* Installing UUID (required to apply some migration scripts) */ no uuid required on r13

2025-10-17T11:07:14Z

Installing UUID (required to apply some migration scripts): no uuid required on r13

Diego.ruiz: Categorize and tag

2022-09-01T14:15:01Z

Categorize and tag

CarlosRuiz: IDEMPIERE-5187 PostgreSQL 9.6 EOL

2022-02-11T10:27:07Z

IDEMPIERE-5187 PostgreSQL 9.6 EOL

CarlosRuiz: /* Installing UUID (required to apply some migration scripts) */

2022-01-17T10:39:21Z

Installing UUID (required to apply some migration scripts)

PatSoftware: Command create extension. Added info when executed on windows System. Otherwise command goes in error.

2022-01-15T14:58:46Z

Command create extension. Added info when executed on windows System. Otherwise command goes in error.

Ocurieles: /* Create adempiere user */

2021-06-15T15:53:38Z

Create adempiere user

CarlosRuiz at 16:46, 4 November 2020

2020-11-04T16:46:27Z

CarlosRuiz: /* Installing UUID (required to apply some migration scripts) */

2020-09-12T10:47:12Z

Installing UUID (required to apply some migration scripts)

@@ Line 21: / Line 21: @@
 '''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 ==
+== Run console-setup-alt.sh to initialize the parameters ==
   cd $HOME/sources/idempiere/org.idempiere.p2/target/products/org.adempiere.server.product/linux/gtk/x86_64
@@ Line 32: / Line 32: @@
   # 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 [[Talk:Importing_DB_Seed_Manually|Discussion]] tab for additional notes.

@@ 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
-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.
 ''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.

← Older revision		Revision as of 11:07, 17 October 2025
Line 31:		Line 31:

	== Installing UUID (required to apply some migration scripts) ==		== 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:		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:

@@ Line 26: / Line 26: @@
   psql -d idempiere -U adempiere -c "ALTER ROLE adempiere SET search_path TO adempiere, pg_catalog"
-When asked the password please provide the adempiere password that you set up in the previous step.
+When asked for the password please provide the adempiere password that you set up in the previous step.
 '''NOTE:''' See [[Talk:Importing_DB_Seed_Manually|Discussion]] tab for additional notes.
@@ Line 32: / Line 32: @@
 == Installing UUID (required to apply some migration scripts) ==
-Some migration scripts references 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:
+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 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.
+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 ==
@@ Line 45: / Line 45: @@
   psql -d idempiere -U adempiere -f Adempiere_pg.dmp
-''This tutorial 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.
+''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.
 [[Category:User Manual|I]]
@@ Line 52: / Line 52: @@
 [[Category:Development‏‎]]
 [[Category:Developer documentation‏‎]]
 <!-- breadcrumb -->

@@ Line 34: / Line 34: @@
 Some migration scripts references 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"'