New project launched : PostgreSQL GUI Installer for Linux/Unix systems
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/
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
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/
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
Devrim GUNDUZ <devrim@commandprompt.com> writes:
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
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.
That's actually a pretty cool idea--compile and generate debs/rpms
that reflect the user's choices, then install them. But the
dependency on a compiler adds a twist of complexity--"sorry, you need
to install the following system packages (gcc, etc) before you can
install Postgres as you've configured it." Not horrible, but perhaps
intimidating for the GUI crowd? :) Is gcc in the bog-standard
default install on FC these days?
Certainly you can install pre-built binaries without a compiler, and
let the user choose database location, autovacuum settings and stuff
like that.
Good luck!
-Doug
Hi,
On Mon, 2006-01-30 at 20:27 -0500, Andrew Dunstan 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/
Thanks for the info. I haven't heard about it before...
However none of them are PostgreSQL Installers, none of them has the
ability to customize the packages and none of them has the ability to
install the community packages, etc. :)
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/
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
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)
And pull down/build/install the various extensions on pgFoundry? :)
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Hi,
On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote:
Certainly you can install pre-built binaries without a compiler, and
let the user choose database location, autovacuum settings and stuff
like that.
That's another good point. We can adjust many settings before
installing.
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/
Hi,
On Mon, 2006-01-30 at 21:34 -0400, Marc G. Fournier 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)And pull down/build/install the various extensions on pgFoundry? :)
Another good idea. Thanks Marc.
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/
Hi,
On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote:
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.That's actually a pretty cool idea--compile and generate debs/rpms
that reflect the user's choices, then install them. But the
dependency on a compiler adds a twist of complexity--"sorry, you need
to install the following system packages (gcc, etc) before you can
install Postgres as you've configured it." Not horrible, but perhaps
intimidating for the GUI crowd? :) Is gcc in the bog-standard
default install on FC these days?
We can pre-check the prerequisites for building the package and raise an
error before beginning to build the package. It is not that hard. For
example, RPMs have BuildRequires tags and we can compare those with the
packages installed in the system.
BTW, gcc is not installed on by default AFAIR.
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/
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
BTW, gcc is not installed on by default AFAIR.
Wow, how do you update the kernel each week? :)
More seriously, I know under FreeBSD, one of the first things that gets
done after installing is to customize the kernel to get rid of all the
'cruft' part of the generic kernel, I take it that this isn't something
that ppl do with Linux?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Hi,
On Mon, 2006-01-30 at 22:04 -0400, Marc G. Fournier wrote:
BTW, gcc is not installed on by default AFAIR.
Wow, how do you update the kernel each week? :)
More seriously, I know under FreeBSD, one of the first things that gets
done after installing is to customize the kernel to get rid of all the
'cruft' part of the generic kernel, I take it that this isn't something
that ppl do with Linux?
On systems that have a packaging system, you are supposed to download
and install vendor kernels. There is "no need" to build the kernel.
However, if you want to build, then you need to install development
environment.
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
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/
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do you? with every conceivable
piece of hardware configured in?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Marc G. Fournier wrote:
More seriously, I know under FreeBSD, one of the first things that
gets done after installing is to customize the kernel to get rid of
all the 'cruft' part of the generic kernel, I take it that this isn't
something that ppl do with Linux?
The Linux kernel has loadable modules, so it's much less of an issue.
For example, I just installed the Cisco VPN s/w on my FC4 box. I didn't
have to rebuild the kernel, all I have to do is to load the kernel
module that puts a wedge in the IP stack.
The parts of the kernel that are optional are almost all loadable modules.
Some people do build static kernels. That makes sense when you have
tightly controlled hardware and software requirements. I mostly don't
bother.
cheers
andrew
I had to deal with an installer written in python and several in Java...
IMHO, Java would be a better language for this and you could build off some
nice OSS installers that already exist (such as IzPack). Just my 2 cents :)
Show quoted text
On 1/30/06, Devrim GUNDUZ <devrim@commandprompt.com> wrote:
Hi,
On Mon, 2006-01-30 at 22:04 -0400, Marc G. Fournier wrote:
BTW, gcc is not installed on by default AFAIR.
Wow, how do you update the kernel each week? :)
More seriously, I know under FreeBSD, one of the first things that gets
done after installing is to customize the kernel to get rid of all the
'cruft' part of the generic kernel, I take it that this isn't something
that ppl do with Linux?On systems that have a packaging system, you are supposed to download
and install vendor kernels. There is "no need" to build the kernel.
However, if you want to build, then you need to install development
environment.On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)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/---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
"Marc G. Fournier" <scrappy@postgresql.org> writes:
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do you? with every conceivable
piece of hardware configured in?
Yes, vendor kernels are very modular--most drivers, packet filtering,
scsi etc are all loadable modules. You can of course build your own
kernel with only the drivers you need built-in, but it usually doesn't
make very much difference. The module system works, in general,
extremely well.
-Doug
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
On Jan 30, 2006, at 8:32 PM, Devrim GUNDUZ wrote:
However none of them are PostgreSQL Installers, none of them has the
ability to customize the packages and none of them has the ability to
install the community packages, etc. :)
You need to take a sniff over at the FreeBSD ports. Lets you build
customized install of Pg quite easily, without need for a gui, which
none of my big servers have.
Marc G. Fournier wrote:
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do you? with every conceivable
piece of hardware configured in?
Yes except for "core" modules almost everything in Linux is a loadable
module.
Sincerely,
Joshua D. Drake
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
