Thread: BUG #7484: while restore database backup error is raised
The following bug has been logged on the website:
Bug reference: 7484
Logged by: sudhir
Email address: sudhir711@hotmail.com
PostgreSQL version: 9.1.4
Operating system: centos
Description:=20=20=20=20=20=20=20=20
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 832; 1255 1816123 FUNCTION
ad_column_identifier_ref_sql(character varying, character varying, character
varying, character varying, character varying) tad
pg_restore: [archiver (db)] could not execute query: server closed the
connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
On 08/08/2012 02:06 PM, sudhir711@hotmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 7484 > Logged by: sudhir > Email address: sudhir711@hotmail.com > PostgreSQL version: 9.1.4 > Operating system: centos > Description: > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 832; 1255 1816123 FUNCTION > ad_column_identifier_ref_sql(character varying, character varying, character > varying, character varying, character varying) tad > pg_restore: [archiver (db)] could not execute query: server closed the > connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > 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. It'd help to know your CentOS version, how you installed PostgreSQL, etc. Are you using any extensions? PostGIS? -- Craig Ringer
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 potential interest in this bug report would be any unusual or exceptionally large settings in postgresql.conf, is this a 32 bit or 64 bit install -- john r pierce N 37, W 122 santa cruz ca mid-left coast
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/lib/pgsql/9.1/data/pg_log
>
> other things of potential interest in this bug report would be any
> unusual or exceptionally large settings in postgresql.conf, is this a
> 32 bit or 64 bit install
Good point. Please show:
SELECT version()
and the output of this query:
http://wiki.postgresql.org/wiki/Server_Configuration
--
Craig Ringer
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 something. maybe add data_directory and config_file to it so it can be a one stop shop for info useful to help someone... -- john r pierce N 37, W 122 santa cruz ca mid-left coast