Search Postgresql Archives

Re: problem calling psql from another program

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux