pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
New project launched : PostgreSQL GUI Installer for Linux/Unix systems
38+ messages / 19 participants
[nested] [flat]

* New project launched : PostgreSQL GUI Installer for Linux/Unix systems
@ 2006-01-31 00:48  Devrim GUNDUZ <devrim@commandprompt.com>
  0 siblings, 5 replies; 38+ messages in thread

From: Devrim GUNDUZ @ 2006-01-31 00:48 UTC (permalink / raw)
  To: pgsql-hackers; pgsql-general@postgresql.org; +Cc: Burcu GUZEL <burcu.guzel@gmail.com>

Hi,

As you know, many databases that run on Linux / Unix systems have a GUI
installer which make installation easier and more attractive for some
people.

Our Windows Installer is very attractive, for example. 

Now, I and Burcu Guzel, who is a Senior Programmer, decided to launch a
new project: pgnixinstaller : 

http://pgfoundry.org/projects/pgnixinstaller/

We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We are in planning phase,
if you join us earlier, we will be able to share more ideas. 

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 01:03  Doug McNaught <doug@mcnaught.org>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  4 siblings, 1 reply; 38+ messages in thread

From: Doug McNaught @ 2006-01-31 01:03 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: pgsql-hackers; pgsql-general@postgresql.org, Burcu GUZEL <burcu.guzel@gmail.com>

Devrim GUNDUZ <devrim@commandprompt.com> writes:

> http://pgfoundry.org/projects/pgnixinstaller/
>
> We are actively looking for developers for the project. Please drop me
> an e-mail if you want to join this project. We will use Python, so you
> need to be a Python guy to join the project. We are in planning phase,
> if you join us earlier, we will be able to share more ideas. 

What value does this bring to systems that have a good package system
and up-to-date repositories?  I can install Postgres today on Ubuntu
using a GUI tool, and install another GUI tool to configure and
adminsiter it.

For systems like Solaris I can see it maybe being a win.

Are you going to work with the underlying system's package manager, or
put everything in /usr/local?

-Doug



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 01:13  Devrim GUNDUZ <devrim@commandprompt.com>
  parent: Doug McNaught <doug@mcnaught.org>
  0 siblings, 2 replies; 38+ messages in thread

From: Devrim GUNDUZ @ 2006-01-31 01:13 UTC (permalink / raw)
  To: Doug McNaught <doug@mcnaught.org>; +Cc: pgsql-hackers; pgsql-general@postgresql.org, Burcu GUZEL <burcu.guzel@gmail.com>

Hi,

On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:

> > We are actively looking for developers for the project. Please drop me
> > an e-mail if you want to join this project. We will use Python, so you
> > need to be a Python guy to join the project. We are in planning phase,
> > if you join us earlier, we will be able to share more ideas. 
> 
> What value does this bring to systems that have a good package system
> and up-to-date repositories?  I can install Postgres today on Ubuntu
> using a GUI tool, and install another GUI tool to configure and
> adminsiter it.

You can install, but what if you need different configure options than
the package provides? This means a rebuild of the package. Instead, we
will build and install that package via the installer.

OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
RPM interface for the repositories. So our installer will help them a
lot. Also, our installer will have an option to download and install the
prebuilt binaries from PostgreSQL FTP site (and possible other sites) 

> For systems like Solaris I can see it maybe being a win.

Agreed.

> Are you going to work with the underlying system's package manager, or
> put everything in /usr/local?

We'll work with the package manager -- I'm an RPM guy ;)

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




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

* Re: [HACKERS] New project launched : PostgreSQL GUI Installer
@ 2006-01-31 01:27  Andrew Dunstan <andrew@dunslane.net>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  1 sibling, 0 replies; 38+ messages in thread

From: Andrew Dunstan @ 2006-01-31 01:27 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: Doug McNaught <doug@mcnaught.org>; pgsql-hackers; pgsql-general@postgresql.org, Burcu GUZEL <burcu.guzel@gmail.com>



Devrim GUNDUZ wrote:

>OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
>RPM interface for the repositories. So our installer will help them a
>lot. Also, our installer will have an option to download and install the
>prebuilt binaries from PostgreSQL FTP site (and possible other sites) 
>
>  
>


There's yumex ... http://fedoranews.org/tchung/yumex/

cheers

andrew



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

* Re: New project launched : PostgreSQL GUI Installer for Linux/Unix systems
@ 2006-01-31 03:35  Christopher Browne <cbbrowne@acm.org>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  4 siblings, 2 replies; 38+ messages in thread

From: Christopher Browne @ 2006-01-31 03:35 UTC (permalink / raw)
  To: pgsql-hackers

> We are actively looking for developers for the project. Please drop me
> an e-mail if you want to join this project. We will use Python, so you
> need to be a Python guy to join the project. We are in planning phase,
> if you join us earlier, we will be able to share more ideas. 

You'd better define the purpose pretty clearly, as I don't see any
purpose that's of value, yet.

On my Debian systems, I can install PostgreSQL quite readily via the
command "apt-get install postgresql-8.1", which can get GUIed at least
somewhat if I run aptitude, synaptic, or such...

I could see there being some value in a GUI for managing postmaster
config files...
-- 
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/linuxdistributions.html
"High-level languages are a pretty good indicator that all else is
seldom equal." - Tim Bradshaw, comp.lang.lisp



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 03:52  Joshua D. Drake <jd@commandprompt.com>
  parent: Christopher Browne <cbbrowne@acm.org>
  1 sibling, 4 replies; 38+ messages in thread

From: Joshua D. Drake @ 2006-01-31 03:52 UTC (permalink / raw)
  To: Christopher Browne <cbbrowne@acm.org>; +Cc: pgsql-hackers

>
>
>On my Debian systems, I can install PostgreSQL quite readily via the
>command "apt-get install postgresql-8.1", which can get GUIed at least
>somewhat if I run aptitude, synaptic, or such...
>  
>
Yes Christopher, you can... I can, and Devrim can....

As more and more people come on board people are going to want to 
download a .exe (a metaphor),
double click and have it open an installer, they will then want to click 
next, next, continue, finish.

You don't get that with apt-get install.

There is a reason that even Oracle has a graphical installer on Linux, 
because most people installing
the software:

A. Don't know how to use it
B. Probably don't know how to use Linux
C. Don't want to.

Joshua D. Drake



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 03:58  Marc G. Fournier <scrappy@postgresql.org>
  parent: Joshua D. Drake <jd@commandprompt.com>
  3 siblings, 1 reply; 38+ messages in thread

From: Marc G. Fournier @ 2006-01-31 03:58 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

