Re: PostgreSQL Database Transfer between machines(again)

Поиск
Список
Период
Сортировка
От Brian J. Erickson
Тема Re: PostgreSQL Database Transfer between machines(again)
Дата
Msg-id 000e01c6e8b7$968278b0$4700a8c0@p000014
обсуждение исходный текст
Ответ на Storing images in PostgreSQL databases (again)  (TIJod <tijod@yahoo.fr>)
Ответы Re: PostgreSQL Database Transfer between machines(again)  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: brian
Дата:
Сообщение: Re: trouble with setof record return
Следующее
От: Hugo
Дата:
Сообщение: how to check SQLSTATE