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 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.
>
> --MnLPg7ZWsaic7Fhd
> Content-Type: application/pgp-signature
> Content-Transfer-Encoding: base64
> Content-Disposition: inline;
> filename="signature.asc"
> Content-Description: Digital signature
> X-Google-AttachSize: 190