Re: [GENERAL] Separating application from data

2004-06-01 Thread Richard Huxton
NMB Webmaster wrote: Sorry for CC to mailing list, I forgot!! No problem, I do sometimes. Then on other lists, I do it when I shouldn't. 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 wo

Re: [GENERAL] Separating application from data

2004-06-01 Thread NMB Webmaster
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 dat

Re: [GENERAL] Separating application from data

2004-06-01 Thread Richard Huxton
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

Re: [GENERAL] Separating application from data

2004-06-01 Thread Richard Huxton
Ago wrote: Is it possible to put the data and structure files of Postgres (tables, views, indicies, sequences and so on) on another machine than that one where system files are? In other words I want to put only the system and application files on one server and only the structure and data files on

[GENERAL] Separating application from data

2004-05-31 Thread Ago
Is it possible to put the data and structure files of Postgres (tables, views, indicies, sequences and so on) on another machine than that one where system files are? In other words I want to put only the system and application files on one server and only the structure and data files on another