Re: Deploying Postgresql Along My Windows App

From: Joshua Kramer <josh(at)globalherald(dot)net>
To: Valter Nogueira <vgnogueira(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Deploying Postgresql Along My Windows App
Date: 2008-04-15 13:22:59
Message-ID: alpine.LRH.1.10.0804150917570.15526@home-av-server.home-av
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello Valter,

I am doing something similar with the Windows installer for the PostBooks
project. Basically, what I do is this:

1. Use the Postgres windows installer to install 8.2.7
2. Import all the application's databases.
3. Using the NSIS Installer Generation app:
1. Include all files under c:\program files\postgresql... in my
project;
2. Use NSIS utilities to install the PostgreSQL service in a
custom manner. I do this on a non-standard port so that if the user
already has PG, it does not clobber the existing install.

I don't have a lot of time at the moment, but later today I can go into
details if you like. In the meantime, check out:

http://nsis.sourceforge.net/Main_Page
http://hmne.sourceforge.net/
http://www.xtuple.org

Cheers,
-J

On Mon, 14 Apr 2008, Valter Nogueira wrote:

> Date: Mon, 14 Apr 2008 23:38:02 -0300
> From: Valter Nogueira <vgnogueira(at)gmail(dot)com>
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] Deploying Postgresql Along My Windows App
>
> I am developing a wxPython app which can run, like Postgresql, on Linux
> and Windows boxes.
>  
> Linux users are far more specialized than Windows one - and Postgres
> comes along with major distros.
>  
> Windows users don't want (or are unable to) install Postgresql by
> themselves, so I was wondering if there is a way to deploy (or embed) it
> along my app.
>  
> I would like to decompress a non-installer bin version, setup the initial
> catalog and run the server without users intervention.
>  
> Can anyone help me?
>  
> Thanks,
>  
> Valter
>  
>  
>
>

--

-----
http://www.globalherald.net/jb01
GlobalHerald.NET, the Smarter Social Network! (tm)
>From pgsql-admin-owner(at)postgresql(dot)org Tue Apr 15 10:38:45 2008
Received: from localhost (unknown [200.46.204.183])
by developer.postgresql.org (Postfix) with ESMTP id 3F9B82E0056
for <pgsql-admin-postgresql(dot)org(at)developer(dot)postgresql(dot)org>; Tue, 15 Apr 2008 10:38:45 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
with ESMTP id 77176-02
for <pgsql-admin-postgresql(dot)org(at)developer(dot)postgresql(dot)org>;
Tue, 15 Apr 2008 10:38:38 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.170])
by developer.postgresql.org (Postfix) with ESMTP id ADD742E0030
for <pgsql-admin(at)postgresql(dot)org>; Tue, 15 Apr 2008 10:38:38 -0300 (ADT)
Received: by wf-out-1314.google.com with SMTP id 28so1949914wff.28
for <pgsql-admin(at)postgresql(dot)org>; Tue, 15 Apr 2008 06:38:37 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
bh=a7ZEiGG4Fe6/MsJyTRbfs/6Hmh+uemvvSL0ODM/DUwc=;
b=omOQ4qXzM9ihFePV3dFJqCT3R0RJfrwr4NWIiIHkz0I3h7FkxjnknCsVbvdoNXg7IWyjb9PTyHmOPEUjnnI7KmlIrYQ4ueDis4w0+RpSkWiN19H8EVpiOcKWRvAGtg3K741/4/ze8tHAvNEYNQZ/l8Fx4kWx1rpFcchJFAkBk6o=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
b=TkXjXQmcLfTBHBzF+z3maIhKJI7dp9ZxLG7XDYE6cu6B792qXh5r4m/osvCOV091yt2P2MQpJGNyfs1x1iORg+SniYAKvEKuggZBqp9tyxYWVHrS31lGYNRjwbiyIjLK0dwgsrJB94tibmdo/y+oQH5ifgCXodvYlvOKz6a+jIM=
Received: by 10.142.240.9 with SMTP id n9mr2253209wfh.136.1208266717318;
Tue, 15 Apr 2008 06:38:37 -0700 (PDT)
Received: by 10.142.143.6 with HTTP; Tue, 15 Apr 2008 06:38:37 -0700 (PDT)
Message-ID: <c0b9243d0804150638r698f360fi7f2fbcd117828096(at)mail(dot)gmail(dot)com>
Date: Tue, 15 Apr 2008 17:38:37 +0400
From: "Dmitry Shubin" <dm(dot)shubin(at)gmail(dot)com>
To: "Julius Tuskenis" <julius(at)nsoft(dot)lt>, pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres 8.1 usermanagement problem
In-Reply-To: <48049CE2(dot)1000008(at)nsoft(dot)lt>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_Part_43199_22632763.1208266717300"
References: <c0b9243d0804150507s3315da2k1bb6ca8c3073f89b(at)mail(dot)gmail(dot)com>
<48049CE2(dot)1000008(at)nsoft(dot)lt>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
tests=HTML_MESSAGE=0.001
X-Spam-Level:
X-Archive-Number: 200804/145
X-Sequence-Number: 28909

