📅 技術調査 - Postiz

git clone https://github.com/gitroomhq/postiz-docker-compose
cd postiz-docker-compose

docker compose up -d

docker compose down && docker compose up -d

services:
  postiz:
    image: ghcr.io/gitroomhq/postiz-app:latest
    container_name: postiz
    restart: always
    environment:
      MAIN_URL: "https://postiz.your-server.com"
      FRONTEND_URL: "https://postiz.your-server.com"
      NEXT_PUBLIC_BACKEND_URL: "https://postiz.your-server.com/api"
      JWT_SECRET: "ランダムな文字列（インストールごとに変更）"
      DATABASE_URL: "postgresql://postiz-user:postiz-password@postiz-postgres:5432/postiz-db-local"
      REDIS_URL: "redis://postiz-redis:6379"
      BACKEND_INTERNAL_URL: "http://localhost:3000"
      IS_GENERAL: "true"
      DISABLE_REGISTRATION: "false"
      STORAGE_PROVIDER: "local"
      UPLOAD_DIRECTORY: "/uploads"
      NEXT_PUBLIC_UPLOAD_DIRECTORY: "/uploads"
    volumes:
      - postiz-config:/config/
      - postiz-uploads:/uploads/
    ports:
      - 5000:5000
    networks:
      - postiz-network
    depends_on:
      postiz-postgres:
        condition: service_healthy
      postiz-redis:
        condition: service_healthy

  postiz-postgres:
    image: postgres:17-alpine
    container_name: postiz-postgres
    restart: always
    environment:
      POSTGRES_PASSWORD: postiz-password
      POSTGRES_USER: postiz-user
      POSTGRES_DB: postiz-db-local
    volumes:
      - postgres-volume:/var/lib/postgresql/data
    networks:
      - postiz-network
    healthcheck:
      test: pg_isready -U postiz-user -d postiz-db-local
      interval: 10s
      timeout: 3s
      retries: 3

  postiz-redis:
    image: redis:7.2
    container_name: postiz-redis
    restart: always
    healthcheck:
      test: redis-cli ping
      interval: 10s
      timeout: 3s
      retries: 3
    volumes:
      - postiz-redis-data:/data
    networks:
      - postiz-network

volumes:
  postgres-volume:
  postiz-redis-data:
  postiz-config:
  postiz-uploads:

networks:
  postiz-network:

EMAIL_PROVIDER="resend|nodemailer"
RESEND_API_KEY="re_xxxxxxxxxxxx"       # Resend 利用時
EMAIL_HOST="smtp.gmail.com"            # Nodemailer 利用時
EMAIL_PORT="465"
EMAIL_SECURE="true"
EMAIL_USER="user@example.com"
EMAIL_PASS="password"

CLOUDFLARE_ACCOUNT_ID="your-account-id"
CLOUDFLARE_ACCESS_KEY="your-access-key"
CLOUDFLARE_SECRET_ACCESS_KEY="your-secret-key"
CLOUDFLARE_BUCKETNAME="postiz"
CLOUDFLARE_BUCKET_URL="https://account-id.r2.cloudflarestorage.com/"
CLOUDFLARE_REGION="auto"

git clone https://github.com/gitroomhq/postiz-app.git
cd postiz-app

docker run -e POSTGRES_USER=root -e POSTGRES_PASSWORD=your_password \
  --name postgres -p 5432:5432 -d postgres

docker run --name redis -p 6379:6379 -d redis

DATABASE_URL="postgresql://postiz-user:postiz-password@localhost:5432/postiz-db-local"
REDIS_URL="redis://localhost:6379"
JWT_SECRET="ランダムな長い文字列"
FRONTEND_URL="http://localhost:4200"
NEXT_PUBLIC_BACKEND_URL="http://localhost:3000"
BACKEND_INTERNAL_URL="http://localhost:3000"
IS_GENERAL="true"
NX_ADD_PLUGINS=false

pnpm install

pnpm run prisma-db-push

pnpm run dev

pnpm install
pnpm run prisma-db-push
pnpm run pm2    # PM2 によるプロセス管理

docker build -t postiz-app .

