pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Standalone Postgres
7+ messages / 5 participants
[nested] [flat]

* Standalone Postgres
@ 2006-06-07 07:30 Jarek <jarek@poczta.srv.pl>
  2006-06-07 08:01 ` Re: Standalone Postgres Andy Shellam <andy.shellam@mailnetwork.co.uk>
  0 siblings, 1 reply; 7+ messages in thread

From: Jarek @ 2006-06-07 07:30 UTC (permalink / raw)
  To: pgsql-admin

Hello!

	Is it possible to have a CD with database and postgres binaries
(win32), which can be directly run (without any installation) ? Or if it
is impossible to be run from read-only media, to have it as
self-extracting archive, which can be run from any user account ?
The goal is to have some demonstration CD with some viewer, database and
postgres engine, which can be easily run by any windows user without
installation.

best regards
Jarek




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Standalone Postgres
  2006-06-07 07:30 Standalone Postgres Jarek <jarek@poczta.srv.pl>
@ 2006-06-07 08:01 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-06-07 08:11   ` Re: Standalone Postgres Jarek <jarek@poczta.srv.pl>
  2006-06-07 14:23   ` Re: Standalone Postgres Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 2 replies; 7+ messages in thread

From: Andy Shellam @ 2006-06-07 08:01 UTC (permalink / raw)
  To: 'Jarek' <jarek@poczta.srv.pl>; +Cc: pgsql-admin

You won't be able to run it all off CD no, as Postgres requires
log/transaction files etc to be written to.  It also requires a service
user/data directory so it would have to be installed.

If you don't require the functionality etc of Postgres (and haven't
developed your solution yet) you might be better off looking at something
like SQLlite, which uses flat-files.

Andy

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org] On Behalf Of Jarek
> Sent: 07 June 2006 8:30 am
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Standalone Postgres
> 
> Hello!
> 
> 	Is it possible to have a CD with database and postgres binaries
> (win32), which can be directly run (without any installation) ? Or if it
> is impossible to be run from read-only media, to have it as
> self-extracting archive, which can be run from any user account ?
> The goal is to have some demonstration CD with some viewer, database and
> postgres engine, which can be easily run by any windows user without
> installation.
> 
> best regards
> Jarek
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 
> !DSPAM:14,448685ca256843840818650!
> 





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Standalone Postgres
  2006-06-07 07:30 Standalone Postgres Jarek <jarek@poczta.srv.pl>
  2006-06-07 08:01 ` Re: Standalone Postgres Andy Shellam <andy.shellam@mailnetwork.co.uk>
@ 2006-06-07 08:11   ` Jarek <jarek@poczta.srv.pl>
  2006-06-07 08:25     ` Re: Standalone Postgres Andy Shellam <andy.shellam@mailnetwork.co.uk>
  1 sibling, 1 reply; 7+ messages in thread

From: Jarek @ 2006-06-07 08:11 UTC (permalink / raw)
  To: pgsql-admin

Dnia 07-06-2006, śro o godzinie 09:01 +0100, Andy Shellam napisał(a):
> You won't be able to run it all off CD no, as Postgres requires
> log/transaction files etc to be written to.  It also requires a service
> user/data directory so it would have to be installed.

OK. Let's assume, that I will have self extracting archive, which will
install all files on some temporary directory on user machine. Will it
work ?


> If you don't require the functionality etc of Postgres (and haven't
> developed your solution yet) you might be better off looking at something
> like SQLlite, which uses flat-files.

I want to create demo of application which uses postgres, so it HAVE to
be postgres...

best regards
Jarek




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Standalone Postgres
  2006-06-07 07:30 Standalone Postgres Jarek <jarek@poczta.srv.pl>
  2006-06-07 08:01 ` Re: Standalone Postgres Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-06-07 08:11   ` Re: Standalone Postgres Jarek <jarek@poczta.srv.pl>
@ 2006-06-07 08:25     ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-06-07 22:39       ` Re: Standalone Postgres Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Andy Shellam @ 2006-06-07 08:25 UTC (permalink / raw)
  To: 'Jarek' <jarek@poczta.srv.pl>; +Cc: pgsql-admin

You would need to write your own installation script that would:
a) create the temporary data directory
b) install Postgres with all default options
c) modify the pg_hba.conf file to allow localhost trust access (ie. No
password) - and restart Postgres
d) load the dump of your database into Postgres
e) start your demo and wait for it to exit
f) when demo has exited, stop and uninstall Postgres
g) remove data directory

It depends how the MSI installer for Postgres will handle the "silent
install" option, but you could use NSIS to do most if not all of this
(http://nsis.sourceforge.net.)

Andy

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org] On Behalf Of Jarek
> Sent: 07 June 2006 9:11 am
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Standalone Postgres
> 
> Dnia 07-06-2006, sro o godzinie 09:01 +0100, Andy Shellam napisal(a):
> > You won't be able to run it all off CD no, as Postgres requires
> > log/transaction files etc to be written to.  It also requires a service
> > user/data directory so it would have to be installed.
> 
> OK. Let's assume, that I will have self extracting archive, which will
> install all files on some temporary directory on user machine. Will it
> work ?
> 
> 
> > If you don't require the functionality etc of Postgres (and haven't
> > developed your solution yet) you might be better off looking at
> something
> > like SQLlite, which uses flat-files.
> 
> I want to create demo of application which uses postgres, so it HAVE to
> be postgres...
> 
> best regards
> Jarek
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 
> !DSPAM:14,44868a9c256841952411642!
> 





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Standalone Postgres
  2006-06-07 07:30 Standalone Postgres Jarek <jarek@poczta.srv.pl>
  2006-06-07 08:01 ` Re: Standalone Postgres Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-06-07 08:11   ` Re: Standalone Postgres Jarek <jarek@poczta.srv.pl>
  2006-06-07 08:25     ` Re: Standalone Postgres Andy Shellam <andy.shellam@mailnetwork.co.uk>
