The mailing list for listmasters using Sympa

[Michelle Murrain <address@concealed>]

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

--------------------------
Michelle Murrain, Technology Consulting
tech at murrain dot net     http://www.murrain.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