| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "APSC, Patrick Chee Seng Onn" <APSC(at)bossard(dot)com(dot)sg> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Creating of User and Database |
| Date: | 2006-05-12 13:41:44 |
| Message-ID: | 20060512134144.GC12955@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 receive a 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chris smith | 2006-05-12 13:41:52 | Re: Creating of User and Database |
| Previous Message | chris smith | 2006-05-12 13:37:25 | Re: Connecting to PostgreSQL on Linux with windows |