Re: Fw: [osdldbt-general] Running DBT5 on remote database server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 7/22/13 10:13 PM, amul sul wrote:
I want test the PostgreSQL performance using DBT5, where my PostgreSQL
running on server (say 192.168.56.101) and want to test the performance
executing DBT5 on other machine (say 192.168.56.102).

You can do this.  Here's the help for the run_workload.sh command:

usage: run_workload.sh -c <number of customers> -d <duration of test> -u <number of users>
other options:
       -a <pgsql>
       -b <database parameters>
       -f <scale factor. (default 500)>
       -h <database host name. (default localhost)>
...

"-h" is the setting that points toward another server. You will also need to setup the postgresql.conf and pg_hba.conf on the system to allow remote connections, the same way as this is normally done with Postgres.

--
Greg Smith   2ndQuadrant US    greg@xxxxxxxxxxxxxxx   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com


--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux