Skip to main content

​
[OPTIONAL] Install PostgreSQL locally

if needed, you can install PostgreSQL locally here
1

Installing on MacOS

To install on MacOS, you can use Brew
brew install postgresql@14
2

Start PostgreSQL

Then to start MySQL, use
brew services restart postgresql@14
NOTE: If you are connecting to a remote Postgres instance that is already running, you shouldn’t need to uninstall it locally. 
If you have installed locally using defaults, you will have Postgres running with these configuration properties:
	Host: localhost
	Port: 5432
	User: postgres
	Database: postgres
	Password:  <empty, no password>

​
Add A Connection To PostgreSQL

Tell Eve you want to connect to Postgres, and provide your host, port, user, and password Copy the prompt below to follow along 
Eve, add a connection to Postgres called “postgres_demo”, host: localhost, port: 5432, user: postgres, and the password is “” (no password needed), database: postgres and allow all bots to access it.
Clicking “Database Connections” in the Genesis GUI will show you that it has been added

​
[OPTIONAL] Create Sample Data

If you already have data in Postgres, you can proceed to the next section to harvest and analyze your data.  If your Postgres is empty, you can have Eve create some sample data for you Copy the prompt below to follow along 
Create in the postgres_demo database connection a new schema called GAMES, with tables VIDEO_GAMES and BOARD_GAMES. Add several (7 ish) columns to each database to track data about the respective types games. Then insert 5 sample rows in each table.
NOTE: It’s ok if Eve has to retry some steps or if she encounters issues, she should be able to resolve them on her own.
Once your data is created, you can ask Eve to show you some of it. Copy the prompt below to follow along 
Show me 3 rows from each of these tables
NOTE: Your schema and data will vary based on what Eve decides to build for you.

​
AddingPostgreSQL To The Harvest

Tell Eve to add your PostgreSQL connection and the databases you want to use to the harvest. Example: if you just created the databases above Copy the prompt below to follow along 
Add the postgres_demo database connection's postgres database to the harvest.
After a few minutes, you should see the result on the Configuration / Harvest Summary screen
[IMAGE TO BE ADDED]
You can ask Eve questions about your data in PostgreSQL once the database connection appears on the Harvester Status page. Copy the prompt below to follow along 
Search for data on board games
Once data has been found Copy the prompt below to follow along 
How many total games are in the data?

​
Removing The Connection

 You also have the option to remove the connection.
NOTE: This will also remove related harvest information
Copy the prompt below to follow along 
remove the connection to the postgres_demo database connection