File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Fatal error on PostgreSQL & Ubuntu

 
Hussein Baghdadi
clojure forum advocate
Bartender
Posts: 3479
Clojure Mac Objective C
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi.
I have PostgreSQL8.2 installed on Ubuntu 7.10
I run the following commands:

Then, I tried to create a database:
createdb
But I got this error:
createdb: could not connect to database postgres: FATAL: role "root" does not exist
What is going wrong?
Thanks.
 
Jeff Rummings
Ranch Hand
Posts: 42
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can specify a postgres username with the 'psql -U' flag or you can also try:

psql <dbname> <username>
[ January 11, 2008: Message edited by: Arman Sharif ]
 
Stefan Wagner
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
... and you shouldn't use the root-account for running postgres.

You may make system calls from the database, and maybe they could be hidden by a trigger (which worked perfectly yesterday) and so on.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic