Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-08 Thread John R Pierce
On 08/07/12 11:58 PM, Craig Ringer wrote: Good point. Please show: SELECT version() and the output of this query: http://wiki.postgresql.org/wiki/Server_Configuration that query is useful enough that it probably should be a built in function select server_configuration(); or somet

Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread Craig Ringer
On 08/08/2012 02:54 PM, John R Pierce wrote: On 08/07/12 11:10 PM, Craig Ringer wrote: Please examine the PostgreSQL server logs for error details. I think they're in /var/lib/pgsql/data/pg_log on CentOS, as that's where they are on Fedora. the PGDG rpm/yum repo of 9.1 defaults logs to /var

Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread John R Pierce
On 08/07/12 11:10 PM, Craig Ringer wrote: Please examine the PostgreSQL server logs for error details. I think they're in /var/lib/pgsql/data/pg_log on CentOS, as that's where they are on Fedora. the PGDG rpm/yum repo of 9.1 defaults logs to /var/lib/pgsql/9.1/data/pg_log other things of pot

Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread Craig Ringer
On 08/08/2012 02:06 PM, sudhir...@hotmail.com wrote: The following bug has been logged on the website: Bug reference: 7484 Logged by: sudhir Email address: sudhir...@hotmail.com PostgreSQL version: 9.1.4 Operating system: centos Description: pg_restore: [archiver (db)] Erro

[BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread sudhir711
The following bug has been logged on the website: Bug reference: 7484 Logged by: sudhir Email address: sudhir...@hotmail.com PostgreSQL version: 9.1.4 Operating system: centos Description: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (