Postgres 8.4 installer features

This message was edited 2 times. Last update was at 7 Jul 2009 09:01:19

Hi

I have been using the MSI installer (silent) for the previous Postgres versions.
But now i want to use the 8.4 and miss the features from the MSI installer like
adapting the name of the created service and\or the name of the created user account during installation

Did any one else solve this issue?

Is it possible to this with the enterpriseDB "one Click" installer too?

Thanks in advance

Cheers
Steffen

Hi Steffen,

Please see the following URL.

http://www.enterprisedb.com/learning/pginst_guide.do

Hope this helps.

Thanks

Hi ashaar

thanks for your reply.
If read the installer guide, which does not answer my questions, before posting.
Do you have any ideas to change the name for service account and the service itself during installation process?

Greets Steffen

I have an installer (make with NIS) with a desktop app with embedded postgresql msi installer, that can configure Windows user account, password, service name, postgresql XML2 feature, etc

I really need this functionalities.. can enybody help me??

regards

I would like to add some things about the installer.
I would like the installers to include a .chm version of the help file for windows in place of an html help file because the index and searching is precious to me, and windows doesn't have a search engine for html from the desktop like google. For other OS's the HTML help will be necessary probably.

if the installer doesn't include all the languages for embedded programming available, I would like it to include them.
it used to be with the postgresql.org installer there would be about 100 checkboxes you could pick options from, and most of them were language features.
anything I can get precompiled is good. my mingw+msys build system is not entirely working. zlib is impossible to utilize or compile, without which you can't build postgres, without which you can't build libpq++, without which I can't build my embedded apps.

also, it would be nice if on the web site you would document what packages you included in the installer. there is too little information. I could also use readme files or a pdf file documenting each programming language included:
- title of package
- what it does
- programming language name
- list of DLL's, EXE's OCX's, libraries, header files, and whatever else is required to link in to a language, and (hopefully) what they are.
- url/shortcut to package's site

many times there is a DLL and I am not quite sure what to do with it. it's just sitting there. I don't know what it's a part of unless the name gives a hint, and sometimes I can't even figure that out because the name is not descriptive.
and you only have to write the document once pretty much, and it saves everyone a lot of headache and confusion.

thanks in advance.
Jim Michaels

Steffen,

We currently dont support customization of service user name and service name. But we do consider it as a future feature request.

Jim,

About the chm file, we have to look how much it will increase the installer size.

About creating descriptive README/documentations. Yes definitely you will be seeing them shortly.

About including embeded programming languages, We do include, plpgsql, plperl, plpython, pltcl. You can mention any other and we will consider it in a future release.

Feedbacks are very important to us as they will help us to better the installer in all ways possible. So please keep them coming.

chm files are generally very small compared to html. the c in chm stands for compressed. I believe they are based on RTF files, but I am not sure. I haven't dug too much into creating chm help files. There may be a way to build them from HTML, but I have not tried. very large help files with loads of comments, such as that of PHP tend to take up 12MB.

compiling html (chm) help articles:
http://msdn.microsoft.com/en-us/library/aa733988%28VS.60%29.aspx
http://msdn.microsoft.com/en-us/library/aa733976%28VS.60%29.aspx
http://msdn.microsoft.com/en-us/library/ms670169%28VS.85%29.aspx
http://msdn.microsoft.com/en-us/library/ms669985%28VS.85%29.aspx

I was wrong, chm is not based on rtf it is based on html.
Jim

I have been using silent installer for version 8.1 and will be upgrading to 8.4.2. One of the options I've been using, and need urgently, is DOINITDB which runs initdb and creates data directory. Lack of this option will force me to do an interactive install.

I don't see this option, or its equivalent, in your silent installer for 8.4.x. Do you have a suggestion on how I could accomplish this? It is very unfortunate that a recent version of postgreSQL doesn't have very useful features available in older version!

Thanks

Hello,

I guess --mode unattended is all you need, please see --help for all the options available.

I should have been more clear in my earlier post.

I need to be able to NOT do initdb and not have it create data directory.

In my case, two postgresql servers are working off of the same database. Only one of the postgresql server is up at any one time. This is our high availability configuration. To achieve this, I do a full non-interactive install when installing the first postgresql server and and DOINITDB=0 for the second server, whereby another data directory is not created.

Is there a way to accomplish this for 8.4.2?

Thanks

.chm files are compressed HTML files, except with an index I think. they shouldn't be a problem - may actually take up less space.
.chm files are usable on WINE on linux using hh and so should also work on mac OSX. chm files are originally a windows thing.
html help 1.4 sdk

This message was edited 2 times. Last update was at 15 Jan 2010 15:24:06

In my case, two postgresql servers are working off of the same database. Only one of the postgresql server is up at any one time. This is our high availability configuration. To achieve this, I do a full non-interactive install when installing the first postgresql server and and DOINITDB=0 for the second server, whereby another data directory is not created.

Is there a way to accomplish this for 8.4.2?

Please try the following command on Second server to install postgreSQL, without creating Data Directory:
postgresql-8.4.2-1-windows.exe --extract-only 1 --prefix "<installation_location>" --mode unattended

is there a way to specify a port number, ip address, directory, in an automated fashion?

Could you please explain what "extract-only" does?

Although the database won't be installed on the second server, postgreSQL server still needs to know where it should look for database. Which argument provides that information to the server?

Thanks