<postgresql+psycopg://prefect:shan123@localhost:5432/prefect>

PREFECT_SERVER_API_HOST=127.0.0.1
   PREFECT_SERVER_API_PORT=4200

PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>

bash
   # Add these to your server.env
   PREFECT_API_ENABLE_HTTP2=true
   PREFECT_SERVER_API_HOST_PORT=4200

nginx
   location /api/ {
       proxy_pass <http://127.0.0.1:4200/api/;>
       proxy_set_header Host $host;
       proxy_set_header X-Real-IP $remote_addr;
       proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
       proxy_set_header X-Forwarded-Proto $scheme;
   }

bash
   sudo systemctl restart prefect-server

bash
   sudo journalctl -u prefect-server -f

command_timeout

bash
   cat ~/.prefect/profiles.toml
   cat /etc/prefect/config.toml

bash
   sudo tee /etc/prefect/server.env << 'EOF'
   PREFECT_SERVER_API_HOST=127.0.0.1
   PREFECT_SERVER_API_PORT=4200
   PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>
   PREFECT_SERVER_DATABASE_CONNECTION_URL=<postgresql+psycopg://prefect:shan123@localhost:5432/prefect>
   # Add these timeout-related settings instead of command_timeout
   PREFECT_API_DATABASE_TIMEOUT=30
   PREFECT_API_REQUEST_TIMEOUT=30
   EOF

bash
   # Check for any existing connect args
   env | grep PREFECT_SERVER_DATABASE_SQLALCHEMY

bash
   # Add these if you need specific timeout controls
   PREFECT_API_DATABASE_TIMEOUT=30  # General database timeout in seconds
   PREFECT_API_REQUEST_TIMEOUT=30   # API request timeout in seconds

bash
   sudo systemctl restart prefect-server

bash
   sudo journalctl -u prefect-server -f

bash
# Test PostgreSQL connection
psql -U prefect -h localhost -d prefect -c "SELECT version();"

bash
   sudo systemctl cat prefect-server

bash
   prefect config view

bash
sudo tee /etc/prefect/server.env << 'EOF'
PREFECT_SERVER_API_HOST=127.0.0.1
PREFECT_SERVER_API_PORT=4200
PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>
PREFECT_SERVER_DATABASE_CONNECTION_URL=<postgresql+psycopg://prefect:shan123@localhost:5432/prefect>

# Explicitly clear any connect args
PREFECT_SERVER_DATABASE_SQLALCHEMY_CONNECT_ARGS={}

# Set standard timeouts
PREFECT_API_DATABASE_TIMEOUT=30
EOF

bash
sudo systemctl cat prefect-server.service

bash
sudo tee /etc/systemd/system/prefect-server.service << 'EOF'
[Unit]
Description=Prefect Server
After=network.target postgresql.service

[Service]
Type=simple
User=prefect
Group=prefect
EnvironmentFile=/etc/prefect/server.env
ExecStart=/opt/.venv/bin/prefect server start
Restart=always
RestartSec=1
StandardOutput=journal
StandardError=journal

# Ensure clean environment
Environment=PYTHONUNBUFFERED=1
Environment=PREFECT_SERVER_DATABASE_SQLALCHEMY_CONNECT_ARGS={}

[Install]
WantedBy=multi-user.target
EOF

bash
sudo systemctl daemon-reload
sudo systemctl restart prefect-server

bash
sudo -u prefect bash -c '
export PREFECT_SERVER_API_HOST=127.0.0.1
export PREFECT_SERVER_API_PORT=4200
export PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>
export PREFECT_SERVER_DATABASE_CONNECTION_URL="<postgresql+psycopg://prefect:shan123@localhost:5432/prefect>"
export PREFECT_SERVER_DATABASE_SQLALCHEMY_CONNECT_ARGS="{}"
/opt/.venv/bin/prefect server start
'

bash
sudo -u prefect ls -la ~prefect/.prefect/

command_timeout

env | grep PREFECT

command_timeout

bash
sudo tee /etc/prefect/server.env << 'EOF'
# Basic server settings
PREFECT_SERVER_API_HOST=127.0.0.1
PREFECT_SERVER_API_PORT=4200
PREFECT_UI_API_URL=https://prefect.happyraisins.com/api

# Database connection with minimal settings
PREFECT_SERVER_DATABASE_CONNECTION_URL=postgresql+psycopg://prefect:shan123@localhost:5432/prefect

# SQLAlchemy pool settings
PREFECT_SERVER_DATABASE_SQLALCHEMY_POOL_SIZE=5
PREFECT_SERVER_DATABASE_SQLALCHEMY_POOL_TIMEOUT=30
PREFECT_SERVER_DATABASE_SQLALCHEMY_POOL_RECYCLE=3600
PREFECT_SERVER_DATABASE_SQLALCHEMY_MAX_OVERFLOW=10

# API timeout settings
PREFECT_API_DATABASE_TIMEOUT=30

# Explicitly set empty connect_args to override any defaults
PREFECT_SERVER_DATABASE_SQLALCHEMY_CONNECT_ARGS={}
EOF