On Mon, 30 Jan 2006, Joshua D. Drake wrote:

>> 
>> 
>> On my Debian systems, I can install PostgreSQL quite readily via the
>> command "apt-get install postgresql-8.1", which can get GUIed at least
>> somewhat if I run aptitude, synaptic, or such...
>> 
> Yes Christopher, you can... I can, and Devrim can....
>
> As more and more people come on board people are going to want to download a 
> .exe (a metaphor),
> double click and have it open an installer, they will then want to click 
> next, next, continue, finish.
>
> You don't get that with apt-get install.
>
> There is a reason that even Oracle has a graphical installer on Linux, 
> because most people installing
> the software:
>
> A. Don't know how to use it
> B. Probably don't know how to use Linux
> C. Don't want to.

i can't agree more ... I don't care whether you are running FreeBSD or 
Linux or Solaris ... if you want broader adoption of non-Microsoft OSs, 
you have to make it simplier for 'the masses' to make use of ... and GUIs 
tend to follow KISS very closely ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 04:13  Rick Gigger <rick@alpinenetworking.com>
  parent: Marc G. Fournier <scrappy@postgresql.org>
  0 siblings, 1 reply; 38+ messages in thread

From: Rick Gigger @ 2006-01-31 04:13 UTC (permalink / raw)
  To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

I don't see why anyone has a problem with this.  I am certainly never  
going to use it but if it helps someone who isn't a linux person to  
use it on a project when they would have used something else (like  
mysql) or if it convinces someone to run postgres on linux instead of  
windows because they now have a graphical installer on linux then it  
seems like a good thing to me.  More users = bigger community =  
larger potential pool of people to help out.  Even if people can't  
code they can answer newbie (or advanced) questions on the mailing  
lists or write documentation or even just tell their dba friends  
about it.

The more people using postgres the better.  If this will help then  
I'm all for it.  Just because I would rather do a ./configure make  
make install doesn't mean that thats the best route for everyone.

Rick


On Jan 30, 2006, at 8:58 PM, Marc G. Fournier wrote:

> On Mon, 30 Jan 2006, Joshua D. Drake wrote:
>
>>> On my Debian systems, I can install PostgreSQL quite readily via the
>>> command "apt-get install postgresql-8.1", which can get GUIed at  
>>> least
>>> somewhat if I run aptitude, synaptic, or such...
>> Yes Christopher, you can... I can, and Devrim can....
>>
>> As more and more people come on board people are going to want to  
>> download a .exe (a metaphor),
>> double click and have it open an installer, they will then want to  
>> click next, next, continue, finish.
>>
>> You don't get that with apt-get install.
>>
>> There is a reason that even Oracle has a graphical installer on  
>> Linux, because most people installing
>> the software:
>>
>> A. Don't know how to use it
>> B. Probably don't know how to use Linux
>> C. Don't want to.
>
> i can't agree more ... I don't care whether you are running FreeBSD  
> or Linux or Solaris ... if you want broader adoption of non- 
> Microsoft OSs, you have to make it simplier for 'the masses' to  
> make use of ... and GUIs tend to follow KISS very closely ...
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http:// 
> www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ:  
> 7615664
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 04:41  Jeffrey W. Baker <jwbaker@acm.org>
  parent: Joshua D. Drake <jd@commandprompt.com>
  3 siblings, 2 replies; 38+ messages in thread

From: Jeffrey W. Baker @ 2006-01-31 04:41 UTC (permalink / raw)
  To: pgsql-hackers

On Mon, 2006-01-30 at 19:52 -0800, Joshua D. Drake wrote:
> >
> >
> >On my Debian systems, I can install PostgreSQL quite readily via the
> >command "apt-get install postgresql-8.1", which can get GUIed at least
> >somewhat if I run aptitude, synaptic, or such...
> >  
> >
> Yes Christopher, you can... I can, and Devrim can....
> 
> As more and more people come on board people are going to want to 
> download a .exe (a metaphor),
> double click and have it open an installer, they will then want to click 
> next, next, continue, finish.

There is such a thing as best practices.  If you install postgresql in
this glorious graphical manner, what will prevent you from accidentally
upgrading a shared library which postgresql depends upon?  Nothing,
really, unless this installer is going to be able to customize, build,
and install a native package on all the target operating systems.

How will you do an orderly upgrade from one revision to the next,
including all the dependencies?  How will you distribute security
updates?

I predict this form of installation will cause a great many support
headaches as users report problems which are caused by oddball
compilers, strange CFLAGS, unreleased or strangely patched versions of
shared libraries and headers, and so forth.

> You don't get that with apt-get install.

Right, with apt-get install you get a package built with a known-good
compiler, known-sane configure flags, and a method of pinning the
dependencies, which passes at the very least a smoketest on Alpha,
AMD64, ARM, HPPA, x86, IA64, 640x0, MIPS, PowerPC, S/390, and SPARC.

> There is a reason that even Oracle has a graphical installer on Linux, 
> because most people installing
> the software:
> 
> A. Don't know how to use it
> B. Probably don't know how to use Linux
> C. Don't want to.

Oracle's graphical installer is a material impediment to Oracle
adoption.  The installer only works on systems where particular versions
of Java and Motif libraries are available.  On 64-bit Opteron systems it
only works with the peculiar 32-bit thunking tree favored by Red Hat and
hardly anybody else.

If I could install Oracle on Debian/AMD64 with a shell script, I'd drop
Postgresql in a heartbeat.

Obviously anybody is welcome and able to just write whatever software
they feel is needed, but go ahead and count me among the skeptics.

-jwb




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

* Re: [HACKERS] New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 04:48  Tony Caduto <tony.caduto@amsoftwaredesign.com>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  4 siblings, 1 reply; 38+ messages in thread

From: Tony Caduto @ 2006-01-31 04:48 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: pgsql-hackers@postgresql.org, Pgsql-General General <pgsql-general@postgresql.org>

Devrim GUNDUZ wrote:

Have you looked at AutoPackage?

http://autopackage.org

screen shots.

http://autopackage.org/gallery.html

Has a GUI wizard if X windows is available and a command line wizard if 
no X is available.


Using autopackage is similar to using MSI,Wise,Inno etc on Windows.

Later,

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



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 04:53  Joshua D. Drake <jd@commandprompt.com>
  parent: Jeffrey W. Baker <jwbaker@acm.org>
  1 sibling, 2 replies; 38+ messages in thread

From: Joshua D. Drake @ 2006-01-31 04:53 UTC (permalink / raw)
  To: Jeffrey W. Baker <jwbaker@acm.org>; +Cc: pgsql-hackers


