Difficulty with your instructions

[pszolovits]

I'm a total newbie with Postgres, and am running into a problem with your instructions on how to load the mimic4 (1.0) data into the Postgres application running on Mac OS Monterey (on a new MacBook Pro). I've started the Postgres application, which seems to be running fine, and I can access it via pgAdmin. I can also connect to the database simply with
psql -U
or just
sql
However, when I follow the instruction:
createuser -P -s -e -d mimicuser #creat user
psql -U mimicuser #launch psql

I get the following error:
(base) psz@Osler ~ % psql -U mimicuser
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: database "mimicuser" does not exist

It seems that creating the user does not create a corresponding database. Or perhaps the Postgres app stores its linking files somewhere other than /tmp.
Some very basic help would be much appreciated. Thank you.

[yikuan8]

I haven't used Postgres w/ Mac before. Neither did I encounter this issue. You may check this out which might help.

Also, you don't have to create a user for postgres if you are working on your PC. You can directly create the database if "psql -U" works for you. Please let me know if you need further help!

Btw, excited to meet academic grandfather here (Yuan is my advisor).

[pszolovits]

Thanks for the quick tip, which I’ll follow up as soon as I have finished some other “on fire” responsibilities. It’s nice to meet one of my “grandstudents”! By the way, you descend (academically) from Alfred Tarski, one of the great logicians of the 20th century, who was the thesis advisor (at Berkeley) of my thesis advisor (at Caltech), Fred Thompson. Here is a pointer to Fred’s obituary, in case you are interested: https://www.caltech.edu/about/news/frederick-b-thompson-43160 <https://www.caltech.edu/about/news/frederick-b-thompson-43160> —Pete

…

On Jan 22, 2022, at 2:25 AM, Yikuan8 ***@***.***> wrote: I haven't used Postgres w/ Mac before. Neither did I encounter this issue. You may check this <https://stackoverflow.com/questions/31645550/postgresql-why-psql-cant-connect-to-server> out which might help. Also, you don't have to create a user for postgres if you are working on your PC. You directly create the database if "psql -U" works for you. Please let me know if you need further help! Btw, glad to meet academic grandfather here (Yuan is my advisor). — Reply to this email directly, view it on GitHub <#4 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AA2BAC6DWQVDGBLDO3CI7HLUXJLXXANCNFSM5MQPQWRQ>. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.