error idempiere database NOTICE: schema "adempiere" does not exist

[Yesid Rodriguez]

Hi I am new in the world to idempiere, I am instaling idempiere with elipse but i Have one problem


when I Create the idempiere database in the tutorial show 

createdb  --template=template0 -E UNICODE -O adempiere -U adempiere idempiere
psql -d idempiere -U adempiere -c "ALTER ROLE adempiere SET search_path TO adempiere, pg_catalog"

I obtain the follow error 

postgres@yesid-System-Product-Name:/home/yesid$ psql -d idempiere -U adempiere -c "ALTER ROLE adempiere SET search_path TO adempiere, pg_catalog"
Password for user adempiere:
NOTICE: schema "adempiere" does not exist
ALTER ROLE
postgres@yesid-System-Product-Name:/home/yesid$

Could anybody help me with it please?

[Marco Longo]

did you check that the Db is really created ?

Use pgadmin,  phppgadmin or with psql  use the \list comand to show all the databases 

Marco

[Carlos Antonio Ruiz Gomez]

Hi Yesid, a NOTICE is not an error.

Regards,

Carlos Ruiz

[Carlos Antonio Ruiz Gomez]

Hi, seems like the character before the word template is not a dash

Regards,

Carlos Ruiz


On 14/12/13 13:49, Yesid Rodriguez wrote:

thanks I have review and, I repeated the steps so:

root@yesid-System-Product-Name:/home/yesid# createdb �template=template0 -E UNICODE -O adempiere -U adempiere idempiere

createdb: database creation failed: ERROR: �database "�template=template0" already exists

but now �I have it message

root@yesid-System-Product-Name:/home/yesid# psql -d idempiere -U adempiere -c "ALTER ROLE adempiere SET search_path TO adempiere, pg_catalog"

psql: FATAL: �database "idempiere" does not exist

root@yesid-System-Product-Name:/home/yesid#�

i dont understand�

2013/12/14 Marco Longo <longo....@gmail.com>

did you check that the Db is really created ?

Use pgadmin, �phppgadmin or with psql �use the \list comand to show all the databases�

Marco

Il giorno sabato 14 dicembre 2013 16:25:59 UTC+1, Yesid Rodriguez ha scritto:

Hi I am new in the world to idempiere, I am instaling idempiere with elipse but i Have one problem

when I Create the idempiere database in the tutorial show�

createdb  --template=template0 -E UNICODE -O adempiere -U adempiere idempiere
psql -d idempiere -U adempiere -c "ALTER ROLE adempiere SET search_path TO adempiere, pg_catalog"

I obtain the follow error�

[Ahmed Elemam]

Creat it Manually