@ 2006-06-07 22:39       ` Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Jim C. Nasby @ 2006-06-07 22:39 UTC (permalink / raw)
  To: Andy Shellam <andy.shellam@mailnetwork.co.uk>; +Cc: Jarek <jarek@poczta.srv.pl>; pgsql-admin

On Wed, Jun 07, 2006 at 09:25:18AM +0100, Andy Shellam wrote:
> You would need to write your own installation script that would:
> a) create the temporary data directory
> b) install Postgres with all default options
> c) modify the pg_hba.conf file to allow localhost trust access (ie. No
> password) - and restart Postgres
> d) load the dump of your database into Postgres
> e) start your demo and wait for it to exit
> f) when demo has exited, stop and uninstall Postgres
> g) remove data directory
> 
> It depends how the MSI installer for Postgres will handle the "silent
> install" option, but you could use NSIS to do most if not all of this
> (http://nsis.sourceforge.net.)

And what happens if the user running this is an admin on the box?
PostgreSQL will refuse to start. Though, there is a patch floating
around that changes that, should you wish to build your own version...
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Standalone Postgres
  2006-06-07 07:30 Standalone Postgres Jarek <jarek@poczta.srv.pl>
  2006-06-07 08:01 ` Re: Standalone Postgres Andy Shellam <andy.shellam@mailnetwork.co.uk>
@ 2006-06-07 14:23   ` Scott Marlowe <smarlowe@g2switchworks.com>
  2006-06-07 18:41     ` Re: Standalone Postgres Aaron Bono <postgresql@aranya.com>
  1 sibling, 1 reply; 7+ messages in thread

From: Scott Marlowe @ 2006-06-07 14:23 UTC (permalink / raw)
  To: andy.shellam@mailnetwork.co.uk; +Cc: Jarek <jarek@poczta.srv.pl>; pgsql-admin

On Wed, 2006-06-07 at 03:01, Andy Shellam wrote:


> > Hello!
> > 
> > 	Is it possible to have a CD with database and postgres binaries
> > (win32), which can be directly run (without any installation) ? Or if it
> > is impossible to be run from read-only media, to have it as
> > self-extracting archive, which can be run from any user account ?
> > The goal is to have some demonstration CD with some viewer, database and
> > postgres engine, which can be easily run by any windows user without
> > installation.
> > 
> > best regards
> > Jarek
> > 
> You won't be able to run it all off CD no, as Postgres requires
> log/transaction files etc to be written to.  It also requires a service
> user/data directory so it would have to be installed.
> 
> If you don't require the functionality etc of Postgres (and haven't
> developed your solution yet) you might be better off looking at something
> like SQLlite, which uses flat-files.

Actually there is a live pg cd distro out there somewhere.  I've got a
copy of it I can reseed the torrent if anyone wants it.

I'm sure it's a bit out of date by now, but it's a pretty cool little
trick.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Standalone Postgres
  2006-06-07 07:30 Standalone Postgres Jarek <jarek@poczta.srv.pl>
  2006-06-07 08:01 ` Re: Standalone Postgres Andy Shellam <andy.shellam@mailnetwork.co.uk>
  2006-06-07 14:23   ` Re: Standalone Postgres Scott Marlowe <smarlowe@g2switchworks.com>
@ 2006-06-07 18:41     ` Aaron Bono <postgresql@aranya.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Aaron Bono @ 2006-06-07 18:41 UTC (permalink / raw)
  To: pgsql-admin

You might check out Knoppix.  If your app will run on Linux you could create
a full bootable Knoppix CD with everything installed - then they can play
around all they want and just reboot to reset everything.  I am not sure if
there is a Knoppix distro that can run within Windows.

I do video demos.  I know that doesn't allow the user to play but you can
really show off the tool in a controlled manner.  Check Instant Demo at
http://www.instant-demo.com/ - I bought it recently and love it.  It even
makes Flash versions so you can put them up on your web site.

-Aaron

On 6/7/06, Scott Marlowe <smarlowe@g2switchworks.com> wrote:
>
> On Wed, 2006-06-07 at 03:01, Andy Shellam wrote:
>
>
> > > Hello!
> > >
> > >     Is it possible to have a CD with database and postgres binaries
> > > (win32), which can be directly run (without any installation) ? Or if
> it
> > > is impossible to be run from read-only media, to have it as
> > > self-extracting archive, which can be run from any user account ?
> > > The goal is to have some demonstration CD with some viewer, database
> and
> > > postgres engine, which can be easily run by any windows user without
> > > installation.
> > >
> > > best regards
> > > Jarek
> > >
> > You won't be able to run it all off CD no, as Postgres requires
> > log/transaction files etc to be written to.  It also requires a service
> > user/data directory so it would have to be installed.
> >
> > If you don't require the functionality etc of Postgres (and haven't
> > developed your solution yet) you might be better off looking at
> something
> > like SQLlite, which uses flat-files.
>
> Actually there is a live pg cd distro out there somewhere.  I've got a
> copy of it I can reseed the torrent if anyone wants it.
>
> I'm sure it's a bit out of date by now, but it's a pretty cool little
> trick.

^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2006-06-07 22:39 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-07 07:30 Standalone Postgres Jarek <jarek@poczta.srv.pl>
2006-06-07 08:01 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-06-07 08:11   ` Jarek <jarek@poczta.srv.pl>
2006-06-07 08:25     ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-06-07 22:39       ` Jim C. Nasby <jnasby@pervasive.com>
2006-06-07 14:23   ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-06-07 18:41     ` Aaron Bono <postgresql@aranya.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox