Jim Michaels wrote:
> Q: does pgsql create data files using the filesystem and OS API, or does it
> try to write directly into NTFS without using the API?
We don't write to the FS directly, and I don't think we would change
that any time soon.
> because if it uses the API, I can down the server and back it up as an
> alternative, check the fs, etc.
Yes, you can do that and it works fine.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services