From: | Erik Rijkers <er(at)xs4all(dot)nl> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | pgbench confused between service + PGPORT |
Date: | 2016-03-17 21:16:45 |
Message-ID: | e83918c316a773ace4b6a3cc13fac417@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I noticed that pgbench gets confused about what instance to connect to
when there is both a service *and* an PGPORT given.
I can avoid it rather easily but I report it as it looks like a bug to
me; I can't think of a reason why it might be deliberate behaviour.
Below is a test case where:
instance 9.5 and 9.6 have
database testdb95 and testdb96, and
services '95' and '96'.
$ cat benchservice.sh
# wipe out PG* variables
unset PGSERVICEFILE PGSERVICE PGPORT PGDATA PGHOST PGDATABASE PGPASSFILE
export PGSERVICEFILE=$HOME/.pg_service.conf PGSERVICE=95
PGPASSFILE=$HOME/.pg_aardvark
cat $PGSERVICEFILE
env | grep PG
which pgbench
pgbench --version
# these two calls to pgbench are OK (PGPORT is unset)
pgbench -qis 1 "service=95"
pgbench -qis 2 "service=96"
# just to show that both calls succeeded, and in the right database:
echo 'show port; \dt+ pgbench_accounts' | psql -X "service=95"
echo 'show port; \dt+ pgbench_accounts' | psql -X "service=96"
# now, with PGPORT set to the 9.6 instance, the same pgbench invocation
(with a service) will fail:
export PGPORT=6546
pgbench -qis 1 "service=95"
#--------------------------
And its output:
$ ./benchservice.sh
[96]
port=6546
host=/tmp
user=aardvark
dbname=testdb96
[95]
port=6545
host=/tmp
user=aardvark
dbname=testdb95
PGSERVICEFILE=/home/aardvark/.pg_service.conf
PGSERVICE=95
PGPASSFILE=/home/aardvark/.pg_aardvark
/opt/pgsql95/bin/pgbench
pgbench (PostgreSQL) 9.5.1
creating tables...
100000 of 100000 tuples (100%) done (elapsed 0.11 s, remaining 0.00 s)
vacuum...
set primary keys...
done.
creating tables...
200000 of 200000 tuples (100%) done (elapsed 0.25 s, remaining 0.00 s)
vacuum...
set primary keys...
done.
port
------
6545
(1 row)
List of relations
Schema | Name | Type | Owner | Size | Description
--------+------------------+-------+----------+-------+-------------
public | pgbench_accounts | table | aardvark | 13 MB |
(1 row)
port
------
6546
(1 row)
List of relations
Schema | Name | Type | Owner | Size | Description
--------+------------------+-------+----------+-------+-------------
public | pgbench_accounts | table | aardvark | 26 MB |
(1 row)
connection to database "service=95" failed:
FATAL: database "testdb95" does not exist
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2016-03-17 22:52:25 | Re: [HACKERS] pgbench -C -M prepared gives an error |
Previous Message | cpacejo | 2016-03-17 21:05:40 | BUG #14030: BRIN doc bug |