Thread: building Postgresql in Windows XP
Dear Sir, I am trying to build PostGreSql from http://www.postgresql.org/ftp/source/v8.3.6/. However, I am unable to find any complete step by step document how to build it in windows xp. I would be grateful to you if you could point me any URL that can guide me toward a successful compiling of the database. I want to thank you in advance Sincerely yours Md. ABdur Rahman
Md. Abdur Rahman wrote: > Dear Sir, > I am trying to build PostGreSql from > http://www.postgresql.org/ftp/source/v8.3.6/. However, I am unable to > find any complete step by step document how to build it in windows xp. I > would be grateful to you if you could point me any URL that can guide me > toward a successful compiling of the database. If you really need to build from source you should look at: http://www.postgresql.org/docs/8.3/static/install-win32.html however I would recommend you install postgresql using the binary installer on windows. Stefan
OK, finally I could build it from source. I am using MinGW to do that. Now that I have those exe files. Now how do I start the service or the database. I see the necessary exe files under src/bin/scripts folder such as createdb.exe, createuser.exe...Any manual for that. I appreciate your help. Stefan Kaltenbrunner wrote: > Md. Abdur Rahman wrote: >> Dear Sir, >> I am trying to build PostGreSql from >> http://www.postgresql.org/ftp/source/v8.3.6/. However, I am unable to >> find any complete step by step document how to build it in windows >> xp. I would be grateful to you if you could point me any URL that can >> guide me toward a successful compiling of the database. > > If you really need to build from source you should look at: > > http://www.postgresql.org/docs/8.3/static/install-win32.html > > however I would recommend you install postgresql using the binary > installer on windows. > > > Stefan
Md. Abdur Rahman wrote: > OK, finally I could build it from source. I am using MinGW to do that. > Now that I have those exe files. Now how do I start the service or the > database. I see the necessary exe files under src/bin/scripts folder > such as createdb.exe, createuser.exe...Any manual for that. I appreciate > your help. Umm, yes: the user manual. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Md. Abdur Rahman wrote: > OK, finally I could build it from source. I am using MinGW to do that. > Now that I have those exe files. Now how do I start the service or the > database. I see the necessary exe files under src/bin/scripts folder > such as createdb.exe, createuser.exe...Any manual for that. I appreciate > your help. > This link would be helpful :- http://www.postgresql.org/docs/8.3/static/reference-server.html > > > Stefan Kaltenbrunner wrote: >> Md. Abdur Rahman wrote: >>> Dear Sir, >>> I am trying to build PostGreSql from >>> http://www.postgresql.org/ftp/source/v8.3.6/. However, I am unable to >>> find any complete step by step document how to build it in windows >>> xp. I would be grateful to you if you could point me any URL that can >>> guide me toward a successful compiling of the database. >> >> If you really need to build from source you should look at: >> >> http://www.postgresql.org/docs/8.3/static/install-win32.html >> >> however I would recommend you install postgresql using the binary >> installer on windows. >> >> >> Stefan > > > > -- regards,tushar http://webeatoracle.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFJnRk3fQNodY2PIRoRAhSdAJ90ragnxADeveQVsb8qyPBm1Y9tvACdENc4 lildMM0aDqWWgryLvYM5hrU= =eUqf -----END PGP SIGNATURE-----
Thank you sir. Ah! got right person at right time :-). For now, my question is: I am using my Windows XP OS on a laptop and built using MinGW. However, once I try to create a database cluster using "initdb -D /c/postgresql-8.3.5/src/data" it shows me a message "The program postgres is needed by initdb but was not found in the same directory as c:/postgresql-8.3.5/src/bin/initdb/initdb.exe. Actually the folder data in src folder does not exist. Check your installation". I just want to use this folder for the server instance of postgres. I have checked the directory structure but did not find postgres.exe anywhere. Any quick idea? I appreciate your help. As a new to this world, I feel that I am asking some stupid question and thank you for your patience. Best Regards A. Rahman tushar wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Md. Abdur Rahman wrote: > >> OK, finally I could build it from source. I am using MinGW to do that. >> Now that I have those exe files. Now how do I start the service or the >> database. I see the necessary exe files under src/bin/scripts folder >> such as createdb.exe, createuser.exe...Any manual for that. I appreciate >> your help. >> >> > This link would be helpful :- > > http://www.postgresql.org/docs/8.3/static/reference-server.html > > >> Stefan Kaltenbrunner wrote: >> >>> Md. Abdur Rahman wrote: >>> >>>> Dear Sir, >>>> I am trying to build PostGreSql from >>>> http://www.postgresql.org/ftp/source/v8.3.6/. However, I am unable to >>>> find any complete step by step document how to build it in windows >>>> xp. I would be grateful to you if you could point me any URL that can >>>> guide me toward a successful compiling of the database. >>>> >>> If you really need to build from source you should look at: >>> >>> http://www.postgresql.org/docs/8.3/static/install-win32.html >>> >>> however I would recommend you install postgresql using the binary >>> installer on windows. >>> >>> >>> Stefan >>> >> >> >> > > > > -- > regards,tushar > http://webeatoracle.com > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.2 (GNU/Linux) > > iD8DBQFJnRk3fQNodY2PIRoRAhSdAJ90ragnxADeveQVsb8qyPBm1Y9tvACdENc4 > lildMM0aDqWWgryLvYM5hrU= > =eUqf > -----END PGP SIGNATURE----- >
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Md. Abdur Rahman wrote:
> Thank you sir.
>
> Ah! got right person at right time :-). For now, my question is: I am
> using my Windows XP OS on a laptop and built using MinGW.
from which location you are firing initdb command ,if your PATH is not set ,it is always to run command under bin
folder.
However, once
> I try to create a database cluster using "initdb -D
> /c/postgresql-8.3.5/src/data" it shows me a message "The program
> postgres is needed by initdb but was not found in the same directory as
> c:/postgresql-8.3.5/src/bin/initdb/initdb.exe. Actually the folder data
> in src folder does not exist. Check your installation".
Hmm,it supposed to create a data folder , go to c:/postgresql-8.3.5/src/bin/ and then fire initdb command like initdb
c:/dataor where u want
>I just want to
> use this folder for the server instance of postgres. I have checked the
> directory structure but did not find postgres.exe anywhere. Any quick
> idea? I appreciate your help. As a new to this world, I feel that I am
> asking some stupid question and thank you for your patience.
postgres supposed to be under bin folder.
--
regards,tushar
http://webeatoracle.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQFJnUyrfQNodY2PIRoRAhDpAJ9iP8w1PuMwLzt6ptfGpIjuqPB2swCfUg9y
EKPuU/TDP748eS6FyucV1gI=
=yinV
-----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Md. Abdur Rahman wrote: > I don't have any postgres folder under bin folder. It means I have > something wrong. Any idea how to solve the problem. Do you think that > the link how to build (see above) is not perfect? In that case I have to > look for another solution or I will try to build using Visual C++. > postgres.exe is supposed to be there so chances are very bright that some problem in your installation. at the time of makeinstall , have you got this message at the end "PostgreSQL successfully made. Ready to install" like this,if you can remember. however if you r not sure, just do a test, run this command 'make all install' under your source folder and see what you are getting at the end. this is basic parameter which i am using to compile source . ./configure --prefix=<some path> --with-libs=<path to krb5>/krb5/lib/i386:<path to openssl>/openssl/lib make make install Just curious:why you r not trying to install postgres using the binary installer (just one click and you are done ) http://www.postgresql.org/download/windows -- regards,tushar http://webeatoracle.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFJnVZyfQNodY2PIRoRAuvyAJ9s2bMxjoNMdLt+62D/KS4iIdmYRACgsvkf pyoraGgsqIJlZYMpE7UqgRk= =baUq -----END PGP SIGNATURE-----