The Pg.dll mentioned in the error message can't load because it needs another dll (probably the PostgreSQL dll), and it can't find that dll.
The solution could be as simple as adding the location of that dll to the path.
Often, such error messages are accompanied by a pop-up that tells you the name of the dll that can't be found. Did you get such a pop-up box ?