From: | FirstDBA(at)gmail(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Creating of User and Database |
Date: | 2006-05-13 07:27:28 |
Message-ID: | 1147505248.017412.30280@i40g2000cwc.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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?
>
> 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(at)svana(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-05-13 08:55:26 | Re: [GENERAL] Querying libpq compile time options |
Previous Message | Thomas Hallgren | 2006-05-13 07:05:47 | Re: GUI Interface |