安装时错误，没有"ad_system"

miltonyoung

===========> MSystem.get: get
org.postgresql.util.PSQLException: ERROR: relation "ad_system" does not exist; State=42P01; ErrorCode=0

pshen

貌似数据导入错误。
用PGAdmin看看，数据库都有哪些表了？

irg010irg

PDF] Best of 2007 Selection

irg010irg

I got this problem too,By: moyses (moyses) - 2007-09-28 07:19
It looks like if you have not imported the postgresql dump.
Please verify that you have a lot of tables in postgresql, of course one of them should ad_system
By: vshpigel (istarin) - 2007-09-28 07:31
Thank you, I really did not and there are no tables in adempiere db. But I thought that's what installation script should
do and I did not see any instruction to do it in the manual. Where can I find the db dump?
By: moyses (moyses) - 2007-09-28 10:53
This is how to do it on Ubuntu
http://www.posterita.org/mediawi ... _PL/Java%29_for_ADe
mpiere#Importing_the_database_dump
For another platforms you can find more info here: http://www.adempiere.com/wiki/index.php/ADempiere_Installing

irg010irg

http://www.posterita.org/mediawi ... g the database dump

Go to pgAdminIII
Connect to the server
Go to Adempiere database and drop cascade sqlj schema
Now you can import your database
Open a terminal and type in
  su - postgres
  psql -d adempiere </home/user/Adempiere/data/Adempiere_pg.dmp