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@joelburton.com> wrote:
> On Thu, 18 Oct 2001, [iso-8859-1] Fl�vio 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@joelburton.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