I can't connect by psql like this:
./psql -h localhost -p 5432 -d template1.
Here is some data:
$ ./psql -h 127.0.0.1 -p 5342 -d template1
psql: error: could not connect to server: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5342?
$ ./postgres -d 3 -D C:/msys64/usr/local/pgsql/data -c config_file=/c:/msys64/usr/local/pgsql/data/postgresql.conf
2019-05-07 22:39:19.833 EDT  LOG: starting PostgreSQL 12devel on x86_64-w64-mingw32, compiled by x86_64-w64-mingw32-gcc.exe (Rev2, Built by MSYS2 project) 8.3.0, 64-bit
2019-05-07 22:39:19.838 EDT  LOG: listening on IPv6 address "::1", port 5432
2019-05-07 22:39:19.838 EDT  LOG: listening on IPv4 address "127.0.0.1",
It (postmaster) is still going. No idea why I can't connect with psql client.
Here is my pg_hba.conf:
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust
Any ideas guys/gals?
I normally don't get this stuck. There is something blocking ./psql from connecting to anything.
I might want to mention I built it with mingw. I put the bin directory in path. I am using mingw msys2. I don't see a process when I do ps -ef | grep postgres but I can see where the server is running continually. I am using the version on GitHub.
thanks for any ideas on what I can try.
Hi thnx for that Andres. Typos may end up being the death of me. Will check tomorrow evening. Thnx!
On Tue, May 7, 2019, 11:11 PM Andrés Rodríguez <[hidden email]> wrote:
In reply to this post by Gavin M2301
Hey laetitia -
I changed the command to launch the server. Now I can see the server process. I can connect with Windows console (cmd). Mingw msys hangs when I try to get to a cmd prompt with psql command. I will just use windows shell.
Last night, I had 2 conflicts. I had a server running from older version of postgres I saw in services, so I uninstalled that prior version. Then I had transposed port number and kept trying to execute it with console history.
So thanks for the help pointing out wrong port number and troubleshooting.
I am off to execute some cmake code to see if soci 4 will work with postgresql.
On Wed, May 8, 2019, 3:04 AM Lætitia Avrot <[hidden email]> wrote:
|Free forum by Nabble||Edit this page|