|
Hi,
Could you please let me know if it is possible to open database on read-only file system? I have a psotgresql 9.6 cluster, PGDATA folder is on READ-WRITE volume(system volume), user database is created on a table space which is located on another volume(data volume). Now we set the data volume to read only mode, before we changed the mode, I also disabled the auto vacuum, run checkpoint, and vacuum free. We reboot the service, everything was fine until we tried to access the database. =============== postgres=# \c userdb; FATAL: could not open file "pg_tblspc/16384/PG_9.6_201608131/16468/2662": Read-only file system =============== we enabled the debug mode, in log file, we saw =============== FATAL: 42501: could not open file "pg_tblspc/16384/PG_9.6_201608131/16468/2662": Read-only file system LOCATION: mdopen, md.c:609 =============== Does anyone know if there is anyway to run database on read-only file system? thanks James |
