A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Linux / UNIX
Fatal error on PostgreSQL & Ubuntu
clojure forum advocate
Joined: Nov 08, 2003
Jan 09, 2008 04:01:00
I have PostgreSQL8.2 installed on Ubuntu 7.10
I run the following commands:
sudo -u postgres psql ALTER ROLE postgres WITH ENCRYPTED PASSWORD 'pgpassword'; \q sudo -u postgres psql -d postgres < /usr/share/postgresql/8.2/contrib/adminpack.sql
Then, I tried to create a database:
But I got this error:
createdb: could not connect to database postgres: FATAL: role "root" does not exist
What is going wrong?
Joined: Dec 20, 2007
Jan 11, 2008 14:54:00
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 ]
Joined: Jun 02, 2003
Jan 12, 2008 23:37:00
... 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.
It is sorta covered in the
JavaRanch Style Guide
subject: Fatal error on PostgreSQL & Ubuntu
JDBC / RedHat 9/ PostgreSQL
Calling a psql command from a Groovy script
java -jar [error] unable to access jarfile postgresql-8.4-702.jdbc.3.jar
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014