pureftpd-pgsql.conf

# https://github.com/jedisct1/pure-ftpd/blob/master/pureftpd-pgsql.conf

PGSQLServer     db
PGSQLPort       5432
PGSQLUser       postgres
PGSQLPassword   asupersecretpassword
PGSQLDatabase   pureftpd

PGSQLCrypt      crypt

PGSQLGetPW      SELECT "Password" FROM users WHERE "User"='\L'
PGSQLGetUID     SELECT "Uid" FROM users WHERE "User"='\L'
# PGSQLDefaultUID 1000
PGSQLGetGID     SELECT "Gid" FROM users WHERE "User"='\L'
# PGSQLDefaultGID 1000
PGSQLGetDir     SELECT "Dir" FROM users WHERE "User"='\L'

# PGSQLGetQTAFS  SELECT "QuotaFiles" FROM users WHERE "User"='\L'
# PGSQLGetQTASZ  SELECT "QuotaSize" FROM users WHERE "User"='\L'
# PGSQLGetRatioUL SELECT "ULRatio" FROM users WHERE "User"='\L'
# PGSQLGetRatioDL SELECT "DLRatio" FROM users WHERE "User"='\L'
# PGSQLGetBandwidthUL SELECT "ULBandwidth" FROM users WHERE "User"='\L'
# PGSQLGetBandwidthDL SELECT "DLBandwidth" FROM users WHERE "User"='\L'