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=#
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 <jan@xxxxxxxxxxxxx> 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.