------=_Part_43199_22632763.1208266717300
Content-Type: text/plain; charset=ISO-8859-13
Content-Transfer-Encoding: base64
Content-Disposition: inline

VGhhbmtzIGEgbG90LCB0aGF0IHdhcyB0aGUgcHJvYmxlbSEKCk9uIDQvMTUvMDgsIEp1bGl1cyBU
dXNrZW5pcyA8anVsaXVzQG5zb2Z0Lmx0PiB3cm90ZToKPgo+IERpZCB5b3UgY2hlY2sgdGhlIG9w
dGlvbiAiSW5oZXJpdHMgcmlnaHRzIGZyb20gcGFyZW50IHJvbGVzIiAocGFyYW1ldGVyCj4gSU5I
RVJJVCBpbiBTUUwpIGZvciB1c2VyIHRlc3R1cyA/Cj4KPgo+IERtaXRyeSBTaHViaW4gcmHw6zoK
Pgo+ID4gSGFsbG8gdG8gYWxsISBJIHVzZSBQb3N0Z3JlcyA4LjEgYW5kIGkndmUgZ290IHByb2Js
ZW0gaW4gaXRzCj4gPiB1c2VybWFuYWdlbWVudC4KPiA+Cj4gPiBIZXJlIGlzIG1lIHJvbGVzIGxp
c3Q6Cj4gPiBuYXVzZD0jIFxkdQo+ID4gTGlzdCBvZiByb2xlcwo+ID4gUm9sZSBuYW1lIHwgU3Vw
ZXJ1c2VyIHwgQ3JlYXRlIHJvbGUgfCBDcmVhdGUgREIgfCBDb25uZWN0aW9ucyB8IE1lbWJlcgo+
ID4gb2YKPiA+Cj4gPiAtLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0t
LS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLQo+ID4gZHNzMCB8IHllcyB8IHll
cyB8IHllcyB8IG5vIGxpbWl0IHwKPiA+IGdlb3JneWQgfCBubyB8IG5vIHwgbm8gfCBubyBsaW1p
dCB8IHtuYXVzZF9yZWFkfQo+ID4gam9lIHwgbm8gfCBubyB8IG5vIHwgbm8gbGltaXQgfAo+ID4g
bmF1c2QgfCBubyB8IG5vIHwgbm8gfCBubyBsaW1pdCB8Cj4gPiBuYXVzZF9yZWFkIHwgbm8gfCBu
byB8IG5vIHwgbm8gbGltaXQgfAo+ID4gcG9zdGdyZXMgfCB5ZXMgfCB5ZXMgfCB5ZXMgfCBubyBs
aW1pdCB8Cj4gPiBzYWdhY2hfdXNlciB8IG5vIHwgbm8gfCBubyB8IG5vIGxpbWl0IHwKPiA+IHN5
c3RlbSB8IG5vIHwgbm8gfCBubyB8IG5vIGxpbWl0IHwKPiA+IHRlc3RncnAgfCBubyB8IG5vIHwg
bm8gfCBubyBsaW1pdCB8Cj4gPiB0ZXN0dXMgfCBubyB8IG5vIHwgbm8gfCBubyBsaW1pdCB8IHt0
ZXN0Z3JwfQo+ID4gdHRlc3QgfCBubyB8IG5vIHwgbm8gfCBubyBsaW1pdCB8Cj4gPiAoMTEgcm93
cykKPiA+Cj4gPiB0ZXN0dXMgLSB1c2VyIGlzIGEgbWVtYmVyIG9mIHRoZSB0ZXN0Z3JwCj4gPgo+
ID4gVGhlbiBJIGNoYW5nZWQgcGVybWlzc2lvbiBpbiB0YWJsZSB0YmxfYV9hX2NvbnRhaW5lciBm
cm9tIGRhdGFiYXNlCj4gPiBuYXVzZDoKPiA+Cj4gPiBuYXVzZD0jIFx6Cj4gPiBBY2Nlc3MgcHJp
dmlsZWdlcyBmb3IgZGF0YWJhc2UgIm5hdXNkIgo+ID4gU2NoZW1hIHwgTmFtZSB8IFR5cGUgfCBB
Y2Nlc3MgcHJpdmlsZWdlcwo+ID4KPiA+IC0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+ID4gcHVibGljIHwgdGJsX2FfYV9jb250YWlu
ZXIgfCB0YWJsZSB8Cj4gPiB7bmF1c2Q9YXJ3ZFJ4dC9uYXVzZCxuYXVzZF9yZWFkPXIvbmF1c2Qs
dGVzdGdycD1hcndkUnh0L25hdXNkfQo+ID4KPiA+IFNvLCB3ZSBjYW4gc2VlIGFsbCByaWdodHMg
Zm9yIGdyb3VwIHRlc3RncnAgYW5kIGNvcnJlc3BvbmRpbmdseSBmb3IKPiA+IHRlc3R1cy4KPiA+
Cj4gPiBCdXQgd2hlbiBJIGxvZ2dpbmcgdG8gZGF0YWJlcyBuYXVzZCB3aXRoIHVzZXIgdGVzdHVz
IGFuZCB0cnkgdG8gc2VsZWN0Cj4gPiBmcm9tIHRibF9hX2FfY29udGFpbmVyIC0gSSBnb3QgZXJy
b3I6IHBlcm1pc3Npb24gZGVuaWVkIGZvciByZWxhdGlvbgo+ID4gdGJsX2FfYV9jb250YWluZXIK
PiA+Cj4gPiBXaGF0J3Mgd3Jvbmc/Cj4gPgo+ID4KPgo+IC0tCj4gSnVsaXVzIFR1c2tlbmlzCj4K
Pgo+Cj4gLS0KPiBTZW50IHZpYSBwZ3NxbC1hZG1pbiBtYWlsaW5nIGxpc3QgKHBnc3FsLWFkbWlu
QHBvc3RncmVzcWwub3JnKQo+IFRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoK
PiBodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWFkbWluCj4K
------=_Part_43199_22632763.1208266717300
Content-Type: text/html; charset=ISO-8859-13
Content-Transfer-Encoding: base64
Content-Disposition: inline

