Re: Getting postmaster: StreamConnection: accept: The connection - Mailing list pgsql-general

From Kevin Brannen
Subject Re: Getting postmaster: StreamConnection: accept: The connection
Date
Msg-id 3D3457F5.7080701@nurseamerica.net
Whole thread Raw
In response to Getting postmaster: StreamConnection: accept: The connection was aborted  ("Jeff Lu" <jklcom@mindspring.com>)
List pgsql-general
Jeff Lu wrote:
> Hi,
>
> I'm trying to perform a pg_dump from within a C program and I'm getting
>
> postmaster: StreamConnection: accept: The connection was aborted
>
> I've tried two different ways:
>
> 1) system("./pg_dump --file=database.dat database");
>
> AND
>
> 2) system("./dbbackup.bat");
>
> Where dbbackup.bat consists of
>
> pg_dump --file=database.dat database
>
> Both ways have the same error.
>
> However, it works fine with run dbbackup.bat from a command line.
>
> Please help
>
> Thanks
>
> -Jeff
>

 From what you're describing, it sounds like the classic "missing
environmental variables" problem.  If it works on the command line but
not from within a program (or from cron), then you're just missing 1 or
more env-vars, maybe PGPASSWORD?  You should be able to track it down
from there. :-)

HTH,
Kevin


pgsql-general by date:

Previous
From: "Keith G. Murphy"
Date:
Subject: Re: PostgreSQL in mission-critical system
Next
From: Ralph Graulich
Date:
Subject: size of function body