> Oracle's graphical installer is a material impediment to Oracle
> adoption.  The installer only works on systems where particular versions
> of Java and Motif libraries are available.  On 64-bit Opteron systems it
> only works with the peculiar 32-bit thunking tree favored by Red Hat and
> hardly anybody else.
>
> If I could install Oracle on Debian/AMD64 with a shell script, I'd drop
> Postgresql in a heartbeat.
>
> Obviously anybody is welcome and able to just write whatever software
> they feel is needed, but go ahead and count me among the skeptics.
>   
The installer is for the 98% not the 2%. You are in the 2%.

Joshua D. Drake

> -jwb
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>   


-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 05:00  Jeffrey W. Baker <jwbaker@acm.org>
  parent: Joshua D. Drake <jd@commandprompt.com>
  1 sibling, 1 reply; 38+ messages in thread

From: Jeffrey W. Baker @ 2006-01-31 05:00 UTC (permalink / raw)
  To: pgsql-hackers

On Mon, 2006-01-30 at 20:53 -0800, Joshua D. Drake wrote:
> > Oracle's graphical installer is a material impediment to Oracle
> > adoption.  The installer only works on systems where particular versions
> > of Java and Motif libraries are available.  On 64-bit Opteron systems it
> > only works with the peculiar 32-bit thunking tree favored by Red Hat and
> > hardly anybody else.
> >
> > If I could install Oracle on Debian/AMD64 with a shell script, I'd drop
> > Postgresql in a heartbeat.
> >
> > Obviously anybody is welcome and able to just write whatever software
> > they feel is needed, but go ahead and count me among the skeptics.
> >   
> The installer is for the 98% not the 2%. You are in the 2%.

Right, and it would make FAR more sense if Oracle just shipped the whole
thing, operating system and the works, on a single installer image.

So why don't you just do that with Postgres?  You could call it
"Bootable PostgreSQL".  It would be a big hit.  When a new version comes
out, you can just mail out a new DVD.

That would be a lot better than pretending to know how to fit in, best
practices and the works, with all the various Unix systems out there.

-jwb




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 05:12  Josh Berkus <josh@agliodbs.com>
  parent: Jeffrey W. Baker <jwbaker@acm.org>
  0 siblings, 0 replies; 38+ messages in thread

From: Josh Berkus @ 2006-01-31 05:12 UTC (permalink / raw)
  To: Jeffrey W. Baker <jwbaker@acm.org>; +Cc: pgsql-hackers

Jeff,

> So why don't you just do that with Postgres?  You could call it
> "Bootable PostgreSQL".  It would be a big hit.  When a new version comes
> out, you can just mail out a new DVD.

Actually, we have these.  We give them out at conferences.

--Josh



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

* Re: [GENERAL] New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 06:28  Steve Atkins <steve@blighty.com>
  parent: Tony Caduto <tony.caduto@amsoftwaredesign.com>
  0 siblings, 0 replies; 38+ messages in thread

From: Steve Atkins @ 2006-01-31 06:28 UTC (permalink / raw)
  To: pgsql-hackers


On Jan 30, 2006, at 8:48 PM, Tony Caduto wrote:

> Devrim GUNDUZ wrote:
>
> Have you looked at AutoPackage?
>
> http://autopackage.org
>
> screen shots.
>
> http://autopackage.org/gallery.html
>
> Has a GUI wizard if X windows is available and a command line  
> wizard if no X is available.
>
>
> Using autopackage is similar to using MSI,Wise,Inno etc on Windows.

If that's the one that uses aptools it looks _excellent_. Until you try
and use it. It looked as though it would solve many of my packaging
problems, not least deploying on older platforms than the build box,
but simply didn't work on anything more complex than toy code.

I suspect that if you were just using it as a general installer, rather
than any of the portability magic, it might be worth a look.

Cheers,
   Steve



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 06:55  J. Andrew Rogers <jrogers@neopolitan.com>
  parent: Joshua D. Drake <jd@commandprompt.com>
  3 siblings, 1 reply; 38+ messages in thread

From: J. Andrew Rogers @ 2006-01-31 06:55 UTC (permalink / raw)
  To: pgsql-hackers

On Jan 30, 2006, at 7:52 PM, Joshua D. Drake wrote:
> There is a reason that even Oracle has a graphical installer on  
> Linux, because most people installing
> the software:
>
> A. Don't know how to use it
> B. Probably don't know how to use Linux
> C. Don't want to.


Except that the Oracle "graphical installer" usually requires a non- 
trivial amount of command line kung-fu that alone is more complex  
than the entirety of the command line installation of PostgreSQL.   
Oracle installation is an unpleasant and painful process even under  
the best of circumstances, and I've never had one that required less  
effort than Postgres for a vanilla install.  And I always install  
postgres from source.  If "./configure; make; make install" scares  
away people, sorting out the dependency hell getting the Oracle  
installer to even run on nominally supported platforms will  
definitely scare them away.

A graphical installer for Unix is fine, but please, do not make it  
anything like Oracle's graphical installer.  Oracle's graphical  
install process gives command line installs a good name for ease of use.


J. Andrew Rogers




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

* Re: [HACKERS] New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 07:34  Tino Wildenhain <tino@wildenhain.de>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  4 siblings, 1 reply; 38+ messages in thread

From: Tino Wildenhain @ 2006-01-31 07:34 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: pgsql-hackers; pgsql-general@postgresql.org, Burcu GUZEL <burcu.guzel@gmail.com>

Devrim GUNDUZ schrieb:
> Hi,
> 
> As you know, many databases that run on Linux / Unix systems have a GUI
> installer which make installation easier and more attractive for some
> people.

If you think of the *racle-GUI-Installer, most people find it very
s*cking ;)

> Our Windows Installer is very attractive, for example. 
> 
> Now, I and Burcu Guzel, who is a Senior Programmer, decided to launch a
> new project: pgnixinstaller : 
> 
> http://pgfoundry.org/projects/pgnixinstaller/
> 
> We are actively looking for developers for the project. Please drop me
> an e-mail if you want to join this project. We will use Python, so you
> need to be a Python guy to join the project. We are in planning phase,
> if you join us earlier, we will be able to share more ideas. 

Might be fun of course. But on unix you usually have some kind
of package system anyway - how is the installer supposed to
play nicely with them?

Regards
Tino



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 07:36  Tino Wildenhain <tino@wildenhain.de>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  1 sibling, 1 reply; 38+ messages in thread

From: Tino Wildenhain @ 2006-01-31 07:36 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: Doug McNaught <doug@mcnaught.org>; pgsql-hackers; pgsql-general@postgresql.org, Burcu GUZEL <burcu.guzel@gmail.com>

Devrim GUNDUZ schrieb:
> Hi,
> 
...
>>Are you going to work with the underlying system's package manager, or
>>put everything in /usr/local?
> 
> 
> We'll work with the package manager -- I'm an RPM guy ;)
> 
RPM isnt the only packaging system out there ;)



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 07:49  Tino Wildenhain <tino@wildenhain.de>
  parent: Joshua D. Drake <jd@commandprompt.com>
  3 siblings, 0 replies; 38+ messages in thread

From: Tino Wildenhain @ 2006-01-31 07:49 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

Joshua D. Drake schrieb:
...
> As more and more people come on board people are going to want to 
> download a .exe (a metaphor),
> double click and have it open an installer, they will then want to click 
> next, next, continue, finish.
> 
> You don't get that with apt-get install.

Well you can use a frontend and search and click as well. I see no
problem - and it really works, as opposed to:

> There is a reason that even Oracle has a graphical installer on Linux, 
> because most people installing
> the software:
> 
> A. Don't know how to use it
> B. Probably don't know how to use Linux
> C. Don't want to.
Hehehe. Did you actually use this installer? I did! And lets tell you,
you dont come by w/o any linux/unix knowledge.

Regards
Tino



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 07:54  Tino Wildenhain <tino@wildenhain.de>
  parent: Rick Gigger <rick@alpinenetworking.com>
  0 siblings, 1 reply; 38+ messages in thread

From: Tino Wildenhain @ 2006-01-31 07:54 UTC (permalink / raw)
  To: Rick Gigger <rick@alpinenetworking.com>; +Cc: Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

Rick Gigger schrieb:
> I don't see why anyone has a problem with this.  I am certainly never  
> going to use it but if it helps someone who isn't a linux person to  use 
> it on a project when they would have used something else (like  mysql) 
> or if it convinces someone to run postgres on linux instead of  windows 
> because they now have a graphical installer on linux then it  seems like 
> a good thing to me.  More users = bigger community =  larger potential 
> pool of people to help out.  Even if people can't  code they can answer 
> newbie (or advanced) questions on the mailing  lists or write 
> documentation or even just tell their dba friends  about it.
> 
> The more people using postgres the better.  If this will help then  I'm 
> all for it.  Just because I would rather do a ./configure make  make 
> install doesn't mean that thats the best route for everyone.

As was said, a gui to produce postgresql.conf files (off host)
can be of value. Also for the tune-people a package builder
can be useful too.

For other people - if they dont learn a bit about their package system
on their choosen system - they will run into other problems soon or
later.




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 09:15  Dave Page <dpage@vale-housing.co.uk>
  0 siblings, 2 replies; 38+ messages in thread

From: Dave Page @ 2006-01-31 09:15 UTC (permalink / raw)
  To: Tino Wildenhain <tino@wildenhain.de>; Rick Gigger <rick@alpinenetworking.com>; +Cc: Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

 

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org 
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Tino 
> Wildenhain
> Sent: 31 January 2006 07:55
> To: Rick Gigger
> Cc: Marc G. Fournier; Joshua D. Drake; Christopher Browne; 
> pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] New project launched : PostgreSQL GUI 
> Installer for
> 
> As was said, a gui to produce postgresql.conf files (off host)
> can be of value. 

pgAdmin?

Regards, Dave.



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 09:16  Devrim GUNDUZ <devrim@commandprompt.com>
  parent: Tino Wildenhain <tino@wildenhain.de>
  0 siblings, 0 replies; 38+ messages in thread

From: Devrim GUNDUZ @ 2006-01-31 09:16 UTC (permalink / raw)
  To: Tino Wildenhain <tino@wildenhain.de>; +Cc: Doug McNaught <doug@mcnaught.org>; pgsql-hackers; pgsql-general@postgresql.org, Burcu GUZEL <burcu.guzel@gmail.com>

Hi,

On Tue, 2006-01-31 at 08:36 +0100, Tino Wildenhain wrote:

> >>Are you going to work with the underlying system's package manager, or
> >>put everything in /usr/local?
> > 
> > 
> > We'll work with the package manager -- I'm an RPM guy ;)
> > 
> RPM isnt the only packaging system out there ;)

I used RPM as an alias to package managers :)

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




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

* Re: [HACKERS] New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 09:16  Devrim GUNDUZ <devrim@commandprompt.com>
  parent: Tino Wildenhain <tino@wildenhain.de>
  0 siblings, 0 replies; 38+ messages in thread

From: Devrim GUNDUZ @ 2006-01-31 09:16 UTC (permalink / raw)
  To: Tino Wildenhain <tino@wildenhain.de>; +Cc: pgsql-hackers; pgsql-general@postgresql.org, Burcu GUZEL <burcu.guzel@gmail.com>

Hi,

On Tue, 2006-01-31 at 08:34 +0100, Tino Wildenhain wrote:
  
> > http://pgfoundry.org/projects/pgnixinstaller/
> > 
> > We are actively looking for developers for the project. Please drop me
> > an e-mail if you want to join this project. We will use Python, so you
> > need to be a Python guy to join the project. We are in planning phase,
> > if you join us earlier, we will be able to share more ideas. 
> 
> Might be fun of course. But on unix you usually have some kind
> of package system anyway - how is the installer supposed to
> play nicely with them?

Yes,

We will try to stick the file locations of those package managers. We
already have that KB.

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 09:16  Devrim GUNDUZ <devrim@commandprompt.com>
  parent: Jeffrey W. Baker <jwbaker@acm.org>
  1 sibling, 0 replies; 38+ messages in thread

From: Devrim GUNDUZ @ 2006-01-31 09:16 UTC (permalink / raw)
  To: Jeffrey W. Baker <jwbaker@acm.org>; +Cc: pgsql-hackers; Burcu GUZEL <burcu.guzel@gmail.com>

Hi,

On Mon, 2006-01-30 at 20:41 -0800, Jeffrey W. Baker wrote:

> How will you do an orderly upgrade from one revision to the next,
> including all the dependencies?

We are still in planning phase, any ideas of how to do that is welcome.

> How will you distribute security updates?

We are still in planning phase, any ideas of how to do that is welcome.

> I predict this form of installation will cause a great many support
> headaches as users report problems which are caused by oddball
> compilers, strange CFLAGS, unreleased or strangely patched versions of
> shared libraries and headers, and so forth.

I can't see a problem in here. We already have platform test results in
pgbuildfarm and we have the knowledbase about the configure options,
flags etc. in that platforms.

> Obviously anybody is welcome and able to just write whatever software
> they feel is needed, but go ahead and count me among the skeptics.

The world is not turning around us, and please don't be skeptic on a
piece of software that you won't use but some people will.

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 09:16  Devrim GUNDUZ <devrim@commandprompt.com>
  parent: Christopher Browne <cbbrowne@acm.org>
  1 sibling, 2 replies; 38+ messages in thread

From: Devrim GUNDUZ @ 2006-01-31 09:16 UTC (permalink / raw)
  To: Christopher Browne <cbbrowne@acm.org>; +Cc: pgsql-hackers; Burcu GUZEL <burcu.guzel@gmail.com>

Hi,

On Mon, 2006-01-30 at 19:35 -0800, Christopher Browne wrote:
> > We are actively looking for developers for the project. Please drop me
> > an e-mail if you want to join this project. We will use Python, so you
> > need to be a Python guy to join the project. We are in planning phase,
> > if you join us earlier, we will be able to share more ideas. 
> 
> You'd better define the purpose pretty clearly, as I don't see any
> purpose that's of value, yet.

I agree with Joshua's points here. Think of people who do not want an
installation via command line.

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 09:24  Devrim GUNDUZ <devrim@commandprompt.com>
  parent: Dave Page <dpage@vale-housing.co.uk>
  1 sibling, 0 replies; 38+ messages in thread

From: Devrim GUNDUZ @ 2006-01-31 09:24 UTC (permalink / raw)
  To: Dave Page <dpage@vale-housing.co.uk>; +Cc: Tino Wildenhain <tino@wildenhain.de>; Rick Gigger <rick@alpinenetworking.com>; Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers; Burcu GUZEL <burcu.guzel@gmail.com>

Hi,

On Tue, 2006-01-31 at 09:15 +0000, Dave Page wrote:

> > As was said, a gui to produce postgresql.conf files (off host)
> > can be of value. 
> 
> pgAdmin?

Installer should "produce" a postgresql.conf, based on some selections
via the interface. Then we will use pgAdmin to edit, improve, etc.
postgresql.conf.

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 09:27  Dave Page <dpage@vale-housing.co.uk>
  0 siblings, 0 replies; 38+ messages in thread

From: Dave Page @ 2006-01-31 09:27 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: Tino Wildenhain <tino@wildenhain.de>; Rick Gigger <rick@alpinenetworking.com>; Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers; Burcu GUZEL <burcu.guzel@gmail.com>

 

> -----Original Message-----
> From: Devrim GUNDUZ [mailto:devrim@commandprompt.com] 
> Sent: 31 January 2006 09:25
> To: Dave Page
> Cc: Tino Wildenhain; Rick Gigger; Marc G. Fournier; Joshua D. 
> Drake; Christopher Browne; pgsql-hackers@postgresql.org; Burcu GUZEL
> Subject: Re: [HACKERS] New project launched : PostgreSQL GUI 
> Installer for
> 
> Hi,
> 
> On Tue, 2006-01-31 at 09:15 +0000, Dave Page wrote:
> 
> > > As was said, a gui to produce postgresql.conf files (off host)
> > > can be of value. 
> > 
> > pgAdmin?
> 
> Installer should "produce" a postgresql.conf, based on some selections
> via the interface. Then we will use pgAdmin to edit, improve, etc.
> postgresql.conf.

Yeah, that's pretty much how pgInstaller works - we let initdb create
the config file, then tweak some values using some C code. The user can
then use pgAdmin (or a text editor) to tweak to taste.

Regards, Dave.



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 10:53  Tino Wildenhain <tino@wildenhain.de>
  parent: Dave Page <dpage@vale-housing.co.uk>
  1 sibling, 0 replies; 38+ messages in thread

From: Tino Wildenhain @ 2006-01-31 10:53 UTC (permalink / raw)
  To: Dave Page <dpage@vale-housing.co.uk>; +Cc: Rick Gigger <rick@alpinenetworking.com>; Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

Dave Page schrieb:
>  
...
>>As was said, a gui to produce postgresql.conf files (off host)
>>can be of value. 
> 
> 
> pgAdmin?

Well, strictly spoken a gui text editor is a gui... but I rather
had in mind something guided with buttons, select boxes and stuff
and references to documentation, calculations and the like.

  :-)

Tino



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 10:57  Dave Page <dpage@vale-housing.co.uk>
  0 siblings, 1 reply; 38+ messages in thread

From: Dave Page @ 2006-01-31 10:57 UTC (permalink / raw)
  To: Tino Wildenhain <tino@wildenhain.de>; +Cc: Rick Gigger <rick@alpinenetworking.com>; Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

 

> -----Original Message-----
> From: Tino Wildenhain [mailto:tino@wildenhain.de] 
> Sent: 31 January 2006 10:53
> To: Dave Page
> Cc: Rick Gigger; Marc G. Fournier; Joshua D. Drake; 
> Christopher Browne; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] New project launched : PostgreSQL GUI 
> Installer for
> 
> Dave Page schrieb:
> >  
> ...
> >>As was said, a gui to produce postgresql.conf files (off host)
> >>can be of value. 
> > 
> > 
> > pgAdmin?
> 
> Well, strictly spoken a gui text editor is a gui... but I rather
> had in mind something guided with buttons, select boxes and stuff
> and references to documentation, calculations and the like.
> 
>   :-)

Err, yes. pgAdmin? It's somewhat more than a simple text editor.

:-)

/D



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 11:09  Tino Wildenhain <tino@wildenhain.de>
  parent: Dave Page <dpage@vale-housing.co.uk>
  0 siblings, 1 reply; 38+ messages in thread

From: Tino Wildenhain @ 2006-01-31 11:09 UTC (permalink / raw)
  To: Dave Page <dpage@vale-housing.co.uk>; +Cc: Rick Gigger <rick@alpinenetworking.com>; Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

Dave Page schrieb:
...
>>
>>Well, strictly spoken a gui text editor is a gui... but I rather
>>had in mind something guided with buttons, select boxes and stuff
>>and references to documentation, calculations and the like.
>>
>>  :-)
> 
> 
> Err, yes. pgAdmin? It's somewhat more than a simple text editor.

Ah, right ;) Didnt see it in action before :-) Now when I actually
load a postgresql.conf file I see what you mean. Nice job :-)

Figuring out the correct values for some of the buffers and costs
is still a bit tough. Otoh, I guess there is no easy way to predict
all these.

