[freeside-devel] Invoice Details Lost after postgres migration

[Stephen D. Bechard]

What version of freeside are you running?
How large is the file that you dumped?

Have you tried doing another pg_dump of the
imported data and running a diff against the original?

You might be able to just manually pull in the
COPY Statements for each particular table if all
of the tables are intact...

Enjoy,
Steve

----- Original Message ----- 
From: "Gilbert Rebeiro" <gilbert at dido.ca>
To: <ivan-freeside-devel at sisd.com>; "'Scott Edwards'" <supadupa at gmail.com>
Sent: Friday, April 08, 2005 9:02 PM
Subject: RE: [freeside-devel] Invoice Details Lost after postgres migration


> I don't quite understand the structure (which table links to which table)
> for an invoice and the line details for an invoice.
> Maybe with this information I can figure out what is wrong.
>
> Thanks again in advance,
> Gilbert.
>
> -----Original Message-----
> From: Scott Edwards [mailto:supadupa at gmail.com]
> Sent: Friday, April 08, 2005 8:20 PM
> To: ivan-freeside-devel at sisd.com
> Subject: Re: [freeside-devel] Invoice Details Lost after postgres
migration
>
> On Apr 8, 2005 3:57 PM, Gilbert Rebeiro <gilbert at dido.ca> wrote:
> > Hi all,
> >    Recently due to a failure had to restore my postgres database on a
> > new server and re-install freeside.
> >    I used pg_dump to do the backup and then used pgsql
> > freeside<file.sql to restore the database.
>
> I've always maintained binary backups via rsync+ssh.  I also have atleast
2
> full generations in the event a backup is somewhat incomplete or the
second
> half of the job is too new for the first half (takes time to download all
> the data).  postgres' documentation stated somewhere (or maybe it was a
> user) that you can do in place backups while the daemon is running, as
long
> as your db activity is real light (and mine is).  The best approach would
be
> to backup while postgres isn't running. (maybe I'll create a wrapper for
> rsync to do just this, so postgres goes down while backups are running,
and
> comes back up after it's done).
>
> I've had some success with #postgresql on freenode.  Maybe a guru will
have
> some clues as to what's happened to your data...  I take it you only have
> the text dumps of the database?
>
> > I'm a dead duck :)
>
> oops!
>
> >
> > Thanks in advance,
> > Gilbert.
> >
> >
>
> Thank you,
>
>
> Scott Edwards
> --
> Daxal Communications - http://www.daxal.com Surf the USA -
> http://www.surfthe.us
>
>