There's a script provided with the installer called dsn.sh that does it all for you, you'll need to provide it with the postgres password found in /etc/fusionpbx/config.conf
Unless you have a lot of domains, SQLITE is perfectly fine as long as it's on a RAM disk. It's perfectly fine on an SSD...