I saw Excel supported using PostgreSQL as a data source. I'm used to using ODBC connections for Access so having direct Postgres support is exciting.
When connecting I entered the Server IP and database name, selected my table, and data was pulled in. No Username, no password. Do I have some gaping security hole on my database? Shouldn't there be some sort of authentication?
I have an ODBC DSN for that server configured on this workstation and has set up a workbook using that DSN just a few minutes previously (which oddly enough requires a username and password even though the credentials are in the DSN)but I don't think that should be relevant.