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


Ignore:
Timestamp:
May 11, 2016, 1:46:02 PM (6 years ago)
Author:
Grip Uqam
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • members/GRIP-UQAM

    v136 v137  
    145145$ pg_restore --verbose --no-owner --no-privileges --dbname=<database name> <file name (.data)>
    146146}}}
     147* Mark cache tables as {{{UNLOGGED}}} Postgres <= 9.4 (Debian 8.0 Jessie)
     148{{{#!sh
     149...=> \d name
     150...
     151...=> CREATE UNLOGGED TABLE toto (id serial, ...);
     152}}}
     153  * http://www.postgresql.org/docs/9.4/static/sql-createtable.html
     154  * It is easier to get schema from pgAdmin III
     155* Mark cache tables as {{{UNLOGGED}}} Postgres >= 9.5
     156{{{#!sql
     157ALTER TABLE name SET UNLOGGED;
     158}}}
     159  * http://www.postgresql.org/docs/current/static/sql-altertable.html
    147160* {{{-E}}} or {{{--echo-hidden}}} See SQL requests send by {{{psql}}} for commands like {{{\l}}} ({{{\list}}})
    148161{{{#!sh