| From: | "chris smith" <dmagick(at)gmail(dot)com> |
|---|---|
| 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:52 |
| Message-ID: | 3c1395330605120641k6a090922t7196d35aea36d131@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/11/06, APSC, Patrick Chee Seng Onn <APSC(at)bossard(dot)com(dot)sg> 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?
Either try:
createuser -U postgres new_username
or, su to postgres:
su - postgres
and try again:
createuser new_username
<shameless plug>
http://www.designmagick.com/article/5/Starting-Out/PostgreSQL-Users
http://www.designmagick.com/article/6/Starting-Out/PostgreSQL-Databases
--
Postgresql & php tutorials
http://www.designmagick.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2006-05-12 13:44:31 | Re: Triggers in C - Segmentation Fault |
| Previous Message | Martijn van Oosterhout | 2006-05-12 13:41:44 | Re: Creating of User and Database |