[GENERAL] problem calling psql from another program

2005-06-24 Thread Frank Rittinger 

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!)


Any suggestions are welcomed.

Regards

Frank Rittinger

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

Re: [GENERAL] Windows version of PostgreSQL 8?

2005-07-12 Thread Frank Rittinger 

Hello Bjørn,

we are running a handfull of PostgreSQL installations on Windows Server 
2000 and 2003 for web-mapping applications and they are running well for 
the last 8 months.


Bjørn T Johansen wrote:

How stable is the windows version of pgsql 8? Is it as stable as the Linux 
version or
should I look elsewehere after a good sql srv for Windows?


Regards.

BTJ



Regards Frank

--

Frank Rittinger

TERRAPLAN Geographische Informationssysteme
Gewerbestr. 33
79227 Schallstadt
Germany

Tel.: 07664-505315
Fax.: 07664-505321

http://www.terraplan.com

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Upgrading 8.0.2 to 8.0.3 on Windows XP

2005-08-15 Thread Frank Rittinger 

Hello Giovanni,

I had a similar problem.  I think the windows installer tries to create 
a new service which he can't, since there is already one with the same 
name.  I uninstalled Postgresql but told it to keep the data directory, 
rebooted the machine (that's important since only then the old service 
is removed) and installed the new version, using the old data directory.


However, I would still do a dump before :-)

Hope this helps,Frank


Giovanni M. wrote:

Hello,
 
Wondering if somebody can help me out with upgrading a PostgreSQL 8.0.2 
installation on Windows XP SP2.
 
I can´t seem to upgrade to 8.0.3 on a Windows XP Machine. The machine 
has a limited user account running the pgsql-8.0 service. The first 
installation was performed succesfully with the win32 installer.
A subsequent upgrade using the upgrade.bat file from the postgresql8.0.3 
win32 distribution hangs at the very end with the following isntallation 
error: "Verify
that you have sufficient privileges to start system services"... I must 
cancel the installation at this point and it automatically performs a 
rollback.
 
I cant seem to figure out why this keeps happening. I´m doing the 
upgrade from an administrator account with all privileges, the limited 
user account which runs the pgsql service has log on as service rights...
 
Anybody know a solution to this, or do I simply need to dump my 
database, uninstall 8.0.2, do a fresh install of 8.0.3 and reload my 
database?
 
Thanks in advance,
 
gio


--
A World of KEIGI
http://keigi.blogspot.com



--

Frank Rittinger

TERRAPLAN Geographische Informationssysteme
Gewerbestr. 33
79227 Schallstadt
Germany

Tel.: 07664-505315
Fax.: 07664-505321

http://www.terraplan.com

---(end of broadcast)---
TIP 6: explain analyze is your friend