Regards
Tino




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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 11:46  Andreas Pflug <pgadmin@pse-consulting.de>
  parent: Tino Wildenhain <tino@wildenhain.de>
  0 siblings, 1 reply; 38+ messages in thread

From: Andreas Pflug @ 2006-01-31 11:46 UTC (permalink / raw)
  To: Tino Wildenhain <tino@wildenhain.de>; +Cc: Dave Page <dpage@vale-housing.co.uk>; Rick Gigger <rick@alpinenetworking.com>; Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

Tino Wildenhain wrote:

> 
> Figuring out the correct values for some of the buffers and costs
> is still a bit tough. Otoh, I guess there is no easy way to predict
> all these.

pgAdmin has a mechanism to suggest values (currently for autovacuum and 
listen_address only), which waits for expansion :-) I could think of a 
wizard that asks decent questions, resulting in proposals.

Whether implemented as GUI or not, a questionaire and suggested 
algorithms to calculate settings (eyeballed from Core) would be a good 
starting point.

Regards,
Andreas



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 14:06  Christopher Browne <cbbrowne@acm.org>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  1 sibling, 0 replies; 38+ messages in thread

From: Christopher Browne @ 2006-01-31 14:06 UTC (permalink / raw)
  To: pgsql-hackers

> Hi,
>
> On Mon, 2006-01-30 at 19:35 -0800, Christopher Browne wrote:
>> > We are actively looking for developers for the project. Please
>> > drop me an e-mail if you want to join this project. We will use
>> > Python, so you need to be a Python guy to join the project. We
>> > are in planning phase, if you join us earlier, we will be able to
>> > share more ideas.
>> 
>> You'd better define the purpose pretty clearly, as I don't see any
>> purpose that's of value, yet.
>
> I agree with Joshua's points here. Think of people who do not want
> an installation via command line.

When virtually every flavour of Unix has its own package manager, I
have difficulty distinguishing this from the "badness" of how Oracle's
installer handles things.

The people I imagine would be of interest as plausible new users are
the ones that don't want to be troubled with configuring pretty well
anything at all, command line or no.

The sort of thing that would get PostgreSQL much more widely deployed
would be (for instance) for applications like GnuCash or components of
GNOME/KDE to adopt it as their storage mechanism.  Their developers
are not particularly interested in doing a lot of DBA work, e.g. -
setting up users, pg_hba.conf, and such.  (The need for this is one of
the reasons the GnuCash people have been biasing towards SQLite...)

It's worth noting that GNOME/KDE projects have NOT attempted to build
their own GUI installers except in the forms of very platform-specific
things.  In that regard, they let each platform have its own set of
"idioms."
-- 
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/slony.html
CBS News report on Fort Worth tornado damage:
"Eight major downtown buildings were severely damaged and 1,000 homes
were damaged, with 95 uninhabitable.  Gov. George W. Bush declared
Tarrant County a disaster area.  Federal Emergency Management Agency
workers are expected to arrive sometime next week after required
paperwork is completed."



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 14:32  Richard Huxton <dev@archonet.com>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  1 sibling, 0 replies; 38+ messages in thread

From: Richard Huxton @ 2006-01-31 14:32 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: Christopher Browne <cbbrowne@acm.org>; pgsql-hackers; Burcu GUZEL <burcu.guzel@gmail.com>

Devrim GUNDUZ wrote:
> Hi,
> 
> On Mon, 2006-01-30 at 19:35 -0800, Christopher Browne wrote:
>>> We are actively looking for developers for the project. Please drop me
>>> an e-mail if you want to join this project. We will use Python, so you
>>> need to be a Python guy to join the project. We are in planning phase,
>>> if you join us earlier, we will be able to share more ideas. 
>> You'd better define the purpose pretty clearly, as I don't see any
>> purpose that's of value, yet.
> 
> I agree with Joshua's points here. Think of people who do not want an
> installation via command line.

Surely the only people installing from the command-line are those that 
want to. There's synaptic or yum or whatever to let you search for 
"postgresql" and handle all your dependencies for you.

I mean *I* compile from source when I'm testing betas or want to 
backport and there's no package but I can't imagine most Ubuntu users 
bother.

Now something to let you install extra modules, tune your 
postgresql.conf and pg_hba.conf - that's useful. If it can explain as it 
goes along, all the better (like "bastille linux"?)

-- 
   Richard Huxton
   Archonet Ltd



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 15:10  Bricklen Anderson <banderson@presinet.com>
  parent: J. Andrew Rogers <jrogers@neopolitan.com>
  0 siblings, 0 replies; 38+ messages in thread

From: Bricklen Anderson @ 2006-01-31 15:10 UTC (permalink / raw)
  To: J. Andrew Rogers <jrogers@neopolitan.com>; +Cc: pgsql-hackers

J. Andrew Rogers wrote:
<snip>
> A graphical installer for Unix is fine, but please, do not make it  
> anything like Oracle's graphical installer.  Oracle's graphical  install 
> process gives command line installs a good name for ease of use.
> 
> 
> J. Andrew Rogers

I heartily second that!



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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 15:56  Rick Gigger <rick@alpinenetworking.com>
  parent: Tino Wildenhain <tino@wildenhain.de>
  0 siblings, 0 replies; 38+ messages in thread

From: Rick Gigger @ 2006-01-31 15:56 UTC (permalink / raw)
  To: Tino Wildenhain <tino@wildenhain.de>; +Cc: Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

On Jan 31, 2006, at 12:54 AM, Tino Wildenhain wrote:

> Rick Gigger schrieb:
>> I don't see why anyone has a problem with this.  I am certainly  
>> never  going to use it but if it helps someone who isn't a linux  
>> person to  use it on a project when they would have used something  
>> else (like  mysql) or if it convinces someone to run postgres on  
>> linux instead of  windows because they now have a graphical  
>> installer on linux then it  seems like a good thing to me.  More  
>> users = bigger community =  larger potential pool of people to  
>> help out.  Even if people can't  code they can answer newbie (or  
>> advanced) questions on the mailing  lists or write documentation  
>> or even just tell their dba friends  about it.
>> The more people using postgres the better.  If this will help  
>> then  I'm all for it.  Just because I would rather do a ./ 
>> configure make  make install doesn't mean that thats the best  
>> route for everyone.
>
> As was said, a gui to produce postgresql.conf files (off host)
> can be of value. Also for the tune-people a package builder
> can be useful too.
>
> For other people - if they dont learn a bit about their package system
> on their choosen system - they will run into other problems soon or
> later.

Why would the necessarily have to run into problem with their  
packaging system.  If someone installs from source it doesn't cause  
problems with packaging systems.  Why should this have to be any  
different?





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

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 18:57  Jim C. Nasby <jnasby@pervasive.com>
  parent: Joshua D. Drake <jd@commandprompt.com>
  1 sibling, 0 replies; 38+ messages in thread

From: Jim C. Nasby @ 2006-01-31 18:57 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Jeffrey W. Baker <jwbaker@acm.org>; pgsql-hackers

On Mon, Jan 30, 2006 at 08:53:54PM -0800, Joshua D. Drake wrote:
> >If I could install Oracle on Debian/AMD64 with a shell script, I'd drop
> >Postgresql in a heartbeat.
> >
> >Obviously anybody is welcome and able to just write whatever software
> >they feel is needed, but go ahead and count me among the skeptics.
> >  
> The installer is for the 98% not the 2%. You are in the 2%.

I've yet to find *anyone* who likes the Oracle installer. It's
absolutely the last thing I would use as a point of reference.

Come to think of it, the DB2 installer was a pile of crap as well...

My concern with this installer is that people are going to show up in
-general or on IRC in droves with dependancy related problems with the
installer. IMO it would be *much* better if we instead focused on
something that made it easy to install stuff out of contrib and/or
pgFoundry (and prefferably could be used without a GUI).

But, OSS works by people scratching itches, so if there's folks who want
to scratch this itch...
-- 
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] 38+ messages in thread

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 19:02  Jim C. Nasby <jnasby@pervasive.com>
  parent: Andreas Pflug <pgadmin@pse-consulting.de>
  0 siblings, 1 reply; 38+ messages in thread

From: Jim C. Nasby @ 2006-01-31 19:02 UTC (permalink / raw)
  To: Andreas Pflug <pgadmin@pse-consulting.de>; +Cc: Tino Wildenhain <tino@wildenhain.de>; Dave Page <dpage@vale-housing.co.uk>; Rick Gigger <rick@alpinenetworking.com>; Marc G. Fournier <scrappy@postgresql.org>; Joshua D. Drake <jd@commandprompt.com>; Christopher Browne <cbbrowne@acm.org>; pgsql-hackers

On Tue, Jan 31, 2006 at 11:46:03AM +0000, Andreas Pflug wrote:
> Tino Wildenhain wrote:
> 
> >
> >Figuring out the correct values for some of the buffers and costs
> >is still a bit tough. Otoh, I guess there is no easy way to predict
> >all these.
> 
> pgAdmin has a mechanism to suggest values (currently for autovacuum and 
> listen_address only), which waits for expansion :-) I could think of a 
> wizard that asks decent questions, resulting in proposals.
> 
> Whether implemented as GUI or not, a questionaire and suggested 
> algorithms to calculate settings (eyeballed from Core) would be a good 
> starting point.

PostgreSQL *desperately* needs a better means of dealing with
configuration (though I guess I shouldn't be pushing too hard for this
since the current state of affairs brings me business). Any improvement
in this area would be very welcome.
http://pgfoundry.org/projects/configurator/ is something worth looking
at.
-- 
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] 38+ messages in thread

* Re: New project launched : PostgreSQL GUI Installer for
@ 2006-01-31 20:01  Jeffrey W. Baker <jwbaker@acm.org>
  parent: Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 0 replies; 38+ messages in thread

From: Jeffrey W. Baker @ 2006-01-31 20:01 UTC (permalink / raw)
  To: pgsql-hackers

On Tue, 2006-01-31 at 13:02 -0600, Jim C. Nasby wrote:
> On Tue, Jan 31, 2006 at 11:46:03AM +0000, Andreas Pflug wrote:
> > Tino Wildenhain wrote:
> > 
> > >
> > >Figuring out the correct values for some of the buffers and costs
> > >is still a bit tough. Otoh, I guess there is no easy way to predict
> > >all these.
> > 
> > pgAdmin has a mechanism to suggest values (currently for autovacuum and 
> > listen_address only), which waits for expansion :-) I could think of a 
> > wizard that asks decent questions, resulting in proposals.
> > 
> > Whether implemented as GUI or not, a questionaire and suggested 
> > algorithms to calculate settings (eyeballed from Core) would be a good 
> > starting point.
> 
> PostgreSQL *desperately* needs a better means of dealing with
> configuration (though I guess I shouldn't be pushing too hard for this
> since the current state of affairs brings me business). Any improvement
> in this area would be very welcome.
> http://pgfoundry.org/projects/configurator/ is something worth looking
> at.

An ideal facility would be a program that analyzes the workload at
runtime and adjusts accordingly.  That doesn't sound too hard, within
some unambitious boundary.  If anyone would like to work on this, I'd be
happy to contribute.

-jwb



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

* Re: New project launched : PostgreSQL GUI Installer for Linux/Unix
@ 2006-02-05 21:49  August Zajonc <augustz@augustz.com>
  parent: Devrim GUNDUZ <devrim@commandprompt.com>
  4 siblings, 0 replies; 38+ messages in thread

From: August Zajonc @ 2006-02-05 21:49 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>

Devrim GUNDUZ wrote:
> Hi,
> 
> As you know, many databases that run on Linux / Unix systems have a GUI
> installer which make installation easier and more attractive for some
> people.
> 
> Our Windows Installer is very attractive, for example. 
> 
> Now, I and Burcu Guzel, who is a Senior Programmer, decided to launch a
> new project: pgnixinstaller : 
> 
> http://pgfoundry.org/projects/pgnixinstaller/
>
> We are actively looking for developers for the project. Please drop me
> an e-mail if you want to join this project. We will use Python, so you
> need to be a Python guy to join the project. We are in planning phase,
> if you join us earlier, we will be able to share more ideas. 
> 
> Regards,

Thanks to Devrim for the RPM stuff.

On Windows, we expect the installer, no question about that.

On Linux, virtually everyone including many beginners become familiar
with their package management system, be it yum or apt etc. Many of the
readme's, how-to's etc tie into it. The package management tools are
packaged with every distro. There is no environment to setup. Whether
you are using a headless box or a gnome desktop, there is usually an
interface into them.

The beginner just tries yum install xxx. I think folks would be
surprised that for many folks this is basically IT for them in terms of
package installation. Compiling from source, while theoretically
sometimes as easy, doesn't happen nearly as often.

And if you work with a client, the packaging system is what they know as
well. Please, can't you set it up so everything comes from an RPM?

I'm one of those people now.

I used to compile everything from source, from apache, through php and
my database. Had custom build scripts, and the whole works. But I threw
it away and use RPM wherever I can.

