Database

Executing a SQL Query using PGAdmin
Install pgAdmin Starting in Spire 3.6.8 pgAdmin no longer is included with the Spire Server installer. If you wish to use pgAdmin to access the Spire ...
Tue, 1 Mar, 2022 at 5:19 PM
Postgres optimization for Spire 2.x
These are setting for a sever with a minimum of 16GB of RAM Make sure no one is using the system before making any changes. For pgAdmin 3 (Spire...
Tue, 21 May, 2024 at 12:43 PM
pgAdmin 4 Server Entry
You'll notice that pgAdmin 3 has been deprecated and replaced with pgAdmin 4, starting with Spire 3.2.  In some instances your PC may already have a val...
Tue, 7 Nov, 2023 at 1:26 PM
How to Restart the PostgreSQL and Spire API Services
Restarting the PostgreSQL and Spire API Services As part of basic troubleshooting steps assisting with the resolution errors connecting to a database, i...
Tue, 5 Dec, 2017 at 5:41 AM
Spire database connection lost while connected to server over VPN
If users are using Spire Desktop and are connected to Spire Server over a VPN and are noticing that after a period of inactivity that they are disconnect...
Wed, 27 Apr, 2022 at 9:04 AM
Spire Server Administration Restore error "returned non-zero exit status 1."
Command '[;C:\\Program Files\\Spire\\PostgreSQL\\10\\bin\\pg_restore.exe','--list', 'C:\\WINDOWS\\SERVIC~1\\LOCALS~1\\AppData\\Local\\Te...
Fri, 12 Apr, 2024 at 4:42 AM