From: Gordon Ross <G.Ross@ccw.gov.uk>
To: pgsql-admin@postgresql.org
Subject: Problems dumping database from 7.3.1
Date: Wed, 12 May 2004 12:43:08 +0100
Message-ID: <s0a21be7.090@groupwise.ccw.gov.uk> (raw)
I've been using a PGSQL 7.3.1 system as my development box for some time, and 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 either the base table or child tables, I get the message saying that pgsql has lost communication with the server.
Assuming that I had stumbled across a bug, I decided to upgrade to 7.4.2. Before starting, I tried to do a pg_dump, and it failed. Again, it failed partway 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: PQendcopy() 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", "Status", "WelshSpeakingAbility", "JobTitleC", "OrgGroupID", "OtherNumber", "PostNumber", "BandId", "JobDescE", "JobDescW", "EMailAddr", "NDSObject", "SectionId", dnid) TO stdout;
gtg@Vmware1:~$
The log file says that the server process was terminated by a signal 11, and 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: G.Ross@ccw.gov.uk
Subject: Re: Problems dumping database from 7.3.1
In-Reply-To: <s0a21be7.090@groupwise.ccw.gov.uk>
References: <s0a21be7.090@groupwise.ccw.gov.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox