Re: problem calling psql from another program

On Fri, 2005-06-24 at 01:57, Frank Rittinger wrote:
> Hello list,
>
> I have PostgreSQL 8.0 on Windows Server 2000, and wrote a small .NET
> program that creates a subprocess that executes psql with a sql script
> as input (psql -U user -f script.sql).
>
> This script runs well if I start psql from the command line and execute
> it there. But within the .NET program it behaves strange: it never
> finishes but the server doesn't do anything. When I kill the program
> with CTRL-C than it seams as if the script gets executed. (BTW this
> works fine under WinXP Pro!)

I'm guessing you have an authentication problem. Make sure you're got
logging turned on for postgresql, then tail the logs (or whatever the
equivalent is in windowsland) and watch for errors when you run your
.net app.

But why are you using the .net connector for postgresql?