← Back to Home
Support & Help
Welcome to psq support! This page provides guidance on using the psq iOS app to monitor
your PostgreSQL databases. If you can't find what you're looking for, use the contact
form below to reach out directly.
Getting Started
psq is a powerful PostgreSQL monitoring tool for iOS that allows you to keep track of your
databases on the go. Once you download the app from the App Store, getting started is simple:
- Download the app from the App Store (coming soon)
- Launch psq on your iOS device
- Add your first database connection using the "+" button
- Start monitoring your PostgreSQL databases instantly
Connecting to Databases
psq makes it easy to connect to your PostgreSQL databases. Here's what you need to know:
Adding a Database Connection
To add a new database connection:
- Tap the "+" button in the connections list
- Enter your connection details (host, port, database name, username, password)
- Optionally give your connection a friendly name
- Tap "Save" to store the connection
Connection String Format
You can also use a PostgreSQL connection string in the format:
postgresql://username:password@host:port/database
Importing from pg_service.conf
psq for iOS supports importing database connections from your Mac's pg_service.conf file.
This feature allows you to quickly set up connections that you've already configured on your computer.
Requirements:
- A
.pg_service.conf file on your Mac (typically located at ~/.pg_service.conf or set via PGSERVICEFILE environment variable)
- Handoff enabled between your Mac and iPhone to enable copy/paste across devices
To use this feature:
- Copy the contents of your
pg_service.conf file on your Mac
- Paste it into the psq iOS app's import field (Universal Clipboard via Handoff makes this seamless)
- psq will parse the file and import all configured service connections
Learn more about the pg_service.conf file format in the
PostgreSQL documentation.
SSL/TLS Configuration
For secure connections, psq supports SSL/TLS. You can enable SSL in the connection settings.
This is recommended for production databases and any databases accessible over the internet.
Testing Connections
Before saving, you can test your connection to ensure psq can reach your database.
If the connection fails, check your credentials, network settings, and firewall rules.
Managing Multiple Databases
psq supports multiple database connections. You can:
- Swipe to edit or delete connections
- Organize connections with custom names
- Quickly switch between databases
- Monitor multiple databases simultaneously
Running Queries
psq includes a powerful query editor for running SQL queries on your databases:
Query Editor Basics
- Tap on a database connection to open the query editor
- Type or paste your SQL query
- Tap "Run" to execute the query
- View results in a scrollable table format
Executing and Viewing Results
Query results are displayed in an easy-to-read table format. You can:
- Scroll horizontally to see all columns
- Tap on cells to view full content
- See row counts and execution time
- Export results for further analysis
Query History
psq automatically saves your query history so you can:
- Access previously run queries
- Re-run queries with a single tap
- Review query execution times
Saving Favorite Queries
For queries you run frequently, you can save them as favorites for quick access.
Monitoring Features
psq provides comprehensive monitoring capabilities:
Database Metrics Overview
View key metrics at a glance:
- Database size and growth trends
- Active connections count
- Query performance statistics
- Table and index sizes
Active Connections
Monitor all active connections to your database, including:
- Connected clients and their IP addresses
- Current queries being executed
- Connection duration
- Idle connections
Query Performance Tracking
Track slow queries and identify performance bottlenecks:
- View slowest queries
- See execution times and call counts
- Identify queries that need optimization
Database Size Information
Keep track of your database storage:
- Total database size
- Individual table sizes
- Index sizes and bloat
- Growth trends over time
Troubleshooting
Having issues? Here are solutions to common problems:
Connection Errors
If you can't connect to your database:
- Verify your connection details (host, port, username, password)
- Check that your database server is running
- Ensure your iOS device has network connectivity
- Verify that the database accepts connections from your IP address
Authentication Issues
If you're getting authentication errors:
- Double-check your username and password
- Ensure your database user has the necessary permissions
- Check if your database requires SSL/TLS connections
- Verify that password authentication is enabled on the server
Network and Firewall Problems
If connections are timing out:
- Check your network connection (WiFi or cellular)
- Verify firewall rules allow PostgreSQL connections (default port 5432)
- Ensure your database server's
pg_hba.conf allows remote connections
- Check if
postgresql.conf has listen_addresses properly configured
Performance Tips
For the best experience with psq:
- Use WiFi instead of cellular when running complex queries
- Limit result sets with
LIMIT clauses for large tables
- Close unused connections to free up resources
- Regularly update psq to get the latest performance improvements
Need More Help?
If you couldn't find the answer to your question above, please reach out using the contact
form below. We'll get back to you as soon as possible. You can also:
Contact Us
Fill out the form below and we'll respond to your inquiry as soon as possible.