Psql Error Database Does Not Exist
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the database does not exist sql server company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Createdb: Database Creation Failed: Error: Permission Denied To Create Database
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million
Fatal: Database Does Not Exist Rails
programmers, just like you, helping each other. Join them; it only takes a minute: Sign up psql: FATAL: database “
Su: Unknown Login: Postgres
(http://postgresapp.com/). I've used it in the past on other machines but it's giving me some trouble when installing on my macbook. I've installed the application and I ran: psql -h localhost It returns: psql: FATAL: database "
Sign in Pricing Blog Support Search GitHub This repository Watch 95 Star 2,841 Fork 156 PostgresApp/PostgresApp Code Issues 62 Pull requests 2 how to exit psql Projects 0 Pulse Graphs New issue FATAL: database "dave" does not psql createdb exist #139 Open bingomanatee opened this Issue Oct 19, 2013 · 11 comments Projects None yet Labels pg::insufficientprivilege: error: permission denied to create database bug Milestone No milestone Assignees No one assigned 9 participants bingomanatee commented Oct 19, 2013 using the "psql" menu item (OSX 10.8.4) I get Last login: http://stackoverflow.com/questions/17633422/psql-fatal-database-user-does-not-exist Sat Oct 19 07:59:28 on ttys009 /Applications/Postgres.app/Contents/MacOS/bin/psql ; exit; Daves-MacBook-Pro:~ dave$ /Applications/Postgres.app/Contents/MacOS/bin/psql ; exit; psql: FATAL: database "dave" does not exist logout [Process completed] Postgres.app member jakob commented Oct 28, 2013 The first time you open Postgres.app, it automatically creates a database named like your username. Apparently this database doesn't exist. There are a few possible reasons why https://github.com/PostgresApp/PostgresApp/issues/139 this database doesn't exist: 1) You changed your username 2) psql is not connecting to Postgres.app but to a different server There are a number of reasons why psql might be connecting to a different server: 1) Maybe you have a different Postgres installation already running on your Mac 2) Maybe you already started a copy of Postgres.app as a different user on your machine 3) Maybe you changed the psql configuration using environment variables PGDATABASE, PGHOST, PGPORT, PGUSER or you changed settings in the file ~/.psqlrc Shpigford commented Oct 28, 2013 I'm also getting this error. I'm using the 9.3.1.0-alpha1 pre-release. This is on OS X Mavericks. $ which psql /Applications/Postgres93.app/Contents/MacOS/bin/psql $ psql psql: FATAL: database "USERNAME" does not exist I haven't changed my username. My previous Postgres installation isn't running (I force quit all instance of Postgres). Postgres.app member jakob commented Oct 29, 2013 Could you try connecting to the "postgres" database: psql -d postgres and then execute the following command: show data_directory; On 9.3.1.0-alpha1 that should return /Users/USERNAME/Library/Application Suppo
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites https://www.postgresql.org/message-id/1155685965.28246.6.camel@dell.home.lan Propaganda Resources Weekly News Re: psql: FATAL: Database "postgres" does not exist in From: Chris Mair
Mike Thomsen Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ "Database does not exist"... but it does exist I'm running into a bizarre issue with "database XYZ does not exist." I've done a lot of searching, but can't find the cause. For the sake of reference, this is PG 8.4.6 running on RHEL 5.4. Here's what I've done so far with md5 authentication enabled: psql -U postgres -c "create user miket with password 'miket'" createdb testingdb -U postgres psql -U postgres -d testingdb -c "create schema testingdb authorization miket" psql -U postgres -d testingdb -c "grant all privileges on database testingdb to miket" The last statement returns the following: ERROR: database "testindb" does not exist When I run: psql -l -U postgres testindb most certainly does exist. Any help on resolving this would be greatly appreciated. Thanks, Mike -- Sent via pgsql-novice mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice vibhor.kumar@enterprisedb.com Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: "Database does not exist"... but it does exist On Jan 21, 2011, at 10:31 PM, Mike Thomsen wrote: > > psql -l -U postgres Plz share the output of command Vibhor Kumar EnterpriseDB Corporation The Enterprise Postgres Company Cell: +91-932-568-2279 [hidden email] Blog:http://vibhork.blogspot.com-- Sent via pgsql-novice mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice Thom Brown-2 Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: "Database does not exist"... but it does exist In reply to this post by Mike Thomsen On 21 January 2011 17:01, Mike Thomsen <[hidden email]> wrote: > I'm running into a bizarre issue with "database XYZ does not exist." > I've done a lot of searching, but can't find the cause. For the sake > of reference, this is PG 8.4.6 running on RHEL 5.4. > > Here's what I've done so far with md5 authentication enabled: > > psql -U postgres -c "cre