Having trouble? Here are solutions to common issues you might encounter.

Connection Issues

"Connection refused" Error

This usually means the database server isn't running or isn't accepting connections on the specified port.

Solutions:

1. Verify your database server is running
2. Check the port number is correct
3. Ensure your firewall allows connections on that port

# Check if PostgreSQL is running (macOS)
brew services list | grep postgresql

# Start PostgreSQL if needed
brew services start postgresql

"Authentication failed" Error

Your username or password is incorrect, or the user doesn't have permission to access the database.

Solutions:

1. Double-check your credentials
2. Verify the user has access to the specified database
3. Check if the authentication method requires SSL

SSL Connection Required

Some databases require SSL connections. Enable SSL in your connection settings:

postgresql://user:pass@host:5432/db?sslmode=require

Performance Issues

Queries Running Slowly

If queries are taking too long:

1. Check your query - Are you selecting more data than needed?
2. Add LIMIT - Use LIMIT to restrict results during development
3. Check indexes - Ensure your tables have appropriate indexes

-- Instead of this
SELECT * FROM large_table;

-- Do this
SELECT * FROM large_table LIMIT 100;

Application Feels Sluggish

Try these steps:

1. Restart DB Pro
2. Clear the query cache (Settings > Clear Cache)
3. Check if you have too many open connections

Reset DB Pro

If you need to start fresh:

macOS

# Remove preferences
rm -rf ~/Library/Preferences/com.dbpro.app.plist

# Remove application support data
rm -rf ~/Library/Application\ Support/DB\ Pro

Windows

# Remove app data
Remove-Item -Recurse "$env:APPDATA\DB Pro"

Getting More Help

If you're still stuck:

• Join our Discord community for support
• Sign in to your Dashboard to contact support