Re: Running initdb from another process - Mailing list pgsql-general

From Tony Caduto
Subject Re: Running initdb from another process
Date
Msg-id 457EDC72.1070009@amsoftwaredesign.com
Whole thread Raw
In response to Running initdb from another process  ("Greg Fairbanks" <fairbanksg@seapine.com>)
List pgsql-general
Greg Fairbanks wrote:
>
> Hi,
>
> I am looking at trying to integrate PostgreSQL into our software.
> Basically, I want to have our
>
> software to spawn postgres so the user doesn’t have to concern
> themselves with managing the
>
> database. I am using the Windows calls LogonUser and
> CreateProcessAsUser to start initdb as
>
> an unprivileged user. However, I am running into trouble on Windows
> Vista. Initdb will startup,
>
> but when it starts postgres.exe, postgres.exe seems to get hung up on
> the CreateFileMapping
>
> call while setting up shared memory. This only happens on Vista. It
> works perfectly on Windows
>
> NT4/2000/XP/2003. I was wondering if anyone had any experience with
> this type of situation and
>
> could lend any help.
>
>
I created a Inno setup (http://www.jrsoftware.org/isinfo.php) that does
all that, don't know if it will work on vista, but it should.
You can grab it here:
http://www.amsoftwaredesign.com/downloads/pg_installer_setup.zip
Full source included.

I also use those APIs, but I do it all from a native win32 DLL created
with Delphi. You don't have to concern yourself with
shared memory, so it may work for you.

The setup completely installs postgresql and starts it, all you have to
do is add the files to the setup for your application.

Good luck,

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration


pgsql-general by date:

Previous
From: "Brandon Aiken"
Date:
Subject: Re: Why DISTINCT ... DESC is slow?
Next
From: Erik Jones
Date:
Subject: Re: date comparisons