# Problem Postgres restarting suddenly

**URL:** <https://community.mosip.io/t/problem-postgres-restarting-suddenly/425>\
**Category:** General\
**Created:** [April 18, 2023, 2:05pm UTC](https://community.mosip.io/t/problem-postgres-restarting-suddenly/425 "2023-04-18T14:05:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![slimab](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@slimab](https://community.mosip.io/u/slimab)\
**Post date:** [April 18, 2023, 2:05pm UTC](https://community.mosip.io/t/problem-postgres-restarting-suddenly/425/1 "2023-04-18T14:05:27Z")

</div>

Hello,  
The postgres was restarted suddenly, and databases are deleted, so what could be the possible cause

Logs:  
mozipadmin@nginx02:~/mosip-infra/deployment/v3/external$ kubectl logs pod/postgres-postgresql-0 -n postgres  
postgresql 08:35:34.44  
postgresql 08:35:34.52 Welcome to the Bitnami postgresql container  
postgresql 08:35:34.52 Subscribe to project updates by watching [https://github.com/bitnami/bitnami-docker-postgresql](https://github.com/bitnami/bitnami-docker-postgresql)  
postgresql 08:35:34.52 Submit issues and feature requests at [https://github.com/bitnami/bitnami-docker-postgresql/issues](https://github.com/bitnami/bitnami-docker-postgresql/issues)  
postgresql 08:35:34.52  
postgresql 08:35:34.67 INFO ==\> \*\* Starting PostgreSQL setup \*\*  
postgresql 08:35:34.70 INFO ==\> Validating settings in POSTGRESQL\_\* env vars…  
postgresql 08:35:34.71 INFO ==\> Loading custom pre-init scripts…  
postgresql 08:35:34.75 INFO ==\> Initializing PostgreSQL database…  
postgresql 08:35:34.88 INFO ==\> pg\_hba.conf file not detected. Generating it…  
postgresql 08:35:34.88 INFO ==\> Generating local authentication configuration  
postgresql 08:35:47.45 INFO ==\> Starting PostgreSQL in background…  
postgresql 08:35:47.70 INFO ==\> Changing password of postgres  
postgresql 08:35:47.85 INFO ==\> Configuring replication parameters  
postgresql 08:35:47.89 INFO ==\> Configuring synchronous\_replication  
postgresql 08:35:47.89 INFO ==\> Configuring fsync  
postgresql 08:35:47.95 INFO ==\> Loading custom scripts…  
postgresql 08:35:47.95 INFO ==\> Enabling remote connections  
postgresql 08:35:47.98 INFO ==\> Stopping PostgreSQL…  
waiting for server to shut down… done  
server stopped  
postgresql 08:35:48.21 INFO ==\> \*\* PostgreSQL setup finished! \*\*

postgresql 08:35:48.25 INFO ==\> \*\* Starting PostgreSQL \*\*  
2023-04-18 08:35:48.311 GMT [1] LOG: pgaudit extension initialized  
2023-04-18 08:35:48.312 GMT [1] LOG: listening on IPv4 address “0.0.0.0”, port 5432  
2023-04-18 08:35:48.312 GMT [1] LOG: listening on IPv6 address “::”, port 5432  
2023-04-18 08:35:48.323 GMT [1] LOG: listening on Unix socket “/tmp/.s.PGSQL.5432”  
2023-04-18 08:35:48.387 GMT [137] LOG: database system was shut down at 2023-04-18 08:35:48 GMT  
2023-04-18 08:35:48.435 GMT [1] LOG: database system is ready to accept connections  
2023-04-18 08:35:55.170 GMT [152] FATAL: database “mosip\_pms” does not exist  
2023-04-18 08:35:55.213 GMT [153] FATAL: database “mosip\_prereg” does not exist  
2023-04-18 08:35:55.752 GMT [154] FATAL: database “mosip\_regprc” does not exist  
2023-04-18 08:35:56.228 GMT [155] FATAL: database “mosip\_audit” does not exist

---

<div class="post-metadata">

**Author:** ![gsasikumar](https://avatars.discourse-cdn.com/v4/letter/g/b782af/32.png) [@gsasikumar](https://community.mosip.io/u/gsasikumar)\
**Post date:** [April 19, 2023, 6:39am UTC](https://community.mosip.io/t/problem-postgres-restarting-suddenly/425/2 "2023-04-19T06:39:12Z")

</div>

@slimab there seems to be something wrong with your storage or underlying virtual machine.

We have not seen this issue but there is always a chance of this happening.

---

<div class="post-metadata">

**Author:** ![sanchi-singh24](https://dub1.discourse-cdn.com/flex017/user_avatar/community.mosip.io/sanchi-singh24/32/538_2.png) [@sanchi-singh24](https://community.mosip.io/u/sanchi-singh24)\
**Post date:** [September 29, 2023, 11:35am UTC](https://community.mosip.io/t/problem-postgres-restarting-suddenly/425/3 "2023-09-29T11:35:15Z")

</div>

Closed on September 29, 2023, 11:35am UTC


