sql.conf

<Global>
  <IfModule mod_sql.c>
    SQLBackend      postgres
    SQLEngine       on

    <IfDefine VERBOSE=ON>
      SQLLogFile      /var/log/proftpd/sql.log
    </IfDefine>

    SQLAuthenticate users userset groups groupset
    SQLAuthTypes    SHA256 SHA512
    SQLConnectInfo  %{env:FTP_DB_NAME}@%{env:FTP_DB_HOST} %{env:FTP_DB_USER} %{env:FTP_DB_PASS}
    SQLUserInfo     ftp.users userid passwd uid gid homedir shell
    SQLGroupInfo    ftp.groups groupname gid members
    SQLDefaultUID   65533
    SQLDefaultGID   65533

    # Update the ftp.users.last_accessed column on successful login in the userdb
    SQLNamedQuery last_accessed UPDATE "last_accessed = NOW() WHERE userid='%u'" ftp.users
    SQLLog PASS last_accessed

    # Add a row to the ftp.login_history table on successful login in the logdb
    SQLNamedQuery log_session FREEFORM "INSERT INTO ftp.login_history (userid, client_ip, server_ip, protocol, login_date) VALUES ('%u', '%a', '%V', '%{protocol}', NOW())"
    SQLLog PASS log_session IGNORE_ERRORS

  </IfModule>

  <IfModule mod_sql_passwd.c>
    SQLPasswordEngine on
    SQLPasswordEncoding base64
    SQLPasswordSaltFile /etc/proftpd/.salt Append
  </IfModule>
</Global>