Re: instructions on pgtap

[David E. Wheeler]

Hi Tyson,

Cc’ing the PGXN users list.

On May 9, 2013, at 5:45 AM, Tyson Maly <tvm...@yahoo.com> wrote:

> I was not sure if this was the best email address to use for this question.
>
> The instructions state:
>
> If you encounter an error such as:
> ERROR: must be owner of database regression
>
> You need to run the test suite using a super user, such as the default "postgres" super user:
> make installcheck PGUSER=postgres
>
>
>
> However, when I run them as such as root I get the following error
>
> command failed: "/usr/lib/postgresql/9.2/bin/psql" -X -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
> make: *** [installcheck] Error 2
> root@bondying:~/src/pgtap# psql -U postgres template1
> psql: FATAL: Peer authentication failed for user "postgres"
>
> The instructions did not provide a work around for this.
>
> I can connect to the database as root on the commandline using
>
> su psql -U postgres template1
>
> And I checked the pg_hba.conf file and I did not see anything wrong, its just that I cannot connect as one user while logged in as another.
>
> What would be the way to get the following command to work
>
> make installcheck PGUSER=postgres

What extension are you trying to install?

Best,

David