+37
-0
lines changedFilter options
+37
-0
lines changed Original file line number Diff line number Diff line change
@@ -204,6 +204,43 @@ on the remote location as the local directory.
204
204
When files are encrypted and their unencrypted source is kept, only encrypted
205
205
files are uploaded.
206
206
207
+
## Restoring files
208
+
209
+
The following files are created:
210
+
211
+
* `pg_globals_{date}.sql`: definition of roles and tablespaces, dumped with
212
+
`pg_dumpall -g`. This file is restored with `psql`.
213
+
* `pg_settings_{date}.out`: the list of server parameters found in the
214
+
configuration files (9.5+) or in the `pg_settings` view. They shall be put
215
+
back by hand.
216
+
* `ident_file_{date}.out`: the full contents of the `pg_ident.conf` file,
217
+
usually located in the data directory.
218
+
* `hba_file_{date}.out`: the full contents of the `pg_hba.conf` file, usually
219
+
located in the data directory.
220
+
* `{dbname}_{date}.createdb.sql`: an SQL file containing the definition of the
221
+
database and parameters set at the database or "role in database" level. It
222
+
is mostly useful when using a version of `pg_dump` older than 11. It is
223
+
restored with `psql`.
224
+
* `{dbname}_{date}.{d,sql,dump,tar}`: the dump of the database, with a suffix
225
+
depending of its format. If the format is plain, the dump is suffixed with
226
+
`sql` and must be restored with `psql`. Otherwise, it must be restored with
227
+
`pg_restore`.
228
+
229
+
When checksum are computed, for each file described above, a text file of the
230
+
same name with a suffix naming the checksum algorithm is produced.
231
+
232
+
When files are encrypted, they are suffixed with `age` and must be decrypted
233
+
first, see the [Encryption] section above. When checksums are computed and
234
+
encryption is required, checksum files are encrypted and encrypted files are
235
+
checksummed.
236
+
237
+
To sum up, when restoring:
238
+
239
+
1. Create the roles and tablespaces by executing `pg_globals_{date}.sql` with `psql`.
240
+
2. Create the database with `{dbname}_{date}.createdb.sql` if necessary.
241
+
3. Restore the database(s) with `pg_restore` (use `-C` to create the database) or `psql`
242
+
243
+
207
244
## Managing the configuration file
208
245
209
246
The previous v1 configuration files are not compatible with pg_back v2.
You can’t perform that action at this time.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4