https://wiki.idempiere.org/w-en/api.php?action=feedcontributions&feedformat=atom&user=PatSoftware 2026-04-27T03:32:48Z User contributions MediaWiki 1.35.2 https://wiki.idempiere.org/w-en/index.php?title=Importing_DB_Seed_Manually&diff=19901 2022-01-15T14:58:46Z

<p>PatSoftware: Command create extension. Added info when executed on windows System. Otherwise command goes in error.</p> <hr /> <div>&lt;!-- breadcrumb --&gt;<br /> &lt;font size=-2&gt;<br /> &amp;lArr;<br /> [[Installing_iDempiere|Table of Contents]] |<br /> [[Setting up Eclipse]] |<br /> Importing DB Seed Manually |<br /> [[Configuring iDempiere within Eclipse]]<br /> &amp;rArr;<br /> &lt;/font&gt;<br /> <br /> 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.<br /> <br /> Let's check the steps to create an idempiere postgres database:<br /> <br /> == Create adempiere user ==<br /> <br /> sudo su - postgres<br /> psql -U postgres -c &quot;CREATE ROLE adempiere SUPERUSER LOGIN PASSWORD 'adempiere'&quot;<br /> exit<br /> <br /> '''WARNING:''' Of course this is an insecure password, it is recommended that you set up a proper password for this user account<br /> <br /> == Create the idempiere database ==<br /> <br /> createdb --template=template0 -E UNICODE -O adempiere -U adempiere idempiere<br /> psql -d idempiere -U adempiere -c &quot;ALTER ROLE adempiere SET search_path TO adempiere, pg_catalog&quot;<br /> <br /> When asked the password please provide the adempiere password that you set up in the previous step.<br /> <br /> '''NOTE:''' See [[Talk:Importing_DB_Seed_Manually|Discussion]] tab for additional notes.<br /> <br /> == Installing UUID (required to apply some migration scripts) ==<br /> <br /> 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:<br /> <br /> * If you're running postgresql 9.6, remember from the prerequisites you must have installed postgresql-contrib to make the generate_uuid function to work (in some operating systems and postgresql versions this is the default and is not required)<br /> * Run the command CREATE EXTENSION &quot;uuid-ossp&quot; using psql<br /> psql -d idempiere -U adempiere -c 'CREATE EXTENSION &quot;uuid-ossp&quot;'<br /> If command is executed on a Windows System change the instruction with &quot;CREATE EXTENSION \&quot;uuid-ossp\&quot;&quot;, see the replacement of characters (&quot;) with (\&quot;) and (') with (&quot;) on beginning and on the end statement, otherwise command goes in error.<br /> <br /> == Import the seed ==<br /> <br /> cd /tmp<br /> jar xvf $IDEMPIERE_REPOSITORY/org.adempiere.server-feature/data/seed/Adempiere_pg.jar<br /> psql -d idempiere -U adempiere -f Adempiere_pg.dmp<br /> <br /> ''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.<br /> <br /> [[Category:User Manual|I]]<br /> [[Category:Installation|E]] <br /> [[Category:Installation Eclipse]] <br /> [[Category:Development‏‎]]<br /> [[Category:Developer documentation‏‎]]<br /> <br /> &lt;!-- breadcrumb --&gt;<br /> &lt;font size=-2&gt;<br /> &amp;lArr;<br /> [[Installing_iDempiere|Table of Contents]] |<br /> [[Setting up Eclipse]] |<br /> Importing DB Seed Manually |<br /> [[Configuring iDempiere within Eclipse]]<br /> &amp;rArr;<br /> &lt;/font&gt;</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User:PatSoftware&diff=16073 2020-01-14T15:36:52Z

<p>PatSoftware: /* Contact Details: */</p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy<br /> <br /> == Contact Details: ==<br /> <br /> Company Web Site: [https://www.patSoftware.it PAT software]&lt;br&gt;<br /> PAT software - IDempiere Company web Site page: [https://www.patsoftware.it/idempiere IDempiere]&lt;br&gt;<br /> Contact Name : Antonio Patarozzi&lt;br&gt;<br /> City: Rimini - Emilia Romagna&lt;br&gt;<br /> Country: Italy&lt;br&gt;</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User:PatSoftware&diff=16072 2020-01-14T15:35:56Z

<p>PatSoftware: Created page with &quot;About Contact Details: Web: [https://www.patSoftware.it PAT software] Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere] Contact Name : Antonio Patarozzi C...&quot;</p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy<br /> <br /> == Contact Details: ==<br /> <br /> Web: [https://www.patSoftware.it PAT software]&lt;br&gt;<br /> PAT software - IDempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]&lt;br&gt;<br /> Contact Name : Antonio Patarozzi&lt;br&gt;<br /> City: Rimini - Emilia Romagna&lt;br&gt;<br /> Country: Italy&lt;br&gt;</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User_talk:PatSoftware&diff=16071 2020-01-14T15:04:07Z

<p>PatSoftware: /* Contact Details: */</p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy<br /> <br /> == Contact Details: ==<br /> <br /> Web: [https://www.patSoftware.it PAT software]&lt;br&gt;<br /> PAT software - IDempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]&lt;br&gt;<br /> Contact Name : Antonio Patarozzi&lt;br&gt;<br /> City: Rimini - Emilia Romagna&lt;br&gt;<br /> Country: Italy&lt;br&gt;</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User_talk:PatSoftware&diff=16070 2020-01-14T15:03:48Z

<p>PatSoftware: /* Contact Details: */</p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy<br /> <br /> == Contact Details: ==<br /> <br /> Web: [https://www.patSoftware.it PAT software]&lt;br&gt;<br /> PAT software - Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]&lt;br&gt;<br /> Contact Name : Antonio Patarozzi&lt;br&gt;<br /> City: Rimini - Emilia Romagna&lt;br&gt;<br /> Country: Italy&lt;br&gt;</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User_talk:PatSoftware&diff=16069 2020-01-14T15:03:25Z

<p>PatSoftware: /* Contact Details: */</p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy<br /> <br /> == Contact Details: ==<br /> <br /> Web: [https://www.patSoftware.it PAT software]&lt;br&gt;<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]&lt;br&gt;<br /> Contact Name : Antonio Patarozzi&lt;br&gt;<br /> City: Rimini - Emilia Romagna&lt;br&gt;<br /> Country: Italy&lt;br&gt;</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User_talk:PatSoftware&diff=16068 2020-01-14T15:02:30Z

<p>PatSoftware: </p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy<br /> <br /> == Contact Details: ==<br /> <br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User_talk:PatSoftware&diff=16067 2020-01-14T15:01:58Z

<p>PatSoftware: /* Contact Details: */ new section</p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy<br /> <br /> == Contact 2 ==<br /> <br /> Test<br /> <br /> == Contact Details: ==<br /> <br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User_talk:PatSoftware&diff=16066 2020-01-14T15:01:09Z

<p>PatSoftware: /* Contact 2 */ new section</p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy<br /> <br /> == Contact 2 ==<br /> <br /> Test</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User_talk:PatSoftware&diff=16065 2020-01-14T15:00:31Z

<p>PatSoftware: </p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> Contact Name : Antonio Patarozzi<br /> City: Rimini - Emilia Romagna<br /> Country: Italy</div>

PatSoftware https://wiki.idempiere.org/w-en/index.php?title=User_talk:PatSoftware&diff=16064 2020-01-14T14:59:02Z

<p>PatSoftware: Created page with &quot;About Contact Details: Web: [https://www.patSoftware.it PAT software] Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere] City: Rimini - Emilia Romagna Coun...&quot;</p> <hr /> <div>About<br /> <br /> Contact Details:<br /> Web: [https://www.patSoftware.it PAT software]<br /> Idempiere Site page: [https://www.patsoftware.it/idempiere IDempiere]<br /> City: Rimini - Emilia Romagna<br /> Country: Italy</div>

PatSoftware