Did you ever delete the DB "postgres"? It's normally there by default.
How did you get into this situation?
I can drop and recreate it just fine:
$ sudo pg_createcluster 8.3 main --start
$ sudo -u postgres psql -Atl
postgres|postgres|UTF8
template0|postgres|UTF8
template1|postgres|UTF8
$ sudo -u postgres dropdb postgres
$ sudo -u postgres createdb postgres
0 mar...@tick:~
$ sudo -u postgres psql -Atl
postgres|postgres|UTF8
template0|postgres|UTF8
template1|postgres|UTF8
Do you have any nonstandard settings in
/etc/postgresql/8.3/main/postgresql.conf, or are you using /etc
/postgresql-common/user_clusters, or does the postgres user have a
~/.postgresqlrc?
** Changed in: postgresql-8.3 (Ubuntu)
Status: New => Incomplete
--
createdb fails
https://bugs.launchpad.net/bugs/330441
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs