On Thursday 01 March 2007 17:35, Andrew Dunstan wrote: > Tom Lane wrote: > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >> Andrew Dunstan wrote: > >>> Hitting a file system quota limit is likely to bring you down pretty > >>> hard, isn't it? > >> > >> Yes, and likely corrupt the database. > > > > As long as you don't keep WAL on the restricted filesystem, it won't > > stop or corrupt your database. Whether you can get anything much done > > is another story :-( > > Yeah. Including recovery. Maybe we could do something that would work in > cooperation with FS quotas - I have no idea what though. >
I've actually run postgresql systems out of disk space both on data partitions and wal partitions and never suffered corruption. Certainly I don't recommend the practice, but pg can be amazingly resilient at times. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq