Re: psql: FATAL: Database "postgres" does not exist in

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Sorry to bother everyone with this, but I tried searching the site and
> the archive to no avail. I have read the docs and can't seem to get
> this ironed out. I get the error "psql: FATAL:  Database "postgres"
> does not exist in the system catalog." when trying to start a psql
> session. This tells me that my install in not complete. I reread the
> the post install instructions and can't see anything obvious that says
> I missed something.

If you run psql without a database name as an option, it tries to
connect to a database with the same name as the $USER psql runs as.

So if you run it as user "postgres", and a db with that name does
not exist (yet), it will complain.

You should first create a database using "createdb somename" and then
connect with "psql somename".

Note you can get a list of available databases with psql -l.

>  
> Any help is appreciated.
>  
> Thanks
>  
> John Vandervliet


Bye,
Chris.

 
-- 

Chris Mair
http://www.1006.org




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux