After you install postgres using 'root', create your postgres database
cluster (initdb ) as "postgres" rather than "root". Your database
files therefore should be owned by "postgres" not root.
--
Husam
http://firstdba.googlepages.com
Martijn van Oosterhout wrote:
> On Thu, May 11, 2006 a
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 u
On 5/11/06, APSC, Patrick Chee Seng Onn <[EMAIL PROTECTED]> 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 n