VGhhbmtzIGEgbG90LCB0aGF0IHdhcyB0aGUgcHJvYmxlbSE8YnI+PGJyPjxkaXY+PHNwYW4gY2xh
c3M9ImdtYWlsX3F1b3RlIj5PbiA0LzE1LzA4LCA8YiBjbGFzcz0iZ21haWxfc2VuZGVybmFtZSI+
SnVsaXVzIFR1c2tlbmlzPC9iPiAmbHQ7PGEgaHJlZj0ibWFpbHRvOmp1bGl1c0Buc29mdC5sdCI+
anVsaXVzQG5zb2Z0Lmx0PC9hPiZndDsgd3JvdGU6PC9zcGFuPjxibG9ja3F1b3RlIGNsYXNzPSJn
bWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbi10b3A6IDA7IG1hcmdpbi1yaWdodDogMDsgbWFyZ2lu
LWJvdHRvbTogMDsgbWFyZ2luLWxlZnQ6IDA7IG1hcmdpbi1sZWZ0OiAwLjgwZXg7IGJvcmRlci1s
ZWZ0LWNvbG9yOiAjY2NjY2NjOyBib3JkZXItbGVmdC13aWR0aDogMXB4OyBib3JkZXItbGVmdC1z
dHlsZTogc29saWQ7IHBhZGRpbmctbGVmdDogMWV4Ij4KRGlkIHlvdSBjaGVjayB0aGUgb3B0aW9u
ICZxdW90O0luaGVyaXRzIHJpZ2h0cyBmcm9tIHBhcmVudCByb2xlcyZxdW90OyAocGFyYW1ldGVy
IElOSEVSSVQgaW4gU1FMKSBmb3IgdXNlciB0ZXN0dXMgPzxicj48YnI+PGJyPiBEbWl0cnkgU2h1
YmluIHJh8Os6PGRpdj48c3BhbiBjbGFzcz0iZSIgaWQ9InFfMTE5NTIwNjE4MGMzMjFhNF8xIj48
YnI+PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0iYm9yZGVyLWxlZnQtY29s
b3I6ICNjY2NjY2M7IGJvcmRlci1sZWZ0LXdpZHRoOiAxcHg7IGJvcmRlci1sZWZ0LXN0eWxlOiBz
b2xpZDsgcGFkZGluZy1sZWZ0OiAxZXgiPgogSGFsbG8gdG8gYWxsISBJIHVzZSBQb3N0Z3JlcyA4
LjEgYW5kIGkmIzM5O3ZlIGdvdCBwcm9ibGVtIGluIGl0cyB1c2VybWFuYWdlbWVudC48YnI+PGJy
PiBIZXJlIGlzIG1lIHJvbGVzIGxpc3Q6PGJyPiBuYXVzZD0jIFxkdTxicj4gTGlzdCBvZiByb2xl
czxicj4gUm9sZSBuYW1lIHwgU3VwZXJ1c2VyIHwgQ3JlYXRlIHJvbGUgfCBDcmVhdGUgREIgfCBD
b25uZWN0aW9ucyB8IE1lbWJlciBvZjxicj4KIC0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0t
LS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tPGJyPiBk
c3MwIHwgeWVzIHwgeWVzIHwgeWVzIHwgbm8gbGltaXQgfDxicj4gZ2Vvcmd5ZCB8IG5vIHwgbm8g
fCBubyB8IG5vIGxpbWl0IHwge25hdXNkX3JlYWR9PGJyPiBqb2UgfCBubyB8IG5vIHwgbm8gfCBu
byBsaW1pdCB8PGJyPiBuYXVzZCB8IG5vIHwgbm8gfCBubyB8IG5vIGxpbWl0IHw8YnI+CiBuYXVz
ZF9yZWFkIHwgbm8gfCBubyB8IG5vIHwgbm8gbGltaXQgfDxicj4gcG9zdGdyZXMgfCB5ZXMgfCB5
ZXMgfCB5ZXMgfCBubyBsaW1pdCB8PGJyPiBzYWdhY2hfdXNlciB8IG5vIHwgbm8gfCBubyB8IG5v
IGxpbWl0IHw8YnI+IHN5c3RlbSB8IG5vIHwgbm8gfCBubyB8IG5vIGxpbWl0IHw8YnI+IHRlc3Rn
cnAgfCBubyB8IG5vIHwgbm8gfCBubyBsaW1pdCB8PGJyPiB0ZXN0dXMgfCBubyB8IG5vIHwgbm8g
fCBubyBsaW1pdCB8IHt0ZXN0Z3JwfTxicj4KIHR0ZXN0IHwgbm8gfCBubyB8IG5vIHwgbm8gbGlt
aXQgfDxicj4gKDExIHJvd3MpPGJyPjxicj4gdGVzdHVzIC0gdXNlciBpcyBhIG1lbWJlciBvZiB0
aGUgdGVzdGdycDxicj48YnI+IFRoZW4gSSBjaGFuZ2VkIHBlcm1pc3Npb24gaW4gdGFibGUgdGJs
X2FfYV9jb250YWluZXIgZnJvbSBkYXRhYmFzZSBuYXVzZDo8YnI+PGJyPiBuYXVzZD0jIFx6PGJy
PiBBY2Nlc3MgcHJpdmlsZWdlcyBmb3IgZGF0YWJhc2UgJnF1b3Q7bmF1c2QmcXVvdDs8YnI+CiBT
Y2hlbWEgfCBOYW1lIHwgVHlwZSB8IEFjY2VzcyBwcml2aWxlZ2VzPGJyPiAtLS0tLS0tLSstLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08YnI+IHB1Ymxp
YyB8IHRibF9hX2FfY29udGFpbmVyIHwgdGFibGUgfCB7bmF1c2Q9YXJ3ZFJ4dC9uYXVzZCxuYXVz
ZF9yZWFkPXIvbmF1c2QsdGVzdGdycD1hcndkUnh0L25hdXNkfTxicj4KPGJyPiBTbywgd2UgY2Fu
IHNlZSBhbGwgcmlnaHRzIGZvciBncm91cCB0ZXN0Z3JwIGFuZCBjb3JyZXNwb25kaW5nbHkgZm9y
IHRlc3R1cy48YnI+PGJyPiBCdXQgd2hlbiBJIGxvZ2dpbmcgdG8gZGF0YWJlcyBuYXVzZCB3aXRo
IHVzZXIgdGVzdHVzIGFuZCB0cnkgdG8gc2VsZWN0IGZyb20gdGJsX2FfYV9jb250YWluZXIgLSBJ
IGdvdCBlcnJvcjogcGVybWlzc2lvbiBkZW5pZWQgZm9yIHJlbGF0aW9uIHRibF9hX2FfY29udGFp
bmVyPGJyPgo8YnI+IFdoYXQmIzM5O3Mgd3Jvbmc/PGJyPjxicj48L2Jsb2NrcXVvdGU+PGJyPjxi
cj48L3NwYW4+PC9kaXY+IC0tIDxicj4gSnVsaXVzIFR1c2tlbmlzPGJyPjxzcGFuIGNsYXNzPSJz
ZyI+PGJyPjxicj48YnI+IC0tIDxicj4gU2VudCB2aWEgcGdzcWwtYWRtaW4gbWFpbGluZyBsaXN0
ICg8YSBocmVmPSJtYWlsdG86cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmciIHRhcmdldD0iX2Js
YW5rIiBvbmNsaWNrPSJyZXR1cm4gdG9wLmpzLk9wZW5FeHRMaW5rKHdpbmRvdyxldmVudCx0aGlz
KSI+cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmc8L2E+KTxicj4KIFRvIG1ha2UgY2hhbmdlcyB0
byB5b3VyIHN1YnNjcmlwdGlvbjo8YnI+PGEgaHJlZj0iaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y
Zy9tYWlscHJlZi9wZ3NxbC1hZG1pbiIgdGFyZ2V0PSJfYmxhbmsiIG9uY2xpY2s9InJldHVybiB0
b3AuanMuT3BlbkV4dExpbmsod2luZG93LGV2ZW50LHRoaXMpIj5odHRwOi8vd3d3LnBvc3RncmVz
cWwub3JnL21haWxwcmVmL3Bnc3FsLWFkbWluPC9hPjxicj4KPC9zcGFuPjwvYmxvY2txdW90ZT48
L2Rpdj48YnI+Cg==
------=_Part_43199_22632763.1208266717300--

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-04-15 14:43:56 Re: OID and filesystem issues
Previous Message Julius Tuskenis 2008-04-15 12:17:38 Re: postgres 8.1 usermanagement problem