On Thu, May 11, 2006 at 10:35:12AM +0800, APSC, Patrick Chee Seng Onn wrote:
> Hi,
>
> I've just installed postgresql onto my system but unable to successfully add new users and databases. I would
receivea error message:
>
> createuser: could not connect to database template1: FATAL user "root" does not exist
>
> createdb: could not connect to database template1: FATAL user "root" does not exist
>
> what is the error I am facing anyway?
On installation the only user is "postgres". You don't say what system
you are running but the server should be configured so that running
createuser as the same user as the server should work. Once you've
created additional users you're set.
You can use -U to set the user to connect as.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.