Kompiere Libero (Manufacturing) / Discussion / PostgreSQL: How to import data

How to import data

Forum: PostgreSQL

Creator: Jesper Vels

Created: 2005-07-13

Updated: 2013-04-02

Jesper Vels - 2005-07-13

Hi

How can i import the data to my posgreSQL db (CMPCSPostgreSQL.jr file)?

Best Regrads
Jesper Vels

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Victor Perez Juarez - 2005-07-13
  
  You have to do this:
  first uncompress the jar file:
  jar -xvf ${PG_HOME}/Compiere2/data/CMPCSPostgreSQL.jar
  
  and then import the dump:
  psql -U compiere -f ${PG_HOME}/Compiere2/data/KompierePGSQL.dmp kompiere
  
  Best Regards
  Victor Perez
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- omid - 2007-08-22
  
  I extract this jar file but there is no KompierePGSQL.dmp
  Instead of it there is cmpcs.dmp
  Information
  Database name : kompiere
  Role : compiere
  Username : compiere password : compiere
  and there is some warning when i run
  psql -U compiere -d kompiere -f cmpcs.dmp
  What should i do?
  Kindly regards
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.