X_API_KEY="Twitter API key（OAuth1 用）"
X_API_SECRET="Twitter API secret（OAuth1 用）"

LINKEDIN_CLIENT_ID="LinkedIn Client ID"
LINKEDIN_CLIENT_SECRET="LinkedIn Client Secret"

OPENAI_API_KEY="OpenAI API キー"

OPENAI_API_KEY="sk-xxxxxxxxxxxx"
FAL_KEY="your-fal-api-key"        # FAL AI 画像・動画生成（任意）

if (user?.tier?.ai) {
  return <CopilotTextarea
    autosuggestionsConfig={{
      textareaPurpose: "Assist me in writing social media posts"
    }}
  />;
} else {
  return <MDEditor />;
}

Authorization: your-api-key

{
  "url": "https://your-n8n.example.com/webhook/postiz",
  "event": "post.published",
  "secret": "webhook-signing-secret"
}

{
  "mcpServers": {
    "postiz": {
      "command": "npx",
      "args": ["@postiz/mcp"],
      "env": {
        "POSTIZ_API_KEY": "your-api-key"
      }
    }
  }
}

{
  "type": "schedule",
  "date": "2026-02-20T10:00:00.000Z",
  "posts": [
    {
      "integration": {
        "id": "your-channel-id"
      },
      "value": [
        {
          "content": "投稿本文テキスト"
        }
      ]
    }
  ]
}

# CLI のインストール
npm install -g postiz

# API キーの設定
export POSTIZ_API_KEY=your-api-key

# セルフホスト環境の場合
export POSTIZ_API_URL=https://your-postiz-server.com

npm install @postiz/node

import Postiz from '@postiz/node';

const postiz = new Postiz('your-api-key', 'https://your-instance.example.com');

// 投稿作成
await postiz.post({ content: "投稿テキスト", platforms: ["twitter"] });

// 投稿一覧
const posts = await postiz.postList({ limit: 10 });

// メディアアップロード
await postiz.upload(fileBuffer, "png");

// 連携アカウント一覧
const integrations = await postiz.integrations();

# プラットフォーム別の分析データ
curl -H "Authorization: your-api-key" \
  https://your-instance.com/public/v1/analytics/platform/x

# 1. 現在のバージョンを確認
docker inspect ghcr.io/gitroomhq/postiz-app:latest | grep -i version

# 2. バックアップを取得（後述の手順を参照）

# 3. 最新イメージを取得
docker compose pull

# 4. コンテナを再作成
docker compose down
docker compose up -d

# 5. ログで起動状態を確認
docker compose logs -f postiz

# docker-compose.yml
services:
  postiz:
    image: ghcr.io/gitroomhq/postiz-app:v2.12.0

# SQL ダンプ
docker exec postiz-postgres pg_dump \
  -U postiz-user postiz-db-local \
  > backup_$(date +%Y%m%d_%H%M%S).sql

# 圧縮ダンプ
docker exec postiz-postgres pg_dump \
  -U postiz-user postiz-db-local \
  | gzip -9 > backup_$(date +%Y%m%d_%H%M%S).sql.gz

# Docker ボリュームをアーカイブ
docker run --rm \
  -v postiz-uploads:/data \
  -v $(pwd):/backup \
  alpine tar czf /backup/uploads_$(date +%Y%m%d).tar.gz /data

# コンテナを停止してからリストア
docker compose stop postiz

# SQL ダンプからリストア
docker exec -i postiz-postgres psql \
  -U postiz-user postiz-db-local \
  < backup_20260219.sql

docker compose start postiz

# /etc/cron.d/postiz-backup
0 3 * * * root docker exec postiz-postgres pg_dump \
  -U postiz-user postiz-db-local \
  | gzip > /var/backups/postiz/db_$(date +\%Y\%m\%d).sql.gz

# 全サービスのログ
docker compose logs -f

# 特定サービス（タイムスタンプ付き）
docker compose logs -f -t postiz

# 直近 100 行
docker compose logs --tail=100 postiz

docker compose ps
# STATUS 列で healthy / unhealthy を確認

# .env に追加
SENTRY_DSN=https://xxx@sentry.io/xxx

# 安全なランダム文字列を生成
openssl rand -hex 32

