Waiting for PostgreSQL to startup. 重启机器后，镜像被清掉，重新部署安装遇到Waiting for PostgreSQL to startup.

[FancyXun]

csghub-temporal-1 这个一直启动失败，我看是等待pgsql的启动。v1.5.1版本 ，机器重启前都能正常运行

[samchen8008]

@Rader pls check it out

[Rader]

@FancyXun is the postgres container running?

[FancyXun]

Of course. postgres logs follows:

2025-03-27 07:19:00.404 UTC [49] LOG:  received fast shutdown request
waiting for server to shut down....2025-03-27 07:19:00.404 UTC [49] LOG:  aborting any active transactions
2025-03-27 07:19:00.406 UTC [49] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
2025-03-27 07:19:00.408 UTC [50] LOG:  shutting down
2025-03-27 07:19:00.408 UTC [50] LOG:  checkpoint starting: shutdown immediate
2025-03-27 07:19:00.675 UTC [50] LOG:  checkpoint complete: wrote 3663 buffers (22.4%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.086 s, sync=0.179 s, total=0.267 s; sync files=1196, longest=0.002 s, average=0.001 s; distance=16890 kB, estimate=16890 kB
2025-03-27 07:19:00.694 UTC [49] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

2025-03-27 07:19:00.740 UTC [1] LOG:  starting PostgreSQL 15.10 (Debian 15.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-27 07:19:00.741 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-03-27 07:19:00.741 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-03-27 07:19:00.742 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-27 07:19:00.747 UTC [86] LOG:  database system was shut down at 2025-03-27 07:19:00 UTC
2025-03-27 07:19:00.755 UTC [1] LOG:  database system is ready to accept connections
2025-03-27 07:24:00.771 UTC [84] LOG:  checkpoint starting: time
2025-03-27 07:24:04.885 UTC [84] LOG:  checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.109 s, sync=0.003 s, total=4.115 s; sync files=12, longest=0.001 s, average=0.001 s; distance=252 kB, estimate=252 kB
2025-03-27 07:37:47.405 UTC [1] LOG:  received fast shutdown request
2025-03-27 07:37:47.405 UTC [1] LOG:  aborting any active transactions
2025-03-27 07:37:47.409 UTC [1] LOG:  background worker "logical replication launcher" (PID 89) exited with exit code 1
2025-03-27 07:37:47.409 UTC [84] LOG:  shutting down
2025-03-27 07:37:47.409 UTC [84] LOG:  checkpoint starting: shutdown immediate
2025-03-27 07:37:47.412 UTC [84] LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=227 kB
2025-03-27 07:37:47.420 UTC [1] LOG:  database system is shut down

PostgreSQL Database directory appears to contain a database; Skipping initialization

2025-03-27 11:26:16.988 UTC [1] LOG:  starting PostgreSQL 15.10 (Debian 15.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-27 11:26:16.988 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-03-27 11:26:16.988 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-03-27 11:26:16.989 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-27 11:26:16.993 UTC [29] LOG:  database system was shut down at 2025-03-27 07:37:47 UTC
2025-03-27 11:26:17.000 UTC [1] LOG:  database system is ready to accept connections

[FancyXun]

@Rader

[Rader]

@FancyXun I see your temporal service is up for 21 hours in the screenshot. So i guess the postgres service stop and start again, but temporal not. is that correcgt?

if so, try restart temporal service manully.

[wayneliu0019]

很抱歉，根据我检索到的资料，我无法回答您的问题。我获取到的信息是StarShip产品的版本更新说明，其中不包含关于社区运营、代码质量、issue处理或PR审核情况的任何内容。

如果您需要了解StarShip产品的技术功能和使用方法，可以访问 https://opencsg.com/docs 获取更多信息，技术支持团队将会为您提供帮助。