Did a new install of postgres 8.4 on mint ubuntu. How do I create a user for postgres and login using psql?
When I type psql, it just tells me
psql: FATAL: Ident authentication failed for user "my-ubuntu-username"
+1
A:
Try this:
sudo -u postgres createuser -s $USER
now you can do createdb mydatabase, and psql -d mydatabase
Evan Carroll
2010-01-31 17:24:47
same error :-(createuser: could not connect to database postgres: FATAL: Ident authentication failed for user
2010-01-31 17:34:22
try again, forgot the -u postgres
Evan Carroll
2010-01-31 17:38:48
didn't give an error this time, but I am not inside psql. what am I missing?
2010-01-31 17:44:52
updated again, with instructions on how to create the db and login
Evan Carroll
2010-01-31 17:56:00
that worked, thank you so much
2010-01-31 17:58:29
A:
by default you would need to use the postgres user:
sudo -u postgres psql postgres
A:
The error your are getting is because your-ubuntu-username is not a valid Postgres user.
You need to tell psql what database username to use
psql -U postgres
You may also need to specify the database to connect to
psql -U postgres -d <dbname>
cope360
2010-01-31 17:40:01