[Postgresql] DBeaver 에러 : Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Connection refused: connect Connection refused: connect

 

 

 

 

 

오늘 postgresql 함수 좀 테스트 해보려고 오랜만에 DBeaver를 켰는데.. 다음과 같은 에러가 떴다.

 

Connection to localhost:5433 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

 

그래서 왜 그런가... 한 10분 찾아보다가, 서비스에서 postgresql-x64-14가 중지되어 있던 것을 발견.
실행해주면 되겠지? 라는 생각에 실행을 해줬는데. 실행이 안된다..

 

그래서 또 뭐지 3분 고민하다가, psql로 직접 들어가보기로 했다.

 

psql.exe로 실행

 

어디서 많이 본 에러다. 며칠전에 postGis가 안되서 "libintl-9.dll" 파일을 postgisgui폴더에
넣어줬었는데, 그렇게 되면 bin 폴더에는 "libintl-9.dll" 파일이 없기 때문에 postgres가 실행이 안됬던 것..
결국 bin 폴더와 postgisgui폴더 양쪽에 "libintl-9.dll"를 넣어줌으로써 해결했다. (링크)

 

실행됨

 

연동됨