You are tasked with creating new source or target connections for cataloging in AWS Glue. Describe the process you would follow to set up a connection to an external PostgreSQL database, including the necessary configurations and security considerations.
