Re: [GENERAL] general questions on Postgresql and deployment on

2004-12-03 Thread Doug McNaught
Calvin Wood <[EMAIL PROTECTED]> writes: > symbolic link. But on win32, there is no equivalent. However, even under > *nix system, I believe symbolic link can only be created for directories on > the same hard drive. This seems less than optimal. Typically, one would > place database files on RA

Re: [GENERAL] general questions on Postgresql and deployment on win32 platform

2004-12-03 Thread Magnus Hagander
> I have gone through the documentation that come with version > 8 beta 4 and I have a number of questions. > > (1) backup/restore > I notice that in the documentation, it seems to suggest that > an online backup, made via pg_start_backup() and > pg_stop_backup() functions would back up all dat

Re: [GENERAL] general questions on Postgresql and deployment on win32

2004-12-03 Thread Richard Huxton
Calvin Wood wrote: Does it also mean that I must back up and restore all the databases (or database cluster in Postgresql Speak) even if I am only interested in 1 database? You can use pg_dump to backup individual databases (or tables etc). A file-level backup does require all databases in one "

[GENERAL] general questions on Postgresql and deployment on win32 platform

2004-12-02 Thread Calvin Wood
I have gone through the documentation that come with version 8 beta 4 and I have a number of questions. (1) backup/restore I notice that in the documentation, it seems to suggest that an online backup, made via pg_start_backup() and pg_stop_backup() functions would back up all databases running