Differences

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

--- postgresql_backup_recovery_logical [2020/06/18 08:03] – [Backup all roles and Users] 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====
@@ Line 64: / Line 80: @@
 drwxr-xr-x. 3 postgres postgres 4096 Mar 20 10:05 ..
 </sxh>
+====Migrate tables between databases====
+We can migrate tables between databases, given the structure is already there:
+<Code:bash|Migrate tables>
+pg_dump -Fc --data-only --table config --table config_properties wl_sportsbook | pg_restore --data-only -d wl_config
+</Code>
 ====Backup all roles and Users====