Thread: Getting postmaster: StreamConnection: accept: The connection was aborted
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
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