Postgres DB service needs to stop, is there a more straightforward way to stop and start service from ssh into the app rather than killing a running Postgres service with PID

Questions / Help
1

Hi Team

I have configured fly PostgreSQL with wal-g(also configured barman) for PITR backup and restore to S3.

Basebackup and WAL archive is working fine.

At the time of restore, the Postgres DB service needs to stop, is there a more straightforward way to stop and start service from ssh into the app rather than killing a running Postgres service with PID?

2

Figured out to start and stop Postgres server, but stolon processes are restarting server immediately

anyways, I was looking for this answer because I was trying different methods of backup and restore.

with stolon wal-g, I think process is simple