Skip to Content.
Sympa Menu

en - Re: [sympa-users] Postgres upgrade trouble

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Michelle Murrain <address@concealed>
  • To: address@concealed
  • Subject: Re: [sympa-users] Postgres upgrade trouble
  • Date: Mon, 26 May 2003 14:00:19 -0400

At 11:57 AM -0400 5/26/03, Michelle Murrain wrote:
Hi Folks,

I run sympa on a debian testing box. I did an upgrade last night that included a major upgrade of postgres (in this case, there is a change of database file format, so it's a bigger deal than usual). I was upgrading a bunch of boxes at the same time, and wouldn't you know it, the only table that didn't restore properly of all of the databases on all of the boxes was one sympa table, on the one box that I'd forgotten to do my own backup dump of before hand.

Anyway, the sympa subscribers_table is missing. The user_table is present. The odd thing was that the table is present, but all the data is missing.

So, this is the question: is there any way anyone can think of to restore the subscribers_table? I've sent an email to the debian package maintainer for postgres, but I wondered if anyone here had any suggestions on what to do. Luckily, I seem to have all the user data, but the subscriber data seems to be toast.

Well, I've partially have a solution: 1) It turns out I did have a backup of the database dump (PHEW). But, the problem is that somehow, during the upgrade, I used the wrong date format for the database - so that when I try to restore the old data - it barfs telling me the timestamp is wrong.

So this is now my question - unless I find out some other info sooner, I'm going to use a script to create new insert strings. If I omit the datestamp (this is date_subscriber and update_subscriber fields) am I going to break anything?

Thanks again!

Michelle Murrain, Technology Consulting
tech at murrain dot net
413-253-2874 ph
413-222-6350 cell
413-825-0288 fax
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575
SMS: 4132226350 at messaging dot sprintpcs dot com

"I am determined to cultivate only thoughts that increase trust and love, to use my hands to perform only deeds that build community, to speak only words of harmony and aid." - Thich Nhat Hanh

Archive powered by MHonArc 2.6.19+.

Top of Page