requarks / wiki

Wiki.js | A modern and powerful wiki app built on Node.js
https://js.wiki
GNU Affero General Public License v3.0
24.43k stars 2.7k forks source link

Error in Connecting with Postgres database (Some malware runs and kills postgresql) #6869

Closed ponmani-axim closed 9 months ago

ponmani-axim commented 10 months ago

Discussed in https://github.com/requarks/wiki/discussions/6861

Originally posted by **ponmani-axim** November 30, 2023 We have installed the latest version of Postgres database(16.1) in Azure VM(3.5GB RAM) and wiki.js 2.5.300(Docker image). Also we have integrated storage to GitHub. All the things are working fine for 10 -15 hours. Later we are getting the error in wiki service console as, ![image](https://github.com/requarks/wiki/assets/21217869/f24d701a-3466-43b2-be86-5491644936d8). Below one is from /var/log/postgresql/postgresql-16-main.log ![image](https://github.com/requarks/wiki/assets/21217869/fd04ae1f-e1a9-4149-b2d2-35afef37b8cb) After restarting the Postgres, the site again works . But the error is repeating after some time.
ponmani-axim commented 9 months ago

Fixed the error by,

Created a new VM and installed Postgres Strong password for Postgres database Open port to specific IP address.