Need Solution for below case.
I have configured ProFTPD with Postgres. when client uploads file from Winscp , at server side
- user get authenticated from PG table.
- File get written on disk.
- then same file name entry get insterted into PG.
Now at stage 3 if DB connection get lost, There is SFTP session roll back. and but no recovery at DB side when PG is up again by Proftpd.