building Postgresql in Windows XP

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:

-----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-----

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

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:

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:/data or 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 make install , 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-----