Restore database into azure PostgreSQL

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Restore database into azure PostgreSQL

mahesh ravilla
Hi, when restore a on promises database into azure PostgreSQL. I am ge3a error please help ASAP.

Could not connect to server :connection refused
Is the server running on host " azure_server_name" (000.000.000.00)  and accepting
Tcp/ip connection on port 5432?

Thanks 
Mahesh Ravilla 

Reply | Threaded
Open this post in threaded view
|

Re: Restore database into azure PostgreSQL

Adrian Klaver-4
On 7/11/19 9:25 AM, mahesh ravilla wrote:
> Hi, when restore a on promises database into azure PostgreSQL. I am ge3a
> error please help ASAP.
>
> Could not connect to server :connection refused
> Is the server running on host " azure_server_name" (000.000.000.00)  and
> accepting
> Tcp/ip connection on port 5432?

Connection troubleshooting:

1) Verify Postgres server is actually running.

2) Verify what port it is listening on(5432 is default).

3) Verify correct hostname.

4) Check to see if there is a firewall blocking the Postgres server port.

>
> Thanks
> Mahesh Ravilla
>


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: Restore database into azure PostgreSQL

Tim Clarke-3

On 11/07/2019 17:29, Adrian Klaver wrote:

> On 7/11/19 9:25 AM, mahesh ravilla wrote:
>> Hi, when restore a on promises database into azure PostgreSQL. I am
>> ge3a error please help ASAP.
>>
>> Could not connect to server :connection refused
>> Is the server running on host " azure_server_name" (000.000.000.00)
>> and accepting
>> Tcp/ip connection on port 5432?
>
> Connection troubleshooting:
>
> 1) Verify Postgres server is actually running.
>
> 2) Verify what port it is listening on(5432 is default).
>
> 3) Verify correct hostname.
>
> 4) Check to see if there is a firewall blocking the Postgres server port.
>
>>
>> Thanks
>> Mahesh Ravilla
>>
>

Looks like that (dns?) symbol azure_server_name points to a broken IP
address?

Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420



Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/



Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom

________________________________

Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to [hidden email]<mailto:[hidden email]>
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.