We are trying to select a database engine for a new product we plan to start developing. One of the requirements is to be able to ship the data on the media and install it on the user’s hard-drive.
One of the issues we’ve run into is that pg_restore takes a lot of time to restore large database.
Also, moving entire data directory is not an option since we will have multiple databases that user can choose to install.
We’ve tried to copy the database directory and it seems to work. Unfortunately we are not sure if there is any, not visible, damage to the data.
So, here is my question: Is it possible to:
1. Create a database
2. Stop postgres
3. Empty out the directory created by the new database
4. Copy files from another database (created on a different server) into that directory
5. Start postgres and use the database
Once this is completed we may need to repeat the process for another database.
Is this possible? If not, what are other options?
Any help or suggestions is greatly appreciated.
Thank you.