Move db files from one pgsql instance to another
От | Javier de la Torre |
---|---|
Тема | Move db files from one pgsql instance to another |
Дата | |
Msg-id | a0174d240608161104q43785937mf216f7bf8138956f@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Move db files from one pgsql instance to another
|
Список | pgsql-general |
Hi, I am working right now in an strategy to improve the performance on my server. The situation is this: I have a very large database that it is only update once a month, but when is updated I have to process a lot of things on the data to create caches, aditional tables, etc. The processing of the data can take up to 2 days in my machine so I was considering the following strategy. I have another machine that takes the new data, process it and when is done I replace the files from the production server with the ones of the processing server. In this way I avoid my production server to become really slow for 2 days every month. Does this sound reasonable? Am I going to find any trouble just moving the db files inside the data/base folder? I thought I would stop PostgreSQL, do the replacement of files, actually just changing a symbolyc link, and start the server again. I will only have my db stopped for 5 sec. once a month. Has anybody experince on something like this? Thanks in advance. Javier.
В списке pgsql-general по дате отправления: