pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedrunning PostGres without installing it
9+ messages / 7 participants
[nested] [flat]
* running PostGres without installing it
@ 2006-08-06 04:07 jesus martinez <jesus_martinez1967@yahoo.com.ar>
0 siblings, 2 replies; 9+ messages in thread
From: jesus martinez @ 2006-08-06 04:07 UTC (permalink / raw)
To: pgsql-admin
hello, how are you ?
i want to distribute a copy of PostGres to my clients.
they really dont know anything about installing
programs or
configurating remote RDBMS sql-servers,
so i dont want to give them the
"official-PostGres-installer.exe"
but my own installer.exe (win32) that:
1) install the PostGres's required files
2) modify the system as PostGres needs (registry,
paths, etc)
3) execute it as a process, not as a service (if it is
possible)
(it must run also on win98 machines)
4) enable the server in a port readed from an INI file
or
something like that.
5) delete the default super-user or change its
password
6) creates the tables-structure that my client-app
needs
7a) insert the data or
7b) copy db-files to hdd, assign them in PostGres and
make
them available via PostGres.
8) create the dbuser that will be used by clients-apps
9) assign that dbuser to my tables
all without any kind of user interaction.
- where can i get information about the required
information
(i mean: basic required files, registry changes, conf
files,
sql commands to do what i need) ?
- if this is not possible, may i call the default
PostGre's
installer in silent mode ? and if so, what are the
command-lines
to set the defaults settings ?
- can any of you help me in any of those tasks ?
thanks in advance,
__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: running PostGres without installing it
@ 2006-08-06 18:09 Aaron Bono <postgresql@aranya.com>
parent: jesus martinez <jesus_martinez1967@yahoo.com.ar>
1 sibling, 3 replies; 9+ messages in thread
From: Aaron Bono @ 2006-08-06 18:09 UTC (permalink / raw)
To: jesus martinez <jesus_martinez1967@yahoo.com.ar>; +Cc: pgsql-admin
On 8/5/06, jesus martinez <jesus_martinez1967@yahoo.com.ar> wrote:
>
>
> i want to distribute a copy of PostGres to my clients.
> they really dont know anything about installing
> programs or
> configurating remote RDBMS sql-servers,
> so i dont want to give them the
> "official-PostGres-installer.exe"
> but my own installer.exe (win32)
I would love to know this too. Is there a way to just copy the PostgreSQL
files to the hard drive without the installer, load up the database and
start and stop it as an application rather than a service? A silent
installer may solve the problem but what if you have 2 applications that
both have installers and want to install PostgreSQL? The silent installer
would need to be able to detect that it is already installed (which I think
it already does) and then skip the PostgreSQL install without bugging the
user (not sure it would do that).
For years I have struggled with desktop applications and data
access/storage. Databases are very powerful tools but, other than MS
Access, I have not seen any that are easily distributable bundled with a
desktop application. Not having a personal database to bundle with my
applications has proven to be a "one hand tied behind my back" situation.
Any ideas you guys have would be deeply appreciated.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: running PostGres without installing it
@ 2006-08-06 19:11 Amadeus Zilfinski <amadeus0@cox.net>
parent: Aaron Bono <postgresql@aranya.com>
2 siblings, 1 reply; 9+ messages in thread
From: Amadeus Zilfinski @ 2006-08-06 19:11 UTC (permalink / raw)
To: pgsql-admin
<snip>
>
> For years I have struggled with desktop applications and data
> access/storage. Databases are very powerful tools but, other than MS
> Access, I have not seen any that are easily distributable bundled with
> a desktop application. Not having a personal database to bundle with
> my applications has proven to be a "one hand tied behind my back"
> situation.
>
> Any ideas you guys have would be deeply appreciated.
>
SQLite can be complied to a single binary/.dll/.so and used. That is the
route I'm looking at due to having to be an 'expert' to install
PostgresQL, and how invasive it can be on a system. I don't have any
experience with firebird or MySQL, so you might want to check out those.
AmadeusZ.-
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: running PostGres without installing it
@ 2006-08-06 19:18 Chris Mair <chrisnospam@1006.org>
parent: Aaron Bono <postgresql@aranya.com>
2 siblings, 0 replies; 9+ messages in thread
From: Chris Mair @ 2006-08-06 19:18 UTC (permalink / raw)
To: pgsql-admin; +Cc: postgresql@aranya.com; jesus_martinez1967@yahoo.com.ar
> For years I have struggled with desktop applications and data
> access/storage. Databases are very powerful tools but, other than MS
> Access, I have not seen any that are easily distributable bundled with
> a desktop application. Not having a personal database to bundle with
> my applications has proven to be a "one hand tied behind my back"
> situation.
>
> Any ideas you guys have would be deeply appreciated.
I hate to say this, but maybe you should look into SQLite
http://www.sqlite.org/ ...
Bye,
Chris.
--
Chris Mair
http://www.1006.org
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: running PostGres without installing it
@ 2006-08-06 20:13 Aaron Bono <postgresql@aranya.com>
parent: Amadeus Zilfinski <amadeus0@cox.net>
0 siblings, 1 reply; 9+ messages in thread
From: Aaron Bono @ 2006-08-06 20:13 UTC (permalink / raw)
To: Amadeus Zilfinski <amadeus0@cox.net>; +Cc: pgsql-admin
On 8/6/06, Amadeus Zilfinski <amadeus0@cox.net> wrote:
>
> <snip>
> >
> > For years I have struggled with desktop applications and data
> > access/storage. Databases are very powerful tools but, other than MS
> > Access, I have not seen any that are easily distributable bundled with
> > a desktop application. Not having a personal database to bundle with
> > my applications has proven to be a "one hand tied behind my back"
> > situation.
> >
> > Any ideas you guys have would be deeply appreciated.
> >
>
> SQLite can be complied to a single binary/.dll/.so and used. That is the
> route I'm looking at due to having to be an 'expert' to install
> PostgresQL, and how invasive it can be on a system. I don't have any
> experience with firebird or MySQL, so you might want to check out those.
Would something like SQLite support the full functionality that we get from
PostgreSQL: subqueries, transactions, views, triggers and stored
procedures? MySQL does not (yes I know they are adding some or all of this
but it isn't all there or proven to be reliable yet).
I will check SQLite out but MySQL is probably NOT a good option for this.
Historically it did not support subqueries (an absolute must for any serious
database user) - not sure if they have added subquery support recently or
not.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: running PostGres without installing it
@ 2006-08-07 01:01 Amadeus Zilfinski <amadeus0@cox.net>
parent: Aaron Bono <postgresql@aranya.com>
0 siblings, 1 reply; 9+ messages in thread
From: Amadeus Zilfinski @ 2006-08-07 01:01 UTC (permalink / raw)
To: pgsql-admin
>
>
> Would something like SQLite support the full functionality that we get
> from PostgreSQL: subqueries, transactions, views, triggers and stored
> procedures? MySQL does not (yes I know they are adding some or all of
> this but it isn't all there or proven to be reliable yet).
>
> I will check SQLite out but MySQL is probably NOT a good option for
> this. Historically it did not support subqueries (an absolute must
> for any serious database user) - not sure if they have added subquery
> support recently or not.
>
SQLite goes for SQL '92 compliance whereas PostgresQL goes for I think
it is) '99 (or is it '95?) compliance.
http://sqlite.org/omitted.html tells you what is missing from the
software against the '92 standard. Against PostgresQL SQLite will lose
in the features department almost every time.
My only real issue with PostgresQL is that it is a client/server
database, that is not embeddable. If it was embeddable then I could use
it with no issue, and would in fact rather use it. I recall some people
are working on that, but don't have any links. You might want to try
www.postgresql.org and see if they any info on there.
AmadeusZ.-
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: running PostGres without installing it
@ 2006-08-07 01:47 Christopher Browne <cbbrowne@acm.org>
parent: Amadeus Zilfinski <amadeus0@cox.net>
0 siblings, 0 replies; 9+ messages in thread
From: Christopher Browne @ 2006-08-07 01:47 UTC (permalink / raw)
To: pgsql-admin
amadeus0@cox.net (Amadeus Zilfinski) wrote:
> My only real issue with PostgresQL is that it is a client/server
> database, that is not embeddable. If it was embeddable then I could
> use it with no issue, and would in fact rather use it. I recall some
> people are working on that, but don't have any links. You might want
> to try www.postgresql.org and see if they any info on there.
No, there is *not* an a set of people working on "making PostgresQL
embeddable"; it has been talked about, but never taken particularly
seriously.
There's a way to do *a sort of embedding*, but one that specifically
ignores the notion of doing this in an in-process manner.
You could hide a PostgresQL instance, using a variant port, generally
making it pretty hidden away. Initializing, starting, and stopping it
could be hidden inside the application.
But in no way would this be an embedding as is normally understood,
where all that's needful is to include a library and open the right
directory.
--
select 'cbbrowne' || '@' || 'gmail.com';
http://linuxdatabases.info/info/lisp.html
"Bureaucracies interpret communication as damage and route around it"
-- Jamie Zawinski
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: running PostGres without installing it
@ 2006-08-08 21:00 Darcy Buskermolen <darcyb@commandprompt.com>
parent: jesus martinez <jesus_martinez1967@yahoo.com.ar>
1 sibling, 0 replies; 9+ messages in thread
From: Darcy Buskermolen @ 2006-08-08 21:00 UTC (permalink / raw)
To: pgsql-admin; +Cc: jesus martinez <jesus_martinez1967@yahoo.com.ar>
On Saturday 05 August 2006 21:07, jesus martinez wrote:
> hello, how are you ?
>
> i want to distribute a copy of PostGres to my clients.
> they really dont know anything about installing
> programs or
> configurating remote RDBMS sql-servers,
> so i dont want to give them the
> "official-PostGres-installer.exe"
> but my own installer.exe (win32) that:
>
> 1) install the PostGres's required files
> 2) modify the system as PostGres needs (registry,
> paths, etc)
> 3) execute it as a process, not as a service (if it is
> possible)
> (it must run also on win98 machines)
PostgreSQLl needs an NT like system to run on, so 98 is not an option.
> 4) enable the server in a port readed from an INI file
> or
> something like that.
> 5) delete the default super-user or change its
> password
> 6) creates the tables-structure that my client-app
> needs
> 7a) insert the data or
> 7b) copy db-files to hdd, assign them in PostGres and
> make
> them available via PostGres.
> 8) create the dbuser that will be used by clients-apps
> 9) assign that dbuser to my tables
>
> all without any kind of user interaction.
>
> - where can i get information about the required
> information
> (i mean: basic required files, registry changes, conf
> files,
> sql commands to do what i need) ?
>
> - if this is not possible, may i call the default
> PostGre's
> installer in silent mode ? and if so, what are the
> command-lines
> to set the defaults settings ?
>
> - can any of you help me in any of those tasks ?
>
> thanks in advance,
>
>
>
>
>
>
> __________________________________________________
> Preguntá. Respondé. Descubrí.
> Todo lo que querías saber, y lo que ni imaginabas,
> está en Yahoo! Respuestas (Beta).
> ¡Probalo ya!
> http://www.yahoo.com.ar/respuestas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Darcy Buskermolen
CommandPrompt, Inc.
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
http://www.commandprompt.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: running PostGres without installing it
@ 2006-08-18 10:54 Magnus Hagander <mha@sollentuna.net>
parent: Aaron Bono <postgresql@aranya.com>
2 siblings, 0 replies; 9+ messages in thread
From: Magnus Hagander @ 2006-08-18 10:54 UTC (permalink / raw)
To: Aaron Bono <postgresql@aranya.com>; jesus martinez <jesus_martinez1967@yahoo.com.ar>; +Cc: pgsql-admin
> i want to distribute a copy of PostGres to my clients.
> they really dont know anything about installing
> programs or
> configurating remote RDBMS sql-servers,
> so i dont want to give them the
> "official-PostGres-installer.exe "
> but my own installer.exe (win32)
>
>
>
> I would love to know this too. Is there a way to just copy the
> PostgreSQL files to the hard drive without the installer, load up
> the database and start and stop it as an application rather than a
> service? A silent installer may solve the problem but what if you
> have 2 applications that both have installers and want to install
> PostgreSQL? The silent installer would need to be able to detect
> that it is already installed (which I think it already does) and
> then skip the PostgreSQL install without bugging the user (not sure
> it would do that).
It can be made to do that.
However, it should work just fine to copy the files and go from there.
You can get the binaries-no-instaler package on the web, but beware that
it does not contain all the dependencies. Another way to get the
"official version binaries" is to make an install on one machine and
then just copy everything from the directory you install it in. As of
8.1, postgresql puts *no files* in the Windows or SYSTEM32 directories.
Then you just start and stop the database using pg_ctl from inside your
app.
It's a lot more overhead than a db engine like access (JET) or sqlite,
but you do get a lot of extra features for that.
//Magnus
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2006-08-18 10:54 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-06 04:07 running PostGres without installing it jesus martinez <jesus_martinez1967@yahoo.com.ar>
2006-08-06 18:09 ` Aaron Bono <postgresql@aranya.com>
2006-08-06 19:11 ` Amadeus Zilfinski <amadeus0@cox.net>
2006-08-06 20:13 ` Aaron Bono <postgresql@aranya.com>
2006-08-07 01:01 ` Amadeus Zilfinski <amadeus0@cox.net>
2006-08-07 01:47 ` Christopher Browne <cbbrowne@acm.org>
2006-08-06 19:18 ` Chris Mair <chrisnospam@1006.org>
2006-08-18 10:54 ` Magnus Hagander <mha@sollentuna.net>
2006-08-08 21:00 ` Darcy Buskermolen <darcyb@commandprompt.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