Couldn't connect my postgress while installing medusa.

[Fardeen-Awais]

I had already downloaded my posgresql in my computer and created the database but when i installing medusa it is not working. I'm 100% sure i'm providing the right password

`PS G:\Practices\04_Medusa_experiment> yarn create medusa-app
yarn create v1.22.19
[1/4] Resolving packages...
[2/4] Fetching packages...
[3/4] Linking dependencies...
[4/4] Building fresh packages...
success Installed "create-medusa-app@1.0.4" with binaries:
- create-medusa-app
? What's the name of your project? my-medusa-store
? Enter your Postgres username postgres
? Enter your Postgres password [hidden]
Couldn't connect to PostgreSQL. Make sure you have PostgreSQL installed and the credentials you provided are correct.

You can learn how to install PostgreSQL here: https://docs.medusajs.com/development/backend/prepare-environment?os=windows#postgresql

If you keep running into this issue despite having PostgreSQL installed, please check out our troubleshooting guidelines: https://docs.medusajs.com/troubleshooting/database-error
error Command failed.
Exit code: 1
Command: C:\Users\farde\AppData\Local\Yarn\bin\create-medusa-app
Arguments:
Directory: G:\Practices\04_Medusa_experiment
Output:
`

[AbhinavChavareTechcopain]

please check the port of PostgreSQL for medusa it should be 5432.
Thanks

[srindom]

cc: @shahednasser

[shahednasser]

@Fardeen-Awais with the latest update of create-medusa-app, you can set your database url by passing it as an option as follows:

npx create-medusa-app@latest --db-url postgres:://user:password@localhost:5432/giftstore

