Hi,
We are using postgres 8.3 in Open Suse 11 server.
Front end - Java, struts
Middle ware - Jboss
Backend - Postgres 8.3 DB.
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.
Hariraman Jayaraj 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
>
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 sta
Tony Capobianco 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
Mitesh Shah 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 everythi