Re: database system identifier differs between the primary and standby

Any public dataset for benchmarking?

Hi all,

I'm asked to benchmark a PG-related product. I was wondering if there
is any "sort of standard" public dataset for such operations. The one
and only limit I have is I cannot use triggers with this product
(otherwise I'd use a copy of our own production datasets and everyone
would be happy, but this is the life...).

All suggestions welcome
Bèrto

-- 
==============================
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and listening to repetitive music.

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Any public dataset for benchmarking?

Bèrto ëd Sèra wrote:

> I'm asked to benchmark a PG-related product. I was wondering if
> there is any "sort of standard" public dataset for such operations.

You might want to take a look at pgbench:

http://www.postgresql.org/docs/9.1/interactive/pgbench.html

-Kevin

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Any public dataset for benchmarking?

Bèrto ëd Sèra wrote on 01.05.2012 11:13:
> Hi all,
>
> I'm asked to benchmark a PG-related product. I was wondering if there
> is any "sort of standard" public dataset for such operations. The one
> and only limit I have is I cannot use triggers with this product
> (otherwise I'd use a copy of our own production datasets and everyone
> would be happy, but this is the life...).
>

Have a look at the DellStore2 benchmark suite

http://linux.dell.com/dvdstore/

it supports PostgreSQL (since last year) and generating the dataset is quite straighforward - although I
couldn't get the actual benchmark program to run on Windows.

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

unexpected EOF on client connection / could not send data to client: Broken pipe

Re: unexpected EOF on client connection / could not send data to client: Broken pipe

Hariraman Jayaraj <hariraman.ocp <at> gmail.com> wrote:

> We are using postgres 8.3 in Open Suse 11 server.
> Front end - Java, struts
> Middle ware - Jboss
> Backend - Postgres 8.3 DB.

It helps to know the exact version number and PostgreSQL
configuration settings.

http://wiki.postgresql.org/wiki/Server_Configuration

> Recently I am encoutering below mentioned error. Also by the time
> this error occuring, Linux server / Postgres Server is too slow
> and at times it is not responding at all.

Can you run `vmstat 1` while things are slow?  It sounds like you
might be getting into heavy swapping due to memory over-commit.  Can
you show us the result of running `free -m`?

> 2012-05-02 12:14:09 IST LOG:  unexpected EOF on client connection
> 2012-05-02 12:14:09 IST LOG:  unexpected EOF on client connection
> 2012-05-02 12:14:09 IST LOG:  unexpected EOF on client connection
> 2012-05-02 12:14:10 IST LOG:  unexpected EOF on client connection
> 2012-05-02 12:14:11 IST LOG:  unexpected EOF on client connection
> 2012-05-02 12:14:11 IST LOG:  unexpected EOF on client connection
> 2012-05-02 12:14:12 IST LOG:  unexpected EOF on client connection
> 2012-05-02 12:14:12 IST LOG:  unexpected EOF on client connection
> 2012-05-02 12:14:13 IST LOG:  could not send data to client:
> Broken pipe

Those messages mean that the TCP connection from the client was
broken by something other than the PostgreSQL server.

-Kevin

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

grant select pg 9.0.3

I've issued the following statement:

grant select on all tables in schema support to backup;

When I perform a pgdump of the support schema with the backup user it
works fine.  If I create a new table within the support schema, pgdump
fails on the support schema.  To rectify, I issue the grant statement
again.  How can I avoid having to issue the grant each time I create a
new table?

Thanks.
Tony

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: grant select pg 9.0.3

Tony Capobianco <tcapobianco <at> prospectiv.com> wrote:
> I've issued the following statement:
> 
> grant select on all tables in schema support to backup;
> 
> How can I avoid having to issue the grant each time I create a new
table?

http://www.postgresql.org/docs/9.0/interactive/sql-alterdefaultprivileges.html

Also, please consider updating to 9.0.7.

http://www.postgresql.org/support/versioning/

-Kevin

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

postgresql stream replication question

Re: postgresql stream replication question

On Thu, 2012-05-03 at 13:47 +0800, sgm wrote:
> I have successfully set up the stream replication M1--IP1, M2---IP2,
> my question is if the master is down, the slave will become read and
> write by trigger file, but the client will connect to the IP2,right?

No. You will need something else (like Red Hat Cluster Suite) for that.

Regards,
--

-- 
Devrim GÜNDÜZ
Principal Systems Engineer  <at>  EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz