Re: Help me!

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: teacherenglishvn(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help me!
Date: 2003-03-04 22:38:59
Message-ID: 20030304223859.GC9739@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Very simple, don't use root. Create a user postgres and run the database
server as that. Then you can let the user "root" login although that's an
exceedingly bad idea.

Hope this helps,

On Wed, Feb 26, 2003 at 06:54:36PM -0800, DangVan Chinh wrote:
>
> I don't know starting a PostgreSQL server on RedHat Linux 8.0 and to create a simple database.
> I have seen:
> - "$ postmaster" -> error: "root exection of PostgreSQL server is not permitted...."
> -"$ createdb mydb" -> error: "user 'root' does not exist. createdb: database createtion failed"
> (I login with user is "root")
> So, help me way to create a database!
> Thanks!
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, and more
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.

In response to

  • Help me! at 2003-02-27 02:54:36 from DangVan Chinh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-04 22:39:06 Re: Compilation errors when building TCL interface on HP-UX 11
Previous Message Martijn van Oosterhout 2003-03-04 22:35:39 Re: pg and chroot (performance)