Sorry for CC to mailing list, I forgot!!
On 01/06/2004 11.35, Richard Huxton <[EMAIL PROTECTED]> wrote: >Please CC: the mailing list too, other people might have something > >useful to say. > >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. > But I stop the postgres service before to copy all the files, then the database is not running. The problem is that I use a backup tool that backup data from my server (MySql and Postgres databases included) in that way (I know pg_dump, I used it before) and afterwards it transfers the backup file (a kind of tar file) via FTP on another machine. Of course I can schedule it. My idea was to increment the protection of my db data. What about the external storage arrays? >> 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. > I already tried it and it works perfectly. >HTH >-- > Richard Huxton > Archonet Ltd > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
