1. Turn off the postgresql service first
. 2. If you want postgresql to support remote access, you need to modify the two configuration files in the data folder under the directory
Set the value of the listen_addresses item in the file to ‘*’
Add the following configuration under the host all all 127.0.0.1/32 md5 line after the ipv4 configuration of the configuration file, or directly modify this line to the following configuration host all 0.0.0.0/0 trust
If you do not want to allow all IP remote access, You can set 0.0.0.0 in the above configuration items to a specific IP value.
3. Right-click management on my computer-find service-find postgresql service, right-click to start
- [Solved] Postgres Start Error: Job for postgresql.service failed because the control process exited with error code.
- How to Solve VMware Workstation Error: The VMware Authorization Service is not running.
- [Solved] Redis startup error Creating Server TCP listening socket 127.0.0.1:6379: bind: No error
- When installing zookeeper, you can view the process start, but the status display error: Error contacting service. It is probably not running
- Docker Build Error: Failed to get D-Bus connection: Operation not permitted [Solved]
- hint: Updates were rejected because the remote contains work that you do To XXX
- Gog cannot link PSN: the connection to the server timed out
- SharePoint site shows ‘Service Unavailable. HTTP Error 503. The service is unavailable’
- How to Solve Error: java.io.IOException: Resource [classpath:shiro.ini] could not be found.
- [Solved] SpringBoot integration with Redis error: java.net.ConnectException: Connection refused: no further information
- [Solved] CentOS build a docker error: job for docker.service failed….
- [Solved] Redis—-(error) MISCONF Redis is configured to save RDB snapshots
- Analysis of npm error ENOTFOUND npm ERR! network request to https://npm.***.com/*** failed and the role of the .npmrc file
- Support for password authentication was removed on August 13, 2021
- RabbitMQ：address (cannot connect to host/port) [How to Solve]
- How to Solve SSH Login Error: WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!
- [Solved] Android Error: java.lang.IllegalStateException: Not allowed to start service Intent
- How to Fix win10 video dxgkrnl fatal error
- Zchunk error: Unable to find multipart download range error in dnf update
- Git fatal: No configured push destination. Either specify the URL from the command-line or co