SQLite to PostgreSQL Migration
Migrate your Gauzy database from SQLite to PostgreSQL for production.
Why Migrate?
| Feature | SQLite | PostgreSQL |
|---|---|---|
| Concurrency | Single write | Multi-user |
| Performance | Small datasets | Large datasets |
| Scalability | Limited | Highly scalable |
| Features | Basic | Full SQL support |
| Backup | File copy | pg_dump, PITR |
| Recommended for | Development | Production |
Migration Steps
1. Set Up PostgreSQL
# Install PostgreSQL
sudo apt install postgresql
# Create database and user
sudo -u postgres createuser gauzy
sudo -u postgres createdb gauzy -O gauzy
sudo -u postgres psql -c "ALTER USER gauzy PASSWORD 'your-password';"
2. Export SQLite Data
# Use the Gauzy export tool
curl -H "Authorization: Bearer $TOKEN" \
http://localhost:3000/api/export/all \
-o gauzy-data-export.json
3. Update Configuration
Change .env:
- DB_TYPE=sqlite
- DB_NAME=gauzy.sqlite3
+ DB_TYPE=postgres
+ DB_HOST=localhost
+ DB_PORT=5432
+ DB_NAME=gauzy
+ DB_USER=gauzy
+ DB_PASS=your-password
4. Start API (Creates Schema)
yarn start:api
TypeORM will create all tables automatically on first start.
5. Import Data
curl -X POST -H "Authorization: Bearer $TOKEN" \
-F "file=@gauzy-data-export.json" \
http://localhost:3000/api/import/all
6. Verify
- Check all tables have data
- Test login and basic operations
- Verify time logs and invoices
Related Pages
- Database Connection Issues — troubleshooting
- Environment Variables — DB config