Hi,
i have this ERRORS when i try to synchronise between two tables in two different postgresql DB
any help please...??
connecting to socket on port 3493
connected
Exception in component tPostgresqlInput_1
org.postgresql.util.PSQLException: ERROR: schema "pg_rami" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)
at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.tPostgresqlInput_1Process(cnx_2_bd_pg.java:645)
at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.runJobInTOS(cnx_2_bd_pg.java:1189)
at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.main(cnx_2_bd_pg.java:1057)
disconnected
PS:
"pg_rami" is my input DB name
"cnx_2_bd_pg_0_1" is my job name
Hi
Welcome to talend community!
The concepts of schema and DB are different.
The error shows that you type DB name in Schema textfield.
You'd better check all parameters from postgresql.
Regards,
Pedro
