NMB Webmaster wrote:
It is for backup purpose. I thought that in this way I could backup only data and structure of all my databases from one machine without backuping the application files that would be on another machine.
The standard backup tool for PostgreSQL is pg_dump - this indeed just backs up the data. You should not rely on copying the files of a running database - that won't always work.
Moreover, if the application server crashes I do not miss my data.
Ah - I think I see what you're trying to do. It's quite common to have e.g. Apache+PHP/JBoss/etc on one machine and PostgreSQL on another. All that's required is to turn the tcp connection option on in PostgreSQL and change the connect string in the application.
Don't forget to update your pg_hba.conf to allow your application to connect from the remote machine too.
HTH -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
