Re: Backup Postgre Windows to Linux

If all else fails, try to access the PostgreSQL
database from MS Access via ODBC. This would give you
some options to move/backup the data to Linux.

Best of luck,

Andrew Gould

--- Joel Burton <joel(at)joelburton(dot)com> wrote:
> On Thu, 18 Oct 2001, [iso-8859-1] Flvio Brito
> wrote:
>
> > Hi ALL
> >
> > I imported a database from Access 2000 to Postgre
> for Windows but now I can't
> > backup my database to export to Postgre for Linux
> .
> > I tried to use pg_dumpall > db.sql, its freeze on
> Windows2000 for more than a
> > hour. My database has 6 MB.
> >
> > I can backup my database directory on Windows
> (using ZIP) and put it on Linux?
>
> Might want to try pg_dump (rather than dumpall),
> perhaps even using the
> -t option to pick just one table. This could let us
> find out if you can
> dump *anything* or not.
>
> --
>
> Joel BURTON | joel(at)joelburton(dot)com |
> joelburton.com | aim: wjoelburton
> Independent Knowledge Management Consultant
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com