On 07/09/2003 11:59 Dr. Azmir wrote:
Hi there I'm Dr. Azmir from Kuala Lumpur. I'm using RH 9.0 with postgresql intalled in it. My problem is I can't createuser and createdb with it. The error message "psql: FATAL: user "name" does not exist createdb: database creation failed"
will pop up.
Why?
You need to be user postgres to create at least one user. The way I do it is, from root, su postgres, create a user with createuser which can also create databases and other users. On my development machines, I use my unix user name so its really easy to create databases and other users without su'ing around. On production machines, I set up a dba user.
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
