Re: Backup Postgre Windows to Linux

Поиск
Список
Период
Сортировка
От Flávio Brito
Тема Re: Backup Postgre Windows to Linux
Дата
Msg-id 01101817352000.01094@pegasus
обсуждение исходный текст
Ответ на Re: Backup Postgre Windows to Linux  (Joel Burton <joel@joelburton.com>)
Ответы Re: Backup Postgre Windows to Linux  (Joel Burton <joel@joelburton.com>)
Список 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 по дате отправления:

Предыдущее
От: "Steve Brett"
Дата:
Сообщение: Re: URGENT: Index problems - update - please help ....
Следующее
От: "Mark Coffman"
Дата:
Сообщение: VACUUM vs VACUUM ANALYZE