as per above conversation. i checked connectivity details as it is connected to database (even hostname i mentioned connected to database) psql --host 192.168.168.201 --user postgres -d raghu Password for user postgres: psql.bin (9.4.8, server 9.4.4) Type "help" for help.
No entry for terminal type "xterm"; using dumb terminal settings. raghu=# On Thu, Jun 16, 2016 at 8:51 PM, Jan de Visser <j...@de-visser.net> wrote: > Please don't top-post. > > On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne wrote: > > hi > > sir > > as per above discussion same error repeated even mentioned ip address of > > hostname > > > > ./runMTK.sh -sourcedbtype sqlserver -targetSchema public -schemaOnly > > -allTables dbo > > > > > > TARGET_DB_URL=jdbc:postgresql://192.168.168.201:5432/raghu > > TARGET_DB_USER=postgres > > TARGET_DB_PASSWORD=***** > > > > > > > > Connecting with source SQL Server database server... > > Connected to Microsoft SQL Server, version '10.50.1600' > > Connecting with target EnterpriseDB database server... > > MTK-10045: The URL specified for the "target" database is invalid. > > Check the connectivity credentials. > > Stack Trace: > > com.edb.MTKException: MTK-10045: The URL specified for the "target" > > database is invalid. > > Check the connectivity credentials. > > > > So have you tried the connectivity details? What does > > $ psql --host 192.168.168.201 --user postgres -d raghu > > give you? > > I have a sneaking suspicion you don't have TCP/IP access to the database > configured in pg_hba.conf. > > > > >
