| From: | xujian <jamesxu(at)outlook(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | open database on read only file system |
| Date: | 2016-10-07 19:43:47 |
| Message-ID: | BAY181-W523DAD585129C574CC0E7DA1C60@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 systemLOCATION: mdopen, md.c:609===============
Does anyone know if there is anyway to run database on read-only file system? thanks
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Whitney | 2016-10-07 20:06:09 | Re: open database on read only file system |
| Previous Message | jvenegasperu . | 2016-10-07 15:11:17 | Re: [pgsql-es-ayuda] Pruebas de carga PostgreSQL vs SQLServer |