prisma can't connect to postgresql
Sep 1
I've tried to connect Prisma with postgreSQL several times. prisma show this error message : "Error: undefined: invalid port number in "postgresql://postgres:password@localhost:5432/linker")".
-prisma/.env
DATABASE_URL=postgresql://postgres:password@localhost:5432/linker
-schema.prisma
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
So, first, I checked the port number to see if it was right and 5432 is right because I use the default port number. I also checked the postgresql.conf file, which is set to "listen_address="*"" , "port=5432".
And I went into pgAdmin4 and saw server's properties. the port number was 5432 as shown below image, and the username was set "postgres".
I don't know why prisma can't connect
Did i something missed?
prisma
postgresql
1 answer
Accepted answer · original discussion
Jul 1
Replace special characters with percent-encodings
Make sure that in your DATABASE_URL in the .env file, the special characters in your username and password are replaced with percent-encodings.
For example, in your database URL, if your username or password contains @ character, it should be replaced with its equivalent percent-encoding, that is %40. For # it is %23 and so on. See the list below.
Percent-encodings
Following are the percent-encodings for the frequently used special characters:
| Special Character | Percent Encoding |
|---|---|
! |
%21 |
# |
%23 |
$ |
%24 |
% |
%25 |
& |
%26 |
' |
%27 |
( |
%28 |
) |
%29 |
* |
%2A |
+ |
%2B |
, |
%2C |
/ |
%2F |
: |
%3A |
; |
%3B |
= |
%3D |
? |
%3F |
@ |
%40 |
[ |
%5B |
] |
%5D |
newline |
%0A or %0D or %0D%0A |
space |
%20 |
" |
%22 |
% |
%25 |
- |
%2D |
. |
%2E |
< |
%3C |
> |
%3E |
\ |
%5C |
^ |
%5E |
_ |
%5F |
` |
%60 |
{ |
%7B |
| |
%7C |
} |
%7D |
~ |
%7E |
£ |
%C2%A3 |
円 |
%E5%86%86 |
1 question comment
Use comments to ask for clarification. Post a solution as an answer.
Sep 1