bash
sudo find / -name "prefect.yaml" 2>/dev/null
sudo find / -name "profiles.toml" 2>/dev/null

bash
sudo tee /etc/systemd/system/prefect-server.service << 'EOF'
[Unit]
Description=Prefect Server
After=network.target postgresql.service

[Service]
Type=simple
User=prefect
Group=prefect
EnvironmentFile=/etc/prefect/server.env
ExecStart=/opt/.venv/bin/prefect server start
Restart=always
RestartSec=1
StandardOutput=journal
StandardError=journal

# Clear any potential inherited environment variables
Environment=PYTHONUNBUFFERED=1
Environment=PREFECT_HOME=/home/prefect/.prefect
Environment=XDG_CONFIG_HOME=/home/prefect/.config

# Ensure clean startup
ExecStartPre=/bin/rm -f /home/prefect/.prefect/profiles.toml

[Install]
WantedBy=multi-user.target
EOF

bash
sudo systemctl daemon-reload
sudo systemctl restart prefect-server

python
from sqlalchemy import create_engine
from sqlalchemy.engine import URL
url = URL.create(
    "postgresql+psycopg",
    username="prefect",
    password="shan123",
    host="localhost",
    database="prefect"
)
engine = create_engine(url)
# This should show us what default args SQLAlchemy is using
print(engine.url.query)

sudo find / -name "profiles.toml" 2>/dev/null

command_timeout

postgresql+asyncpg

postgresql+psycopg

bash
prefect config set PREFECT_API_DATABASE_CONNECTION_URL="<postgresql+asyncpg://postgres:yourpassword@localhost:5432/prefect>"

postgresql+asyncpg

asyncpg

bash
prefect config set PREFECT_API_URL="<https://prefect.happyraisins.com/api>"

bash
prefect cloud ping

<https://prefect.happyraisins.com>

bash
prefect server ping

bash
prefect config view

<https://prefect.happyraisins.com/api>

bash
prefect work-pool create my-pool --type process

bash
prefect worker start --pool my-pool

bash
sudo tee /etc/systemd/system/prefect-worker.service << 'EOF'
[Unit]
Description=Prefect Worker
After=network.target

[Service]
Type=simple
User=prefect
Group=prefect
Environment=PREFECT_API_URL=<https://prefect.happyraisins.com/api>
ExecStart=/opt/.venv/bin/prefect worker start --pool my-pool
Restart=always
RestartSec=1

[Install]
WantedBy=multi-user.target
EOF

bash
sudo systemctl daemon-reload
sudo systemctl start prefect-worker
sudo systemctl status prefect-worker

bash
prefect version

python
from prefect import flow

@flow(name="test_connection")
def test_flow():
    print("Successfully connected to Prefect server!")
    return "Success"

if __name__ == "__main__":
    test_flow()

bash
prefect config set PREFECT_API_URL="<https://prefect.happyraisins.com/api>"

python --version
  pip install -U prefect
  prefect version

export PREFECT_API_URL="<https://prefect.happyraisins.com/api>"
  # If using Prefect Cloud, also set:
  # export PREFECT_API_KEY="your-api-key"

prefect config view

prefect work-pool create --type process my-ec2-pool

prefect work-pool ls

from prefect import flow, get_run_logger

  @flow
  def hello(name: str = "world"):
      log = get_run_logger()
      <http://log.info|log.info>(f"Hello, {name}!")

  if __name__ == "__main__":
      hello()

# repo: <https://github.com/your-org/your-repo>
  # entrypoint format: "path/to/file.py:flow_function_name"

  from your_module_or_script import hello

  hello.from_source(
      source="<https://github.com/your-org/your-repo>",
      entrypoint="flows/hello.py:hello",
  ).deploy(
      name="hello-prod",
      work_pool_name="my-ec2-pool",
      parameters={"name": "Raisin Farmer"},
      description="Hello flow deployment on EC2",
      tags=["prod", "ec2"],
  )

prefect deploy

prefect deploy \
    --name hello-prod \
    --pool my-ec2-pool \
    --entrypoint flows/hello.py:hello

prefect worker start --pool my-ec2-pool

sudo tee /etc/systemd/system/prefect-worker.service >/dev/null <<'EOF'
  [Unit]
  Description=Prefect Worker
  After=network-online.target
  Wants=network-online.target

  [Service]
  Type=simple
  Environment=PREFECT_API_URL=<https://prefect.happyraisins.com/api>
  # Environment=PREFECT_API_KEY=your-api-key   # if applicable
  ExecStart=/usr/bin/env prefect worker start --pool my-ec2-pool
  WorkingDirectory=/home/ubuntu
  Restart=always
  RestartSec=5
  User=ubuntu

  [Install]
  WantedBy=multi-user.target
  EOF

  sudo systemctl daemon-reload
  sudo systemctl enable --now prefect-worker
  sudo systemctl status prefect-worker

prefect deployment run "hello/hello-prod" --params '{"name":"Tester"}'

journalctl -u prefect-worker -f

prefect deploy

export PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>

