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

From Flávio Brito
Subject Re: Backup Postgre Windows to Linux
Date
Msg-id 01101817352000.01094@pegasus
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
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.

pgsql-general by date:

Previous
From: "Steve Brett"
Date:
Subject: Re: URGENT: Index problems - update - please help ....
Next
From: "Mark Coffman"
Date:
Subject: VACUUM vs VACUUM ANALYZE