Re: Creating of User and Database

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