Get started

Build your first Elestio Terraform project

This exemple shows the setup for a Terraform project containing a single PostgreSQL service, and shows off some useful commands to stand up (and destroy) your Elestio infrastructure.

Prepare the dependencies

Sign up for Elestio if you haven't already
Get your API token in the security settings page of your account
Download and install Terraform

You need a Terraform CLI version equal or higher than v0.14.0.
To ensure you're using the acceptable version of Terraform you may run the following command:
```
terraform -v
```
Your output should resemble:
```
Terraform v0.14.0 # any version >= v0.14.0 is OK
...
```

Configure your project and services

Terraform files are used to define the structure and configuration of your infrastructure. It is generally a good idea to keep these definitions in separate files rather than combining them all in one file.

This section will explain how to organize a basic Terraform project :

Create and move to an empty folder

Here is an overview of the files we will create together :

|- outputs.tf		# Defines the outputs you want terraform extract
|- postgres.tf		# Defines the PostgreSQL service
|- project.tf		# Defines the Elestio project that will contain the PostgreSQL service
|- provider.tf		# Defines the Elestio provider for Terraform
|- secret.tfvars	# Defines the sensitive variables values
|- variables.tf 	# Defines the variables required in other .tf files

Create a file provider.tf and declare the provider adding the following lines :

# provider.tf

terraform {
  required_providers {
    elestio = {
      source  = "elestio/elestio"
      version = "0.3.0" # check out the latest version available
    }
  }
}

# Configure the Elestio Provider
provider "elestio" {
  email     = var.elestio_email
  api_token = var.elestio_api_token
}

As you can see, the email and API token are assigned to variables.
You should never put sensitive information directly in .tf files.

Create a file variables.tf and declare variables adding the following lines :

# variables.tf

variable "elestio_email" {
  description = "Elestio Email"
  type        = string
}

variable "elestio_api_token" {
  description = "Elestio API Token"
  type        = string
  sensitive   = true
}

This file does not contain the values of these variables. We will have to declare them in another file.

Create a file secret.tfvars and fill it with your values :
```
# secret.tfvars

elestio_email      = "YOUR-EMAIL"
elestio_api_token  = "YOUR-API-TOKEN"
```
Do not commit with Git this file ! Sensitive information such as an API token should never be pushed.
For more information on how to securely authenticate, please read the authentication documentation.

Create a file project.tf and add the following lines :

# project.tf

# Create a Project
resource "elestio_project" "pg_project" {
  name             = "PostgreSQL Project"
  description      = "Contains a postgres database"
  technical_emails = var.elestio_email
}

To contain our PostgreSQL service, we will have to create a new project on Elestio.
Instead of using the web interface, we can also declare it via terraform.

Create a file postgres.tf and add the following lines :

# postgres.tf

# Create a PostgreSQL Service
resource "elestio_postgresql" "pg_service" {
  project_id    = elestio_project.pg_project.id
  server_name   = "pg-service"
  server_type   = "SMALL-1C-2G"
  provider_name = "hetzner"
  datacenter    = "fsn1"
  support_level = "level1"
  admin_email   = var.elestio_email
}

Terraform takes care of managing the dependencies and creating the different resources in the right order. As you can see, project_id will be filled with the value of the Project Resource that will be created with the previously project.tf file.

Create a file outputs.tf and add the following lines :

# outputs.tf

output "pg_service_psql_command" {
	value       = elestio_postgresql.pg_service.database_admin.command
	description = "The PSQL command to connect to the database."
	sensitive   = true
}

Apply the Terraform configuration

Download and install the Elestio provider defined in the configuration :
```
terraform init
```
Ensure the configuration is syntactically valid and internally consistent:
```
terraform validate
```
Apply the configuration :
```
terraform apply -var-file="secret.tfvars"
```
Deployment time varies by service, provider, datacenter and server type.
Voila, you have created a Project and PostgreSQL Service using Terraform !
You can visit the Elestio web dashboard to see these ressources.

(Optional) Access to the database

Let's try to connect to the database to see if everything worked well

First, you need to install psql.

After that, run this command :

eval "$(terraform output -raw pg_service)pg_service_psql_command)"

Note: The command to leave psql terminal is \q

Clean up

Run the following command to destroy all the resources you created:

terraform destroy -var-file="secret.tfvars"

This command destroys all the resources specified in your Terraform state. terraform destroy doesn't destroy resources running elsewhere that aren't managed by the current Terraform project.

Now you've created and destroyed an entire Elestio deployment!

Visit the Elestio Dashboard to verify the resources have been destroyed to avoid unexpected charges.