A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://github.com/orgrim/pg_back/commit/ab0a56731859ce06b3421377c8bd4765cc371e4e below:

give information on how to restore · orgrim/pg_back@ab0a567 · GitHub

File tree Expand file treeCollapse file tree 1 file changed

+37

-0

lines changed

Filter options

Expand file treeCollapse file tree 1 file changed

+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