PostgreSQL

Kythia Workspace provides an automated, seamlessly integrated PostgreSQL environment.

Installing

1. Go to Databases -> PostgreSQL
2. Select a version from the dropdown menu and click Install
3. 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.