R
Railway•6mo ago
Sang Dang

Is it normal when pgvector does not copy the POSTGRES_PASSWORD env vars from production environment?

I have a pgvector service, but whenever I make new PR, it crashes on the PR environment, the error is something like:
Error: Database is uninitialized and superuser password is not specified.
You must specify POSTGRES_PASSWORD to a non-empty value for the
Error: Database is uninitialized and superuser password is not specified.
You must specify POSTGRES_PASSWORD to a non-empty value for the
Which I find it's quite strange, because all other services like my nextjs app or nestjs backend just copy their env vars just fine. Do I miss something here?
Solution:
iirc the fix is to enable this.
No description
Jump to solution
16 Replies
Percy
Percy•6mo ago
Project ID: 28677a80-2aaf-46d7-8fff-e2898fa09eb1
Sang Dang
Sang Dang•6mo ago
28677a80-2aaf-46d7-8fff-e2898fa09eb1
Brody
Brody•6mo ago
can you show screenshots of the pgvector's service variables in the pr environment?
Sang Dang
Sang Dang•6mo ago
damn, I merged the PR, but I remember I checked it and all of them are empty string (at least I can be sure the POSTGRES_PASSWORD) I can spawn a new PR if you want to check it
Brody
Brody•6mo ago
yes please
Sang Dang
Sang Dang•6mo ago
you can see none of them were there
No description
No description
Sang Dang
Sang Dang•6mo ago
I used default template with almost nothing customised
No description
Brody
Brody•6mo ago
interesting, I'll see if I can reproduce
Sang Dang
Sang Dang•6mo ago
Does not want to be pushy, but we really need to have the AI demo soon, and the pgvector plays an important part in it, and my salary depends the demo, so... 😸
Brody
Brody•6mo ago
@fp - service variables are not being carried over into the service in a pr env with no options to add them back
Solution
Faraz
Faraz•6mo ago
iirc the fix is to enable this.
No description
Faraz
Faraz•6mo ago
Then the variables are carried over from your base environment.
Sang Dang
Sang Dang•6mo ago
thanks, let me check damn it works 🔥 I just dont understand, then why other services like nextjs and nestjs still copy vars before ticking that checkbox?
Brody
Brody•6mo ago
we will never know
Sang Dang
Sang Dang•6mo ago
btw thanks Brody and fp, it works as expected now