Postgres Clusters
Update Maintenance Window
Update a cluster’s weekly maintenance window. Give at least one of day, start_hour and duration_hours; omitted fields keep their current value. start_hour is in the cluster’s timezone, which is derived from its region and cannot be changed. Changes are accepted only while the cluster is ready and no maintenance is running.
PATCH
/
v1
/
postgres
/
{postgres_cluster_id}
/
maintenance_window
Update Maintenance Window
curl --request PATCH \
--url https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"day": "tuesday",
"duration_hours": 3,
"start_hour": 4
}
'import requests
url = "https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window"
payload = {
"day": "tuesday",
"duration_hours": 3,
"start_hour": 4
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({day: 'tuesday', duration_hours: 3, start_hour: 4})
};
fetch('https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'day' => 'tuesday',
'duration_hours' => 3,
'start_hour' => 4
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window"
payload := strings.NewReader("{\n \"day\": \"tuesday\",\n \"duration_hours\": 3,\n \"start_hour\": 4\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"day\": \"tuesday\",\n \"duration_hours\": 3,\n \"start_hour\": 4\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"day\": \"tuesday\",\n \"duration_hours\": 3,\n \"start_hour\": 4\n}"
response = http.request(request)
puts response.read_body{
"data": {
"day": "sunday",
"duration_hours": 3,
"start_hour": 1,
"timezone": "America/New_York"
}
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}Authorizations
Body
application/json
Maintenance window fields to change
⌘I
Update Maintenance Window
curl --request PATCH \
--url https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"day": "tuesday",
"duration_hours": 3,
"start_hour": 4
}
'import requests
url = "https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window"
payload = {
"day": "tuesday",
"duration_hours": 3,
"start_hour": 4
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({day: 'tuesday', duration_hours: 3, start_hour: 4})
};
fetch('https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'day' => 'tuesday',
'duration_hours' => 3,
'start_hour' => 4
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window"
payload := strings.NewReader("{\n \"day\": \"tuesday\",\n \"duration_hours\": 3,\n \"start_hour\": 4\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"day\": \"tuesday\",\n \"duration_hours\": 3,\n \"start_hour\": 4\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.machines.dev/v1/postgres/{postgres_cluster_id}/maintenance_window")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"day\": \"tuesday\",\n \"duration_hours\": 3,\n \"start_hour\": 4\n}"
response = http.request(request)
puts response.read_body{
"data": {
"day": "sunday",
"duration_hours": 3,
"start_hour": 1,
"timezone": "America/New_York"
}
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}{
"error": "<string>",
"status": "sessions_not_terminated"
}