Re: [ADMIN] unexpected EOF on client connection / could not send data to client: Broken pipe
Hariraman Jayaraj hariraman@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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] grant select pg 9.0.3
Tony Capobianco tcapobia...@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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Re: [BUGS] pg_dump: aborting because of server version mismatch
Mitesh Shah mitesh.s...@stripes39.com wrote: *pg_dump: server version: 9.1.2; pg_dump version: 9.0.5* *pg_dump: aborting because of server version mismatch* This is not a bug. Use a version of pg_dump which is at least as new as the server. The older version of pg_dump is unlikely to be able to recognize everything in the newer server, -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin