Re: Backup Postgre Windows to Linux - Mailing list pgsql-general

From Andrew Gould
Subject Re: Backup Postgre Windows to Linux
Date
Msg-id 20011018211209.98516.qmail@web13404.mail.yahoo.com
Whole thread Raw
In response to Re: Backup Postgre Windows to Linux  (Joel Burton <joel@joelburton.com>)
Responses Re: Backup Postgre Windows to Linux  (Joel Burton <joel@joelburton.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Russ McBride
Date:
Subject: Re: drop column
Next
From: Alex Pilosov
Date:
Subject: Re: creating a custom server