Hi, On Mon, 2005-12-19 at 02:25 +0800, David Ang wrote: > ------------------- > [root@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/