Make sure to pass the correct username, password, and port (by default it's 5432).

Please note that with the latest version there's an issue with using yarn create medusa-app. We've opened a PR to fix it, so please use npx or pnpm for now.

[Fardeen-Awais]

Thanks the problem was in my port. I changed my port that cause error.

[zaidrashid]

Hello, I have the same issue, but my Postgres is running in Docker.

When I tested my connection via psql command, I am able to connect to it.

However, when I passed the same command to start a medusa project, I ran into this issue.

I am currently just testing it, so my Postgres user is user and its password is password and my database is mydatabase and the port is 5432 (I did not pass the -p in the psql command as that is the default).

Anything that I missed? Thanks!

[shahednasser]

@zaidrashid sorry no. I'll try when I get some time this week and let you know

[shahednasser]

@zaidrashid just tested it out, and at first I wasn't able to connect to the database. But then after making sure the port was published, it connected successfully.

Can you make sure you published/exposed the 5432 port of your docker container? If you're running it from the terminal, it can be done with the -p option. For example:

docker run -d -p 5432:5432 --name some-postgres -e POSTGRES_PASSWORD=supersecret postgres

From the Docker Desktop you can specify the exposed port as well:

Let me know if this works out.

[zaidrashid]

Hi @shahednasser , sorry for the late reply. I was on holiday and just returned last week.

I've tried that actually and tried it again. Here's a snapshot of my container.

But still having issues with the medusa-create-app though. Is there some inner logs that I could check by myself when creating the medusa-app?

[shahednasser]

@zaidrashid unfortunately there isn't. Maybe try setting up the Medusa backend following this guide? It gives you more flexibility during the setup process and maybe the error will be clearer.

[zaidrashid]

So what I did just now is to clone the whole repo and build it so that I can use the create-medusa-app package. I was hoping to catch the same error, and output the error message here,

medusa/packages/create-medusa-app/src/utils/create-db.ts

Lines 127 to 131 in 8f25ed8

	} catch (e) {
	logMessage({
	message: `Couldn't connect to PostgreSQL using the database URL you passed. Make sure it's correct and try again.`,
	type: "error",
	})

but surprisingly it works on both develop branch and create-medusa-app@1.2.5 tagged branch.

For now, I will explore medusa since I managed to create the app, but I will try later setting it up from the guide you provided. Thanks for the support so far. I'll let you know if I have further questions.

[tomgavant]

I was having this same problem with docker, and realized I had my local posgres for another project still running on 5432, sudo lsof -i :5432. I switched my docker port to 5431, and create-medusa-app ran successfully

[kensteele]

Issue

Note

This is a reproduction of bug #4999

Running npx create-medusa-app@latest --with-nextjs-starter fails with error: role "postgres" does not exist

Environment

Versions:

OSX:               14.4 (Sonoma)
NodeJS:            v21.7.1
Homebrew:          4.2.15-32
create-medusa-app: 1.2.7

Steps to reproduce

1. brew install postgres
2. npx create-medusa-app@latest --with-nextjs-starter
3. Accept the defaults for project name, email, postgres username and postgres password

Results

• Fails with error: role "postgres" does not exist:

npx create-medusa-app@latest --with-nextjs-starter
? What's the name of your project? my-medusa-store
? Enter an email for your admin dashboard user admin@medusa-test.com
? Enter your Postgres username postgres
? Enter your Postgres password [hidden]
Couldn't connect to PostgreSQL because of the following error: error: role "postgres" does not exist.

Make sure you have PostgreSQL installed and the credentials you provided are correct.

You can learn how to install PostgreSQL here: https://docs.medusajs.com/development/backend/prepare-environment?os=macos#postgresql

If you keep running into this issue despite having PostgreSQL installed, please check out our troubleshooting guidelines: https://docs.medusajs.com/troubleshooting/database-error

Expected results

• npx create-medusa-app@latest --with-nextjs-starter should succeed

SOLUTION

• Create a postgres role with all privileges:

Important

psql -U $USER -d postgres -c 'CREATE ROLE "postgres"' \
-c 'ALTER ROLE "postgres" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS'

• To verify the role was created, you should now see ${USER} and postgres when dumping the roles:

psql -U $USER -d postgres -c '\du'
                                    List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 ${USER}   | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

• Run create-medusa-app again

npx create-medusa-app@latest --with-nextjs-starter

Further Analysis

Note

Substitute ${USER} below with your currently logged in OSX username

brew install postgres on OSX installs postgres@14 and does the following:

• creates a role ${USER} with no password
• grants the ${USER} role all privileges
• creates a database postgres

npx create-medusa-app@latest --with-nextjs-starter appears to assume the database name and the role name are the same, which results in either a database or role error when they don't match.

• when specifying ${USER} for the Postgres username:

Couldn't connect to PostgreSQL because of the following error: error: database "${USER}" does not exist.

• when specifying postgres (or default) for the Postgres username:

Couldn't connect to PostgreSQL because of the following error: error: role "postgres" does not exist.

• Upon inspecting the create-medusa-app npm module source in the medusa v1.20.4 tag, we see that the user is prompted to enter their database username and password, but not the database name.
  

  medusa/packages/create-medusa-app/src/utils/create-db.ts

  Lines 63 to 85 in 2524a9d

  	try {
  	client = await postgresClient({
  	user: postgresUsername,
  	password: postgresPassword,
  	})
  	} catch (e) {
  	// ask for the user's postgres credentials
  	const answers = await inquirer.prompt([
  	{
  	type: "input",
  	name: "postgresUsername",
  	message: "Enter your Postgres username",
  	default: "postgres",
  	validate: (input) => {
  	return typeof input === "string" && input.length > 0
  	},
  	},
  	{
  	type: "password",
  	name: "postgresPassword",
  	message: "Enter your Postgres password",
  	},
  	])

Potential fixes

1. In utils/create-db.ts, prompt the user to specify their database name (with a default of postgres):

      {
        type: "input",
        name: "postgresDatabaseName",
        message: "Enter your Postgres database name",
        default: "postgres",
        validate: (input) => {
          return typeof input === "string" && input.length > 0
        },
      },
    ])

    postgresUsername = answers.postgresUsername
    postgresPassword = answers.postgresPassword
    postgresDatabaseName = answers.postgresDatabaseName

2. When the initial db connection with username postgres and database name postgres fails, automatically attempt to connect using username: process.env.USER and database name: postgres