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@svana.org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.