I installed nominatim in local machine, now i needs to install in server machine at the same time i dont want to again start installation process in that server machine.

In steed i just wants to transfer the data from local to server, because it is faster.

Is it possible, plz guide me right way.

asked 12 Feb '14, 06:13

Arun%20kmp's gravatar image

Arun kmp
63141519
accept rate: 0%

edited 12 Feb '14, 06:15


The fastest way to do this is to copy over the whole PostgreSQL data directory to the target machine. This only works if both machines have the same CPU architecture and the exact same versions of PostgreSQL, PostGIS and some related packages (GDAL and Proj come to mind).

The second-fastest way is likely to take a PostgreSQL database dump on the source and restore it on the target (pg_dump, pg_restore) but this requires rebuilding indexes on the target.

permanent link

answered 12 Feb '14, 07:08

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
71.3k846451113
accept rate: 24%

See http://www.postgresql.org/docs/current/static/backup.html

Unless you want to get the disk space back in the old server, it might be a good idea to set streaming replication from the fast server to the slow one. It's not much more difficult than a filesystem-level copy, you gain resiliency in case the fast server has a problem, and you have an additional server to run read-only queries from to balance the load.

(12 Feb '14, 11:09) Vincent de P... ♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×558
×551
×9
×6

question asked: 12 Feb '14, 06:13

question was seen: 2,746 times

last updated: 12 Feb '14, 11:11

powered by OSQA