Re: requests / suggestions to help with backups - Mailing list pgsql-general

From Tom Lane
Subject Re: requests / suggestions to help with backups
Date
Msg-id 9011.1171601164@sss.pgh.pa.us
Whole thread Raw
In response to Re: requests / suggestions to help with backups  (Erik Jones <erik@myemma.com>)
List pgsql-general
Erik Jones <erik@myemma.com> writes:
> Lou Duchez wrote:
>> 2) "pg_dumpall -E". If I could specify a single encoding for all my
>> database dumps, I could use pg_dumpall.

> I guess you missed this:
> http://www.postgresql.org/docs/8.2/interactive/sql-grant.html

Also, on the second point, you can do

    export PGCLIENTENCODING=whatever

before running pg_dumpall.  A -E switch might be more obvious but it's
not like you can't do it now.

            regards, tom lane

pgsql-general by date:

Previous
From: Paul Lambert
Date:
Subject: Setting up functions in psql.
Next
From: Tom Lane
Date:
Subject: Re: Setting up functions in psql.