pg_dumpall examples may lead to encoding problems

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)postgresql(dot)org
Cc: adamgauthier12(at)gmail(dot)com
Subject: pg_dumpall examples may lead to encoding problems
Date: 2017-12-27 09:47:04
Message-ID: 20171227094704.826.12723@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/app-pg-dumpall.html
Description:

The example to dumb all databases at the bottom of the page &quot;pg_dumpall &gt;
db.out&quot; works, but I think it would be better to suggest &quot;pg_dumpall -f
db.out&quot; instead, as it uses the database&#39;s encoding for the db.out file.
Using the current example on Windows led to the db.out file being in the
wrong encoding and not working to restore the database.

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2017-12-27 20:07:02 Re: remove endterms and title ids
Previous Message PG Doc comments form 2017-12-26 12:10:54 Rolycore