# 最初のユーザー登録後にサインアップを無効化
DISABLE_REGISTRATION=true

server {
    listen 443 ssl http2;
    server_name postiz.example.com;

    ssl_certificate     /etc/letsencrypt/live/postiz.example.com/fullchain.pem;
    ssl_certificate_key /etc/letsencrypt/live/postiz.example.com/privkey.pem;
    ssl_protocols       TLSv1.2 TLSv1.3;

    add_header Strict-Transport-Security "max-age=31536000; includeSubDomains; preload";
    add_header X-Frame-Options DENY;
    add_header X-Content-Type-Options nosniff;
    add_header Referrer-Policy no-referrer-when-downgrade;

    server_tokens off;

    location / {
        proxy_pass http://localhost:5000;
        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;
        proxy_set_header Upgrade    $http_upgrade;
        proxy_set_header Connection "upgrade";
    }
}

# フロントエンドのみ
POSTIZ_APPS="frontend"

# バックエンドのみ
POSTIZ_APPS="backend"

# ワーカーとクーロンのみ
POSTIZ_APPS="worker cron"

services:
  postiz:
    image: ghcr.io/gitroomhq/postiz-app:latest
    container_name: postiz
    restart: always
    env_file:
      - /etc/postiz/postiz.env   # 機密情報は外部ファイルで管理
    volumes:
      - postiz-config:/config/
      - postiz-uploads:/uploads/
    ports:
      - "127.0.0.1:5000:5000"   # ローカルのみ公開（Nginx 経由で外部に出す）
    networks:
      - postiz-network
    depends_on:
      postiz-postgres:
        condition: service_healthy
      postiz-redis:
        condition: service_healthy

gzip on;
gzip_comp_level 6;
gzip_types text/plain text/css application/json application/javascript;

# DATABASE_URL にプール設定を追加
DATABASE_URL="postgresql://user:pass@host:5432/db?connection_limit=20&pool_timeout=10"

services:
  postiz-redis:
    image: redis:7.2
    command: redis-server --appendonly yes
    volumes:
      - postiz-redis-data:/data

STORAGE_PROVIDER=cloudflare
CLOUDFLARE_ACCOUNT_ID=xxx
CLOUDFLARE_ACCESS_KEY=xxx
CLOUDFLARE_SECRET_ACCESS_KEY=xxx
CLOUDFLARE_BUCKETNAME=postiz-uploads
CLOUDFLARE_BUCKET_URL=https://pub-xxx.r2.dev

# 本番環境
https://postiz.example.com/integrations/social/x

# ローカル（Docker / X は開発時に localhost を許可）
http://localhost:5000/integrations/social/x

# 環境変数を変更した場合は必ず再起動
docker compose down
docker compose up -d

Prisma only supports Node.js versions 20.19+, 22.12+, 24.0+.
Please upgrade your Node.js version.

# docker-compose.yml でバージョンを固定
image: ghcr.io/gitroomhq/postiz-app:v2.12.0

Error: Please provide an authKey at new TransloaditClient

# 使用しない場合は空文字で設定
TRANSLOADIT_AUTH_KEY=""
TRANSLOADIT_AUTH_SECRET=""

MAIN_URL="https://postiz.example.com"
FRONTEND_URL="https://postiz.example.com"
NEXT_PUBLIC_BACKEND_URL="https://postiz.example.com/api"

credential access key has length 40, should be 32

X_API_KEY="your_api_key_here"         # Consumer API Key（短い方）
X_API_SECRET="your_api_secret_here"   # Consumer API Secret

# ヘルスチェック詳細を確認
docker inspect postiz-postgres | grep -A 20 "Health"

# ログで原因を確認
docker compose logs postiz-postgres

# ボリュームをリセット（データが消えるため注意）
docker compose down -v
docker compose up -d

# 必ず down してから up する
docker compose down
docker compose up -d

# 使用中のポートを確認
lsof -i :5000

# docker-compose.yml でポートを変更
# ports:
#   - "5001:5000"

# マイグレーション状態を確認
docker exec postiz npx prisma migrate status

# ログを確認
docker compose logs postiz | grep -i "migration\|prisma\|error"

docker exec postiz npx prisma migrate deploy