rigacci.org

User Tools

Site Tools

Trace:
doc:appunti:linux:sa:postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
doc:appunti:linux:sa:postgresql [2011/02/18 19:02] – [Lavorare con gli schemi] niccolodoc:appunti:linux:sa:postgresql [2012/11/09 09:54] – [Dump degli utenti (ruoli)] niccolo
Line 120: Line 120:
 </code> </code>
  
 +This is an example of dump from an 8.4 cluster into a 9.1 cluster:
 +
 +<code>
 +pg_dumpall --cluster 8.4/main --clean --globals-only > globals-8.4.dump
 +psql --cluster 9.1/main < globals-8.4.dump
 +</code>
 ===== Backup e restore selettivo ===== ===== Backup e restore selettivo =====
  
Line 235: Line 241:
 <code sql> <code sql>
 SELECT setval('table_column_seq', 1, false); SELECT setval('table_column_seq', 1, false);
 +</code>
 +
 +Anche questo comando imposta il prossimo valore usato da una sequenza:
 +
 +<code sql>
 +ALTER SEQUENCE table_column_seq RESTART WITH 632;
 </code> </code>
  
doc/appunti/linux/sa/postgresql.txt · Last modified: 2017/11/14 17:40 by niccolo