Re: installing tsearch 2 error no user "root"

Hi,

On Mon, 2005-12-19 at 02:25 +0800, David Ang wrote:
> -------------------
> [root(at)localhost tsearch2]# gmake installcheck
> gmake -C ../../src/test/regress pg_regress
> gmake[1]: Entering directory
> `/home/hstudy/postgresql-8.1.1/src/test/regress'
> gmake[1]: `pg_regress' is up to date.
> gmake[1]: Leaving directory `/home/hstudy/postgresql-8.1.1/src/test/regress'
> /bin/sh ../../src/test/regress/pg_regress --dbname=contrib_regression
> tsearch2
> (using postmaster on Unix socket, default port)
> ============== dropping database "contrib_regression" ==============
> dropdb: could not connect to database postgres: FATAL: role "root" does
> not exist
> ============== creating database "contrib_regression" ==============
> createdb: could not connect to database postgres: FATAL: role "root"
> does not exist
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You have to do the "gmake installcheck" as the postgres user (or let's
call it the user that you used to build postgres). But since root
execution PostgreSQL is not allowed, you get the error above.

So, run installcheck under a regular user. For details refer to
PostgreSQL Installation manual.

Regards,
-
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/