Re: Backup Postgre Windows to Linux

Dear Joel

When I try it I recieve a erro . Cannot conect .... but it on air. I tested
by pgAdmin

More suggestions? There is no way to export structure and data using  SQL,
like this?

CREATE table .....

INSERT INTO .....

Thanks again

Flávio Brito
Rio de Janeiro
Brasil


Em Qui 18 Out 2001 15:53, Joel Burton escreveu:
> 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.