PostgreSQL
Using PostgreSQL in Kythia Workspace.
Kythia Workspace provides an automated, seamlessly integrated PostgreSQL environment.
Installing
Go to Databases -> PostgreSQL
Select a version from the dropdown menu and click Install
Kythia will download the official PostgreSQL binaries directly to your local environment.
Default Connection
By default, PostgreSQL is configured to run on your localhost without conflict.
| Field | Value |
|---|---|
| Host | 127.0.0.1 |
| Port | 5432 |
| Username | postgres |
| Password | (empty) |
Configuration
Kythia manages basic configurations for you automatically. If you need to make advanced changes, the configuration files for PostgreSQL are located at:
C:\kythia\bin\postgresql\{version}\conf\Data files (where your actual database records live) are stored safely at:
C:\kythia\data\postgresql\Logs
Log files are extremely useful for debugging failed queries or startup issues. They are located at:
C:\kythia\bin\postgresql\{version}\logs\You can also view the logs in real-time directly via the Logs button in the Kythia UI.