When I see postgresql packaged as an RPM, I'm pretty sure the file paths
have been modified to work with my system (they are) and the startup and
shutdown scripts tie in nicely (they do). Especially when I just want to
play with something, I want the simplest approach possible. And the
approach the most folks are familiar with is their package management
system.

So, what's the point of this rambling? Props to Devrim (and others) for
hand-holding us beginners (or lazy ones) with his existing packaging
work. It is tremendously appreciated and lowers the barrier to entry
more then they release.

And I wonder if an effort to take advantage of these existing
infrastructures that everyone (including in my mind beginners) are
familiar with, might yield good results.

- For example, packaging the pgadmin adminpack as an rpm/deb and more of
the pgfoundry items would do this.

- Or a postgresql repository for apt/yum etc, making
upgrading/installing even easier?

If this new installer plays nice with existing packaging systems, and
has the rules in place to custom compile lots of options, it seems close
to providing something in this area already out of necessity.

Perhaps a win-win for both areas with a bit of extension (ie, the
installer is backed by a repo that other users can use with other tools?)

- August



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


end of thread, other threads:[~2006-02-05 21:49 UTC | newest]

Thread overview: 38+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-31 00:48 New project launched : PostgreSQL GUI Installer for Linux/Unix systems Devrim GUNDUZ <devrim@commandprompt.com>
2006-01-31 01:03 ` Re: New project launched : PostgreSQL GUI Installer for Doug McNaught <doug@mcnaught.org>
2006-01-31 01:13   ` Re: New project launched : PostgreSQL GUI Installer for Devrim GUNDUZ <devrim@commandprompt.com>
2006-01-31 01:27     ` Re: [HACKERS] New project launched : PostgreSQL GUI Installer Andrew Dunstan <andrew@dunslane.net>
2006-01-31 07:36     ` Re: New project launched : PostgreSQL GUI Installer for Tino Wildenhain <tino@wildenhain.de>
2006-01-31 09:16       ` Re: New project launched : PostgreSQL GUI Installer for Devrim GUNDUZ <devrim@commandprompt.com>
2006-01-31 03:35 ` Christopher Browne <cbbrowne@acm.org>
2006-01-31 03:52   ` Re: New project launched : PostgreSQL GUI Installer for Joshua D. Drake <jd@commandprompt.com>
2006-01-31 03:58     ` Re: New project launched : PostgreSQL GUI Installer for Marc G. Fournier <scrappy@postgresql.org>
2006-01-31 04:13       ` Re: New project launched : PostgreSQL GUI Installer for Rick Gigger <rick@alpinenetworking.com>
2006-01-31 07:54         ` Re: New project launched : PostgreSQL GUI Installer for Tino Wildenhain <tino@wildenhain.de>
2006-01-31 15:56           ` Re: New project launched : PostgreSQL GUI Installer for Rick Gigger <rick@alpinenetworking.com>
2006-01-31 04:41     ` Re: New project launched : PostgreSQL GUI Installer for Jeffrey W. Baker <jwbaker@acm.org>
2006-01-31 04:53       ` Re: New project launched : PostgreSQL GUI Installer for Joshua D. Drake <jd@commandprompt.com>
2006-01-31 05:00         ` Re: New project launched : PostgreSQL GUI Installer for Jeffrey W. Baker <jwbaker@acm.org>
2006-01-31 05:12           ` Re: New project launched : PostgreSQL GUI Installer for Josh Berkus <josh@agliodbs.com>
2006-01-31 18:57         ` Re: New project launched : PostgreSQL GUI Installer for Jim C. Nasby <jnasby@pervasive.com>
2006-01-31 09:16       ` Re: New project launched : PostgreSQL GUI Installer for Devrim GUNDUZ <devrim@commandprompt.com>
2006-01-31 06:55     ` Re: New project launched : PostgreSQL GUI Installer for J. Andrew Rogers <jrogers@neopolitan.com>
2006-01-31 15:10       ` Re: New project launched : PostgreSQL GUI Installer for Bricklen Anderson <banderson@presinet.com>
2006-01-31 07:49     ` Re: New project launched : PostgreSQL GUI Installer for Tino Wildenhain <tino@wildenhain.de>
2006-01-31 09:16   ` Re: New project launched : PostgreSQL GUI Installer for Devrim GUNDUZ <devrim@commandprompt.com>
2006-01-31 14:06     ` Re: New project launched : PostgreSQL GUI Installer for Christopher Browne <cbbrowne@acm.org>
2006-01-31 14:32     ` Re: New project launched : PostgreSQL GUI Installer for Richard Huxton <dev@archonet.com>
2006-01-31 04:48 ` Re: [HACKERS] New project launched : PostgreSQL GUI Installer for Tony Caduto <tony.caduto@amsoftwaredesign.com>
2006-01-31 06:28   ` Re: [GENERAL] New project launched : PostgreSQL GUI Installer for Steve Atkins <steve@blighty.com>
2006-01-31 07:34 ` Re: [HACKERS] New project launched : PostgreSQL GUI Installer for Tino Wildenhain <tino@wildenhain.de>
2006-01-31 09:16   ` Re: [HACKERS] New project launched : PostgreSQL GUI Installer for Devrim GUNDUZ <devrim@commandprompt.com>
2006-02-05 21:49 ` Re: New project launched : PostgreSQL GUI Installer for Linux/Unix August Zajonc <augustz@augustz.com>
2006-01-31 09:15 Re: New project launched : PostgreSQL GUI Installer for Dave Page <dpage@vale-housing.co.uk>
2006-01-31 09:24 ` Re: New project launched : PostgreSQL GUI Installer for Devrim GUNDUZ <devrim@commandprompt.com>
2006-01-31 10:53 ` Re: New project launched : PostgreSQL GUI Installer for Tino Wildenhain <tino@wildenhain.de>
2006-01-31 09:27 Re: New project launched : PostgreSQL GUI Installer for Dave Page <dpage@vale-housing.co.uk>
2006-01-31 10:57 Re: New project launched : PostgreSQL GUI Installer for Dave Page <dpage@vale-housing.co.uk>
2006-01-31 11:09 ` Re: New project launched : PostgreSQL GUI Installer for Tino Wildenhain <tino@wildenhain.de>
2006-01-31 11:46   ` Re: New project launched : PostgreSQL GUI Installer for Andreas Pflug <pgadmin@pse-consulting.de>
2006-01-31 19:02     ` Re: New project launched : PostgreSQL GUI Installer for Jim C. Nasby <jnasby@pervasive.com>
2006-01-31 20:01       ` Re: New project launched : PostgreSQL GUI Installer for Jeffrey W. Baker <jwbaker@acm.org>

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