10 months ago
Description: Postgres for search and analytics
Category: Other
1 Replies
10 months ago
Very useful template, but I have a bunch of feedback so that it follows best practices -
Use the correct text casing for the template title and service name -
paradedb
->ParadeDB
Use the correct icon for the template and service, something like - https://github.com/paradedb/paradedb/blob/dev/docs/images/icon_logo.png
Use template variable functions to generate a secure password -
${{secret(32, "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_.~")}}
You are missing a
PGDATA
variable -PGDATA=/var/lib/postgresql/data/pgdata
Your
DATABASE_URL
is a public URL when it should be a private URL -postgres://${{POSTGRESQL_USERNAME}}:${{POSTGRESQL_PASSWORD}}@${{RAILWAY_PRIVATE_DOMAIN}}:5432/${{POSTGRESQL_DATABASE}}
You should have a
PUBLIC_DATABASE_URL
so that the purpose of the URL is clear -postgres://${{POSTGRESQL_USERNAME}}:${{POSTGRESQL_PASSWORD}}@${{RAILWAY_TCP_PROXY_DOMAIN}}:${{RAILWAY_TCP_PROXY_PORT}}/${{POSTGRESQL_DATABASE}}
You are using incorrect variables as per - https://docs.paradedb.com/introduction#get-started