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)
|
Список | 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 по дате отправления: