Re: PostgreSQL Database Transfer between machines(again) - Mailing list pgsql-general

From Brian J. Erickson
Subject Re: PostgreSQL Database Transfer between machines(again)
Date
Msg-id 000e01c6e8b7$968278b0$4700a8c0@p000014
Whole thread Raw
In response to Storing images in PostgreSQL databases (again)  (TIJod <tijod@yahoo.fr>)
Responses Re: PostgreSQL Database Transfer between machines(again)
List pgsql-general
>> Problem:
>> PostgreSQL "Service" is not runing on a Linux Box,
> Why not?
The file "/etc/mtab" has been corrupted, when start
postgresql the "Service" dies because of an "input/output"
error.

Therefore, "pg_dumpall' won't work.


----- Original Message -----
From: "Andreas Kretschmer" <akretschmer@spamfence.net>
To: <pgsql-general@postgresql.org>
Sent: Thursday, October 05, 2006 8:52 AM
Subject: Re: [GENERAL] PostgreSQL Database Transfer between machines(again)


Brian J. Erickson <ericksbr@infocon-inc.com> schrieb:

> I appologize for duplicate posting, but I am not sure
> if this is getting posted to the news group.
>
> Problem:
> PostgreSQL "Service" is not runing on a Linux Box,

Why not?


> but I have a database on the Linux Box, that I want
> to relocate to another machine, Windows or Linux.
>
> Question:
> What files do I need to transfer to get this to work?

Start the database, do a pg_dumpall, and build on the new machine the db
from this dump.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly



pgsql-general by date:

Previous
From: brian
Date:
Subject: Re: trouble with setof record return
Next
From: Hugo
Date:
Subject: how to check SQLSTATE