RailwayDeploy4

Pure Python Deployment with pg8000+scramp, migration scripts, ImportError: libpq.so.5 troubleshooting

This guide documents the new Pure Python deployment process for Railway applications, focusing on key components and common issues.

Key Components

• pg8000+scramp: Pure Python PostgreSQL driver alternative to psycopg2
• Migration Scripts: Database schema management and deployment
• libpq.so.5: Common ImportError troubleshooting

Deployment Process

The Pure Python deployment eliminates the need for system-level PostgreSQL dependencies by using pg8000 and scramp as a drop-in replacement for psycopg2.

Troubleshooting ImportError: libpq.so.5

This error occurs when the system cannot find the PostgreSQL client library. Solutions include:

• Installing postgresql-client or libpq-dev system packages
• Switching to pg8000+scramp for pure Python database connectivity
• Ensuring proper LD_LIBRARY_PATH configuration