Configuration

Configuration

macOS

After installation, PostgreSQL should be running automatically. You can manage it with:

# Start PostgreSQL
brew services start postgresql@17

# Stop PostgreSQL
brew services stop postgresql@17

# Restart PostgreSQL
brew services restart postgresql@17

# Check status
brew services list | grep postgresql

Windows

PostgreSQL runs as a Windows service. You can manage it through:

Using Services (GUI):

1. Press Win + R, type services.msc, press Enter
2. Find "postgresql-x64-17" (or similar)
3. Right-click → Start/Stop/Restart

Using Command Line:

# Start PostgreSQL service
net start postgresql-x64-17

# Stop PostgreSQL service
net stop postgresql-x64-17

# Check status
Get-Service postgresql*

Docker

If you installed PostgreSQL using Docker, manage it with:

# Start PostgreSQL
docker-compose up -d
# Or if using docker run:
docker start postgres-pgvector

# Stop PostgreSQL
docker-compose down
# Or if using docker run:
docker stop postgres-pgvector

# Restart PostgreSQL
docker-compose restart postgres
# Or if using docker run:
docker restart postgres-pgvector

# Check status
docker-compose ps
# Or if using docker run:
docker ps | grep postgres

# View logs
docker-compose logs postgres
# Or if using docker run:
docker logs postgres-pgvector