When you run into a problem with Postico, the most important step is to contact me! I can only fix bugs that I know about. I try to thoroughly test Postico's functionality, but with thousands of people downloading my app every month, there are always corner cases that I will miss.
You can contact me via email, or you can post bug reports to the public issue tracker on Github.
Describe what you did to trigger the bug
The more detail you can provide, the better. Postico has a lot of functionality, and some of the bug reports I receive are ambiguous. For example, when you say you clicked on the table, did you click in the sidebar or in the main view?
Include screenshots or screen recordings
Complicated bugs can be hard to describe with words, so it's often easier to just show a picture. You can capture parts of the screen with the shortcut Cmd-Shift-4, and you can use QuickTime Player to record a part of the screen.
Which versions of OS X and Postico are you using?
What server are you connecting to?
Are you connecting to a local or to a remote server? Are you hosting the server yourself, or is it a server from a cloud service provider? Is it a vanilla PostgreSQL server or a derivation like Amazon Redshift? What's the version of the server?
It's important to differentiate between crashes and hangs.
When an app crashes, OS X will terminate it and display an error message. A crash report will usually be generated. It's very important to include this file when reporting crashes; otherwise it can be very hard for me to determine what has happened.
You can find Crash Reports in the directory ~/Library/Logs/DiagnosticReports/. Please send crash reports as an attachment via email; don't just copy & paste the text in an email, it makes it harder to read. If there are multiple crash reports for Postico, send me all of them.
A hang is when the app stops responding. Usually the beachball cursor will appear after a few seconds, but not for all types of hangs. When reporting a hang, please send a process sample of Postico.
To create a process sample, open Activity Monitor, select Postico, click the info button in the toolbar, then click "Sample". After a few seconds a sample will appear. Save it, then email it to me. Make sure to sample Postico while it is actually hanging.