Search Postgresql Archives

Re: Creating of User and Database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 5/11/06, APSC, Patrick Chee Seng Onn <APSC@xxxxxxxxxxxxxx> 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/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux