'postgres' 검색 결과

Check whether gbrain uses PGLite or Postgres, set up a Postgres-backed installation, or migrate existing PGLite data with its history. The workflow presents a migration plan for approval, verifies transferred tables, and supports interrupted migration recovery.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Checking which database engine gbrain uses
• Setting up Postgres for a new gbrain installation
• Moving PGLite data and history to Postgres

PostgreSQL 테이블 설계, 검색 속도를 높이는 인덱스, 행 단위 접근 제어의 구현 예시를 참고합니다. 느린 SQL 조사와 연결 설정 개선에도 활용합니다.

• PostgreSQL의 느린 쿼리를 조사합니다
• 인덱스와 열의 데이터 타입을 선택합니다
• 행 단위 접근 제어를 설계합니다

Migrate the database access layer of a .NET/C# application from Oracle to PostgreSQL with Npgsql. Update packages, connection settings, parameter types, SQL, and stored procedure calls, then build the copied project and track completed migration tasks.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Migrate C# database access from Oracle to PostgreSQL
• Replace Oracle packages and connection settings
• Review parameter types and stored procedure calls

Provision a PostgreSQL database with Neon Instagres and save connection settings for application use and migrations. Includes setup examples for Drizzle and Prisma, initial data loading, and claiming a temporary database to keep using it.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Provision a PostgreSQL database for development
• Configure database access with Drizzle or Prisma
• Load a SQL file with initial data

Design and review PostgreSQL database schemas by choosing suitable column types, keys, constraints, and indexes. It also guides decisions about large-table partitioning, flexible JSONB data, and schema changes on a live database without downtime.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Designing or reviewing a new PostgreSQL schema
• Choosing data types, constraints, and indexes
• Planning partitions for a large table

Review PostgreSQL queries and data designs using execution plans, which show how queries run, and targeted index recommendations. Get guidance on JSONB, arrays, full-text search, analytical queries, extensions, and routine database maintenance.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating slow queries and choosing indexes
• Reviewing JSONB searches and full-text search
• Writing running totals and ranking queries

Convert Oracle stored procedures and functions, programs stored inside a database, into PostgreSQL equivalents. Preserve parameters and control flow while adapting Oracle syntax, resolving types, and mapping text sorting rules to the target environment.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Convert Oracle procedures to PostgreSQL
• Resolve parameter types from table definitions
• Map text sorting rules during migration

Create and connect to managed MySQL, PostgreSQL, or SQL Server databases on Google Cloud. This skill guides instance setup, database creation, access permissions, and connection steps, with references for backups, security, and Terraform configuration.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Create a PostgreSQL database on Google Cloud
• Connect to a database through Cloud SQL Auth Proxy
• Review database permissions and backup options

Azure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments. Use for creating servers, databases, firewall rules, configurations, backups, and high availability. Triggers: "PostgreSQL", "PostgreSqlFlexibleServer", "PostgreSQL Flexible Server", "Azure Database for PostgreSQL", "PostgreSQL database management", "PostgreSQL firewall", "PostgreSQL backup", "Postgres".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Create and manage MySQL, PostgreSQL, and SQL Server databases on Google Cloud. Covers instance setup, users, backups, availability, and secure connections, with a PostgreSQL walkthrough and references for application connectors and Terraform configuration.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Create a PostgreSQL database on Google Cloud
• Manage database users and passwords
• Connect through Cloud SQL Auth Proxy

Improve PostgreSQL performance through a staged workflow covering slow query analysis, indexes that speed up data access, query rewrites, configuration tuning, routine maintenance, and monitoring for production databases.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating slow PostgreSQL queries
• Reviewing database indexes
• Tuning database configuration

Get documentation-based help with PostgreSQL queries, database design, administration, and performance tuning. The supplied reference also explains connection settings and libpq, PostgreSQL’s C client library, for investigating connection failures and implementing connection handling.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Writing SQL and planning database structures
• Checking connection strings and parameter settings
• Investigating connection failures with libpq

Build and run Omnigent’s server and Postgres together with Docker Compose on a laptop or existing Docker host. Use the supplied configuration and troubleshooting guidance to rebuild images, investigate startup problems, or adapt deployment to another platform.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Running Omnigent locally with Postgres
• Starting the stack on an existing VPS or EC2 host
• Investigating startup and web interface problems

Write, review, and optimize Postgres queries, database structures, and configuration using guidance maintained by Supabase. Prioritized rules and SQL examples help assess query speed, connections, indexes, and row-level security, which controls access to individual rows.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Review slow SQL queries
• Assess table structures and indexes
• Review connection pooling and scaling settings

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers: "PostgreSQL", "postgres", "pg client", "node-postgres", "Azure PostgreSQL connection", "PostgreSQL TypeScript", "pg Pool", "passwordless postgres".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Analyzes one .NET project to plan integration tests for an Oracle-to-PostgreSQL migration. Identifies database access methods, prioritizes migration risks, and documents test cases, seed data, and coverage, including empty strings, NULL values, and timezone behavior.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Identifying database access methods that need integration tests
• Prioritizing tests for Oracle-specific behavior
• Planning checks for empty strings, NULL values, and timezones

Review PostgreSQL code for database design, performance, and security issues. Get improvement suggestions covering JSONB, a binary JSON format, arrays, indexes, custom data types, functions, extensions, and rules that control access to individual rows.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Reviewing JSONB and array queries
• Checking table types and constraints
• Improving functions and triggers

Turn defects found during Oracle-to-PostgreSQL migration into structured bug reports. Document expected and actual behavior, reproduction steps, severity, root causes, proposed changes, and validation on both databases so teams can act on the findings.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Documenting behavioral differences found during migration
• Organizing reproduction steps and test data
• Recording fixes, affected files, and validation steps

Guides Postgres query writing, schema design, and configuration reviews using Supabase's prioritized rules. Helps identify improvements in query performance, connection management, and row-level security, which controls access to individual rows.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Review slow SQL queries and index usage
• Check table and schema designs
• Review connection pooling and scaling settings

Create integration tests for .NET database access before migrating from Oracle to PostgreSQL. The tests record expected Oracle behavior with controlled test data and portable checks, providing a baseline for later migration validation.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Recording Oracle behavior before migration
• Testing repository methods and stored procedure calls
• Checking empty strings, NULL inputs, and datetime precision

Review every project in a .NET solution for Oracle dependencies, classify its migration status, and create a saved PostgreSQL migration plan with a project inventory and an order that prioritizes shared libraries.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Planning an Oracle-to-PostgreSQL migration across multiple projects
• Identifying Oracle dependencies in a .NET solution
• Deciding migration order based on project dependencies

Design and build backend services with API scaffolding, database migrations, authentication reviews, and load testing. Generate route handlers from OpenAPI specifications, identify PostgreSQL optimization opportunities, and compare architecture choices against traffic, data sensitivity, and reliability requirements.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Generating API route handlers from OpenAPI
• Investigating slow PostgreSQL queries
• Reviewing authentication and input validation

Improve PostgreSQL queries and database design by examining execution plans and choosing indexes for actual access patterns. Get guidance on large tables, JSONB data, connection pooling, and maintenance while accounting for write overhead and memory use.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating slow queries with execution plans
• Choosing indexes for search patterns
• Designing partitions for time-series data

Analyze and tune PostgreSQL databases using query execution plans, which show how queries run. This skill guides index design, JSONB searches, replication setup, maintenance, and monitoring, with checks to compare behavior before and after changes.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigate slow queries with EXPLAIN
• Design indexes for JSONB searches
• Configure replication and monitor lag