Обсуждение: Connection Refused Error
I had installed pgadmin4 from git Source repo.The First time I Installed I was able to create a Server.But when I restarted my PC.I got this error.
Unable to connect to server:
could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
I tried Installing everthing Again but got the same error.I also changed postgresql.conf file from
listen_address="localhost"
to listen_address="*"
but it still didnt work.
Вложения
Hello Rahul,
Did you change the /etc/postgresql/10/main/pg_hba.conf file configuration to allow connections? if not take a look at https://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/ this should guide you but basically you need to change the METHOD to `trust` on the 127.0.0.1 address and eventually of the ::1 as well.
If that didn't help let us know
Thanks
Joao
On Wed, Mar 21, 2018 at 3:35 PM Rahul Soshte <rahulsoshte360@gmail.com> wrote:
I had installed pgadmin4 from git Source repo.The First time I Installed I was able to create a Server.But when I restarted my PC.I got this error.What do I do?
Unable to connect to server:
could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
I tried Installing everthing Again but got the same error.I also changed postgresql.conf file fromlisten_address="localhost"to listen_address="*"but it still didnt work.
Hi,
I solved the bug,actually what I had done was I had installed postgresql without the version number i.e using this command
sudo apt-get install postgresqlI solved the bug,actually what I had done was I had installed postgresql without the version number i.e using this command
I uninstalled postgresql using this command
and reinstalled with the version number i.e
sudo apt-get remove --purge postgresql-9.6
and reinstalled with the version number i.e
sudo apt-get install postgresql-9.6
https://askubuntu.com/questions/50621/cannot-connect-to-postgresql-on-port-5432
On Thu, Mar 22, 2018 at 1:23 AM, Joao De Almeida Pereira <jdealmeidapereira@pivotal.io> wrote:
Hello Rahul,Did you change the /etc/postgresql/10/main/pg_hba.conf file configuration to allow connections? if not take a look at https://www.thegeekstuff. com/2014/02/enable-remote- postgresql-connection/ this should guide you but basically you need to change the METHOD to `trust` on the 127.0.0.1 address and eventually of the ::1 as well. If that didn't help let us knowThanksJoaoOn Wed, Mar 21, 2018 at 3:35 PM Rahul Soshte <rahulsoshte360@gmail.com> wrote:I had installed pgadmin4 from git Source repo.The First time I Installed I was able to create a Server.But when I restarted my PC.I got this error.What do I do?
Unable to connect to server:
could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
I tried Installing everthing Again but got the same error.I also changed postgresql.conf file fromlisten_address="localhost"to listen_address="*"but it still didnt work.