E
E
Egor Tregubenko2019-02-02 21:38:58
PostgreSQL
Egor Tregubenko, 2019-02-02 21:38:58

How to remove all unnecessary Postgresql processes?

There was a version of psql 9, removed it, installed 11.1, apparently 9 was not deleted correctly or completely, but now I have such errors
5c55e076f2fe7016836688.png
current pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# 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

postgresql.conf
listen_addresses = 'localhost'		# what IP address(es) to listen on;
          # comma-separated list of addresses;
          # defaults to 'localhost'; use '*' for all
          # (change requires restart)
port = 5432			# (change requires restart)
max_connections = 100			# (change requires restart)

log:
2019-02-02 09:23:45.784 GMT [5252] MESSAGE: DB system has been interrupted; last running time: 2019-02-02 09:09:57 GMT
2019-02-02 09:23:47.194 GMT [5252] MESSAGE: DB system was stopped abnormally; automatic recovery
in progress 2019-02-02 09:23:47.206 GMT [5252] MESSAGE: REDO entry starts at offset
0/1670060 1670098: expected 24, received 0
2019-02-02 09:23:47.206 GMT [5252] MESSAGE: REDO records processed to offset 0/1670060
2019-02-02 09:23:47.262 GMT [4796] MESSAGE: DB system ready accept connections

PATH environment variable is set to C:\Program Files\PostgreSQL\11\bin
netstat does not seem to show anything on port 5432, what else can I try? is there more rake if you install ubuntu psql through the terminal? (which is in win, on ubuntu itself - everything is ok)

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question