Re: database transfer
От | Robert B. Easter |
---|---|
Тема | Re: database transfer |
Дата | |
Msg-id | 0101250449560I.08820@comptechnews обсуждение исходный текст |
Ответ на | database transfer ("Ronnie Esguerra" <resguerra@solidservice.com.ph>) |
Список | pgsql-general |
On Thursday 25 January 2001 03:46, Ronnie Esguerra wrote: > Hi, > > I will be moving my postgres database from one server to a new server. What > files do I need to move or how is it done? > > Ronnie pg_dumpall the whole database to a file (pg_dumpall > dumpfile). Assuming you use the PostgreSQL source code, configure and make postgres on the new machine and do the regress tests (src/test/regress). If it's good, make install, make postgres superuser unix account, then initdb as user postgres. Finally, restore your dumpfile with psql -e template1 < dumpfile (the way man pg_dumpall says to do it). I wouldn't try just copying files from one box to another (except your dumpfile). -- -------- Robert B. Easter reaster@comptechnews.com --------- -- CompTechNews Message Board http://www.comptechnews.com/ -- -- CompTechServ Tech Services http://www.comptechserv.com/ -- ---------- http://www.comptechnews.com/~reaster/ ------------
В списке pgsql-general по дате отправления: