Re: PostgreSQL 9.1 pg_dump setval() sets wrong value

On 12/29/2011 08:13 AM, Greg Donald wrote:
> On Wed, Dec 28, 2011 at 4:58 PM, Adrian Klaver<adrian(dot)klaver(at)gmail(dot)com> wrote:
>> What is the pg_dump command, with options, you are using?
>
> My backup shell script contains:
>
> /usr/bin/pg_dump cp | bzip2> $FILE

One possible issue that I see is the lack of explicit options. Given
that you say you have two Postgres clusters on the machine it is
entirely possible that the above command is picking up ENVIRONMENT
variables that are pointing to a database different from the one you
think. Try the command with explicit options, i.e. -p some_port -d
database_name, that you know point to the database you want.

>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com