Backup Postgre Windows to Linux

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

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:

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

On Thu, 18 Oct 2001, Andrew Gould wrote:

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.

Ugh. If neccessary. Access will recast a lot of the data
into Access-centric field types and such.

If you had to that, it would be best to CREATE TABLEs on
the Linux directly or from a schema-only dump, and use
Access to populate the data only.

HTH,
--

Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant

On Thu, 18 Oct 2001, [iso-8859-1] Fl���vio Brito wrote:

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 .....

Yes, pg_dump and pg_dumpall call do this.

Can you post the exact command you are running (blank out any password or
hostname, etc.) and the exact error message you get?

--

Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant

Hi Joel,

I am using "pg_dumpall -h localhost -p 5432 > db.out"
When I try it on Windows its turns my printer on and freeze

Em Qui 18 Out 2001 20:05, you wrote:

On Fri, 19 Oct 2001, Fl�vio Brito wrote:

I am using "pg_dumpall -h localhost -p 5432 > db.out"
When I try it on Windows its turns my printer on and freeze

Ouch! What version of Windows are you using? I seem to recall that DOS &
Windows used to remap an interrupt (divide by zero? overflow?) to be a
printer interrupt, so certain fatal exceptions trapped by the hardware
would just start printing crap out on the printer inadvertently. I wonder
if this is still the case in newer versions of Windows?

-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
"All we are given is possibilities -- to make ourselves one thing or another."
-- Ortega y Gasset

Brett

I am using Windows 2000 Server

-----Mensagem original-----
De: Brett W. McCoy [mailto:bmccoy@chapelperilous.net]
Enviada em: sexta-feira, 19 de outubro de 2001 10:44
Para: Fl�vio Brito
Cc: pgsql-general@postgresql.org
Assunto: Re: [GENERAL] Backup Postgre Windows to Linux

On Fri, 19 Oct 2001, Fl�vio Brito wrote:

I am using "pg_dumpall -h localhost -p 5432 > db.out"
When I try it on Windows its turns my printer on and freeze

Ouch! What version of Windows are you using? I seem to recall that DOS &
Windows used to remap an interrupt (divide by zero? overflow?) to be a
printer interrupt, so certain fatal exceptions trapped by the hardware
would just start printing crap out on the printer inadvertently. I wonder
if this is still the case in newer versions of Windows?

-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
"All we are given is possibilities -- to make ourselves one thing or
another."
-- Ortega y Gasset