X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 40879D1E173 for ; Wed, 12 May 2004 08:44:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 22860-09 for ; Wed, 12 May 2004 08:43:56 -0300 (ADT) Received: from host4.ccw.gov.uk (host4.ccw.gov.uk [62.3.229.112]) by svr1.postgresql.org (Postfix) with ESMTP id 80B04D1E0D5 for ; Wed, 12 May 2004 08:43:52 -0300 (ADT) Received: from host3.ccw.gov.uk ([192.168.253.7] helo=host3.hq.ccw.gov.uk) by host4.ccw.gov.uk with esmtp (Exim 4.20) id 1BNrtC-0004Jd-I7 for pgsql-admin@postgresql.org; Wed, 12 May 2004 12:27:06 +0100 Received: from groupwise.ccw.gov.uk ([192.168.24.30]) by host3.hq.ccw.gov.uk with esmtp (Exim 4.14) id 1BNsQX-00052A-QG for pgsql-admin@postgresql.org; Wed, 12 May 2004 13:01:33 +0100 Received: from CCW_Gateways-MTA by groupwise.ccw.gov.uk with Novell_GroupWise; Wed, 12 May 2004 12:43:19 +0100 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.0.2 Date: Wed, 12 May 2004 12:43:08 +0100 From: "Gordon Ross" To: Subject: Problems dumping database from 7.3.1 Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/107 X-Sequence-Number: 13423 I've been using a PGSQL 7.3.1 system as my development box for some time, a= nd so far, it worked fine. (This is running on Slackware distro with a 2.2.= 19 kernel under VMWare 4) However, yesterday, I added a column to a base table (that is inherited by = several other tables). Shortly afterwards, whenever I tried to access eithe= r the base table or child tables, I get the message saying that pgsql has l= ost communication with the server. Assuming that I had stumbled across a bug, I decided to upgrade to 7.4.2. B= efore starting, I tried to do a pg_dump, and it failed. Again, it failed pa= rtway through, loosing the connection to the server. Below is the erorr I am getting gtg@Vmware1:~$ pg_dump -f /tmp/sw4.sql -U postgres switchboards pg_dump: connection not open pg_dump: lost synchronization with server, resetting connection pg_dump: SQL command to dump the contents of table "StaffMember" failed: PQ= endcopy() failed. pg_dump: Error message from server: FATAL: The database system is starting= up pg_dump: The command was: COPY public."StaffMember" ("Id", "ExDirectory", "= Name", "JobTitle", "Title", "FirstName", "MiddleInitial", "LastName", "Stat= us", "WelshSpeakingAbility", "JobTitleC", "OrgGroupID", "OtherNumber", "Pos= tNumber", "BandId", "JobDescE", "JobDescW", "EMailAddr", "NDSObject", "Sect= ionId", dnid) TO stdout; gtg@Vmware1:~$ The log file says that the server process was terminated by a signal 11, an= d it then restarts. Any ideas as to how I can bring my database back to life ? Thanks, GTG Gordon Ross, Network Manager/Rheolwr Rhydwaith Countryside Council for Wales/Cyngor Cefn Gwlad Cymru