With WAL (Write-Ahead-Logging) enabled in SQLite 3.7 (which is the default for Core Data on iOS 7), how do I merge/commit the content from the -wal file back into the main database file?

On a running PostgreSQL 13 instance, I tried modifying it's wal_level system setting as follows, but it's not being respected: postgres@localhost:postgres> SHOW wal_level +-------------+ | wal_l...

Current situation So I have WAL archiving set up to an independent internal harddrive on a data logging computer running Postgres. The harddrive containing the WAL archives is filling up and I'd l...

Summary We are using max_slot_wal_keep_size from Postgresql 13 to prevent master from being killed by a lagging replication. It seems, that in our case, WAL storage wasn't freed up after exceeding ...

As far as I understood WAL archiving is pushing the WAL logs to a storage place as the WAL files are generated Incremental backup is pushing all the WAL files created since the last backup So, as...

Is there a way to disable WAL replay on crash for Prometheus? It takes a while for a pod to come back up due to WAL replay: We can afford to lose some metrics if it meant faster recovery after the ...

I have a strange problem with Core Data in an iOS app where sometimes the WAL file becomes huge (~1GB). It appears there are other people with the problem (e.g. Core Data sqlite-wal file gets MASSI...

In Android Pie sqlite Write-Ahead logging (WAL) has been enabled by default. This is causing errors for my existing code only in Pie devices. I have been unable to turn off WAL successfully using S...

I've been reading through the WAL chapter of the Postgres manual and was confused by a portion of the chapter: Using WAL results in a significantly reduced number of disk writes, because only th...

https://developer.apple.com/library/ios/releasenotes/DataManagement/WhatsNew_CoreData_iOS/ I am having trouble in disabling journal mode. My code is: static NSManagedObjectContext *managedObjectCon...

I am writing continuously into a db file which has PRAGMA journal_mode=WAL, PRAGMA journal_size_limit=0. My C++ program has two threads, one reader(queries at 15 sec intervals) and one writer(inser...

Let's say I made a quick backup dump of my Postgres 9.3 DB through pg_dump before doing a large destructive migration and I discovered I want to undo it. No writes were performed against the DB in ...

Is there a way to specify files by age or date instead of by a hardcoded name to cleanup the WAL archives with the pg_archivecleanup command ? For example, using the following command is pretty st...

In C#, how to open an SQLite connection in WAL mode? Here is how I open in normal mode: SQLiteConnection connection = new SQLiteConnection("Data Source=" + file); connection.Open(); // (Perform m...