Linked Questions

17 questions linked to/from psql: FATAL: database "<user>" does not exist
3 votes
1 answer
24k views

I am running a PostgreSQL 14 on my mac, tried to reinstall it since I forgot the password. (base) % brew uninstall --force postgresql@14 (base) % brew cleanup -s (base) % brew install ...
user824624's user avatar
  • 8,170
3 votes
0 answers
2k views

I trying to create a Postgres Database with Docker Compose, but i'm not understanding why the PSQL client is telling me that a database called root doesn't exists. That's the docker-compose.yml ...
0 votes
0 answers
120 views

I have just finished install postgres from the way that the postgresql website says for ubuntu20.04 when I run psql I get psql: error: FATAL: database "myusername" does not exist when I ...
INuke's user avatar
  • 313
0 votes
1 answer
102 views

I have created a new role "joe" with pgadmin 4, it has a password, createdb rights, but not superuser privileges. On Windows, using the terminal from visual studio code, I try to login as ...
Bondifrench's user avatar
  • 1,292
790 votes
36 answers
916k views

I'm a postgres novice. I installed the postgres.app for mac. I was playing around with the psql commands and I accidentally dropped the postgres database. I don't know what was in it. I'm currently ...
136 votes
30 answers
317k views

Not really sure what caused this but most likely exiting the terminal while my rails server which was connected to PostgreSQL database was closed (not a good practice I know but lesson learned!) I've ...
Lea Tinoso's user avatar
  • 2,423
151 votes
23 answers
258k views

Like some others I am getting this error when I run rake db:migrate in my project or even try most database tasks for my Ruby on Rails 3.2 applications. PGError (could not connect to server: No such ...
129 votes
11 answers
181k views

I have just installed Postgres and have been tinkering with it and various configurations for 1-2 hours. I am stuck on being unable to change to the postgres-user $ su - postgres yields the ...
krystah's user avatar
  • 3,743
12 votes
2 answers
5k views

I'm getting an error when trying to create a database. I have postgres installed and I've already made a few test projects successfully. And, I've not seen this error. Any help would be great: ERROR: ...
3 votes
3 answers
3k views

My app works fine in production, but when I move to production and run 'heroku run rake db:migrate', I get the following error: PG::UndefinedTable: ERROR: table "applications" does not exist ...
2 votes
2 answers
8k views

Setting up a development environment on a new machine, brew installed postgres. Now I need to initdb for the first time, which directory should i specify for this command?
8 votes
0 answers
10k views

I followed these instructions to get postgresql running on mac. Note that I am using Homebrew to install, and the current version installable through brew is 9.2.1, so I changed the version numbers in ...
jay's user avatar
  • 12.6k
4 votes
1 answer
5k views

After doing brew install postgres: brew install postgres brew link --overwrite postgresql Postgres is already running: /~ $brew services start postgresql Service `postgresql` already started, use `...
2 votes
3 answers
3k views

Totally new to postgresql; just had it installed (version 14.1) for the first time via brew on m1 Mac. Installation works fine, but I thought the installation process shall also create a superuser ...
dragonfly02's user avatar
  • 3,729
3 votes
1 answer
9k views

I am trying to create my own Spring Boot application with a POSTGRESQL database. I have started using docker to mount the database, with a docker-compose whose values ​​are as follows: version: "...

15 30 50 per page
1
2