export PREFECT_API_URL=<https://prefect.happyraisins.com/api>

prefect server start --host 0.0.0.0 --port 4200

[Unit]
Description=Prefect 3 Server
After=network.target

[Service]
User=prefect
Environment="PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>"
ExecStart=/usr/bin/env prefect server start --host 0.0.0.0 --port 4200
Restart=on-failure
RestartSec=5
WorkingDirectory=/home/prefect

[Install]
WantedBy=multi-user.target

sudo systemctl daemon-reload
sudo systemctl enable --now prefect-server

# /etc/nginx/sites-available/prefect
map $http_upgrade $connection_upgrade {
  default upgrade;
  ''      close;
}

server {
  listen 80;
  server_name <http://prefect.happyraisins.com|prefect.happyraisins.com>;
  return 301 https://$host$request_uri;
}

server {
  listen 443 ssl http2;
  server_name <http://prefect.happyraisins.com|prefect.happyraisins.com>;

  # Certbot-managed SSL files (paths may vary)
  ssl_certificate     /etc/letsencrypt/live/prefect.happyraisins.com/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/prefect.happyraisins.com/privkey.pem;
  include /etc/letsencrypt/options-ssl-nginx.conf;
  ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem;

  client_max_body_size 50m;

  location / {
    proxy_pass <http://127.0.0.1:4200;>
    proxy_http_version 1.1;
    proxy_set_header Host $host;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header X-Forwarded-Proto $scheme;

    # Websocket/SSE support
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection $connection_upgrade;
    proxy_read_timeout 3600s;
    proxy_send_timeout 3600s;
    proxy_buffering off;
  }
}

sudo ln -s /etc/nginx/sites-available/prefect /etc/nginx/sites-enabled/prefect
sudo nginx -t && sudo systemctl reload nginx

prefect work-pool create my-pool -t process

export PREFECT_API_URL=<https://prefect.happyraisins.com/api>
prefect worker start -p my-pool

from prefect import flow

@flow
def my_flow():
    print("Hello, Raisins")

if __name__ == "__main__":
    (
        flow
        .from_source(
            source="<https://github.com/your-org/your-repo>",
            entrypoint="path/to/flow_file.py:my_flow",
        )
        .deploy(
            name="prod",
            work_pool_name="my-pool",
            parameters={},
        )
    )

prefect deployment run 'my_flow/prod'

prefect deploy

curl -I <https://prefect.happyraisins.com/api/health>

curl -I $PREFECT_API_URL/health

PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>

PREFECT_API_URL

proxy_buffering off

proxy_read_timeout

export PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>

export PREFECT_API_URL=<https://prefect.happyraisins.com/api>

prefect server start --host 0.0.0.0 --port 4200

[Unit]
Description=Prefect 3 Server
After=network.target

[Service]
User=prefect
Environment="PREFECT_UI_API_URL=<https://prefect.happyraisins.com/api>"
ExecStart=/usr/bin/env prefect server start --host 0.0.0.0 --port 4200
Restart=on-failure
RestartSec=5
WorkingDirectory=/home/prefect

[Install]
WantedBy=multi-user.target

sudo systemctl daemon-reload
sudo systemctl enable --now prefect-server

# /etc/nginx/sites-available/prefect
map $http_upgrade $connection_upgrade {
  default upgrade;
  ''      close;
}

server {
  listen 80;
  server_name <http://prefect.happyraisins.com|prefect.happyraisins.com>;
  return 301 https://$host$request_uri;
}

server {
  listen 443 ssl http2;
  server_name <http://prefect.happyraisins.com|prefect.happyraisins.com>;

  ssl_certificate     /etc/letsencrypt/live/prefect.happyraisins.com/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/prefect.happyraisins.com/privkey.pem;
  include /etc/letsencrypt/options-ssl-nginx.conf;
  ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem;

  client_max_body_size 50m;

  location / {
    proxy_pass <http://127.0.0.1:4200;>
    proxy_http_version 1.1;
    proxy_set_header Host $host;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header X-Forwarded-Proto $scheme;

    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection $connection_upgrade;

    proxy_read_timeout 3600s;
    proxy_send_timeout 3600s;
    proxy_buffering off;
  }
}

sudo ln -s /etc/nginx/sites-available/prefect /etc/nginx/sites-enabled/prefect
sudo nginx -t && sudo systemctl reload nginx

prefect work-pool create my-pool -t process

export PREFECT_API_URL=<https://prefect.happyraisins.com/api>
prefect worker start -p my-pool

from prefect import flow

@flow
def my_flow():
    print("Hello, Raisins")

if __name__ == "__main__":
    (
        flow
        .from_source(
            source="<https://github.com/your-org/your-repo>",
            entrypoint="path/to/flow_file.py:my_flow",
        )
        .deploy(
            name="prod",
            work_pool_name="my-pool",
            parameters={},
        )
    )

prefect deployment run 'my_flow/prod'

curl -I <https://prefect.happyraisins.com/api/health>

curl -I $PREFECT_API_URL/health

PREFECT_UI_API_URL

PREFECT_API_URL

proxy_buffering off