Installing postgresql, problems with non-existant user...
jaycamp at CLEMSON.EDU
Thu Jun 23 20:09:50 UTC 2005
With the default setup you will need to switch to the postgres user to
create new users.
sudo -s -u postgres
then createuser to add a new database user.
You can change the way it authenticates in /etc/postgresql/pg_hba.conf
My commands/file paths may be slightly off since I'm not on a Linux box
at the moment.
Neil Woolford wrote:
>I've just installed the postgresql and postgresql-client packages using
>When I try to create a database I get the following error;
>createdb: could not connect to database template1: FATAL: user "neil"
>does not exist
>Similar errors occur if I try to create a user.
>If I explicitly try to run a command as user 'postgres' I get;
>createdb: could not connect to database template1: FATAL: IDENT
>authentication failed for user "postgres"
>My reading of the manual so far is that the default setup should be that
>all local users are automatically allowed to create databases.
>What should I be setting up? What have I missed?
More information about the ubuntu-users