Changes between Version 136 and Version 137 of members/GRIP-UQAM

Timestamp:

May 11, 2016, 5:46:02 PM (8 years ago)

Author:

Grip Uqam

Comment:

--

members/GRIP-UQAM

@@ -145 +145 @@
 $ pg_restore --verbose --no-owner --no-privileges --dbname=<database name> <file name (.data)>
 }}}
+* Mark cache tables as {{{UNLOGGED}}} Postgres <= 9.4 (Debian 8.0 Jessie)
+{{{#!sh
+...=> \d name
+...
+...=> CREATE UNLOGGED TABLE toto (id serial, ...);
+}}}
+  * http://www.postgresql.org/docs/9.4/static/sql-createtable.html
+  * It is easier to get schema from pgAdmin III
+* Mark cache tables as {{{UNLOGGED}}} Postgres >= 9.5
+{{{#!sql
+ALTER TABLE name SET UNLOGGED;
+}}}
+  * http://www.postgresql.org/docs/current/static/sql-altertable.html
 * {{{-E}}} or {{{--echo-hidden}}} See SQL requests send by {{{psql}}} for commands like {{{\l}}} ({{{\list}}})
 {{{#!sh