Knowledgebase Support HMRC Useful links
Knowledgebase home
Tax Return Production
Accounts Production
Practice Management
VAT Filer
CloudConnect
Anti-Money Laundering
Support home
Video Training Guides
NEW

Hot Topics
SimpleStep Guides
Release Notes
Technical
Known Issues

HMRC Status
Useful Links
MTD for Agents MTD for Businesses What is MTD
Preparation
Agent Services Account
MTD for VAT
MTD for Income Tax
MTD for VAT
Digital Record Keeping
Quarterly Updates
Step-by-step Guide
HMRC's MTD Timeline
TaxCalc's MTD Journey

Can I store the Postgres database on a remote drive or NAS box?

Article ID: 2023
Last updated: 06 Jan, 2017

Storing the database on a remote drive or on a Network attached Storage (NAS) device is not supported by Taxcalc. The data should be on the same device as the one where the Postgres Service is running. Any other configuration is outside the scope for support by TaxCalc. 

NFS (Network File System) and other remote file systems are not recommended for use by PostgreSQL. They do not have the same file system characteristics as a local file system, and these inconsistencies can cause data reliability or crash recovery problems.

Instead TaxCalc recommends keeping the database local and making your backups to the network drives through the backup utility in Hub > Administration > Database or automating backups through the use of batch files and task scheduler.

If you wish to automate backups, TaxCalc have written an introduction on doing this for the network version of the program. See the Knowledge Base article Automatic backup of TaxCalc on a server for more information.

Article ID: 2023
Last updated: 06 Jan, 2017
Revision: 6
Views: 2815
This article was:  


Also read
item Automatic backup of TaxCalc on a server

Also listed in
folder Technical -> Database Related