Differences

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

--- postgresql_backup_recovery_logical [2020/08/28 13:24] – andonovj
+++ postgresql_backup_recovery_logical [2021/06/24 09:51] (current) – andonovj
@@ Line 9: / Line 9: @@
   * Particular Database
   * All roles and privileges
+====Globals====
+To be sure that there won't be any problems, we can dump all roles within the cluster as follows:
+<Code:bash|Dump all roles>
+-bash-4.2$ pg_dumpall -p 5432 -v --roles-only -f "/var/lib/pgsql/migrationToDev/roles.sql"
+**********************************************************
+</Code>
+This will generates us a file called roles.sql in the mentioned directory which we can execute on the destination server.
+if you want to generate a dump also for the tablespaces use the following:
+<Code:bash|Dump all globas>
+-bash-4.2$ pg_dumpall -p 5432 -v --globals-only -f "/var/lib/pgsql/migrationToDev/globals.sql"
+</Code>
 ====Particular Database====