Thread: questions about install postgresql on Window
Dear pgsql-cygwin, I try to install postgresql on Window. According to the instructions you put on the website for " How to install PostgreSQL on Windows", I download and run the Cygwin on my Windows 2000. After start "ipc-daemon2", I try to use the initdb command to create a new database cluster (I su to postgres user to do this). initdb -D /usr/local/pgsql/data But I failed. The following are the feedback: ******************************************************* $ initdb -D /usr/local/pgsql/data The files belonging to this database system will be owned by user "czhang". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory /usr/local/pgsql/data... ok creating directory /usr/local/pgsql/data/base... ok creating directory /usr/local/pgsql/data/global... ok creating directory /usr/local/pgsql/data/pg_xlog... ok creating directory /usr/local/pgsql/data/pg_clog... ok selecting default max_connections... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 10 selecting default shared_buffers... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 50 creating configuration files... ok creating template1 database in /usr/local/pgsql/data/base/1... Signal 12 initdb: failed ***************************** I try to use "make MAX_CONNECTIONS=5 check" command, but I got the following feedback: "make: *** No rule to make target `check'. Stop." How can I do to install PostgreSQL on my windows 2000? The version of PostgreSQL I installed is "7.4.3-1" I am looking forward to your reply! Thank you very much! Chuanrong -- Chuanrong Zhang 2545 N.Frederick Ave. Apt.106 Milwaukee, WI 53211 Phone:1-414-229-5818 or 3818 http://www.uwm.edu/~czhang
The document or webpage you are using is out of date. See the Readme included with the installation. Cygserver is used instead of ipc-daemon2 now. On Wed, 2004-07-14 at 12:58, Chuanrong Zhang wrote: > Dear pgsql-cygwin, > > I try to install postgresql on Window. According to the instructions you put on > the website for " How to install PostgreSQL on Windows", I download and run the > Cygwin on my Windows 2000. After start "ipc-daemon2", I try to use the initdb > command to create a new database cluster (I su to postgres user to do this). > > initdb -D /usr/local/pgsql/data > > But I failed. The following are the feedback: > > ******************************************************* > $ initdb -D /usr/local/pgsql/data > The files belonging to this database system will be owned by user "czhang". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > fixing permissions on existing directory /usr/local/pgsql/data... ok > creating directory /usr/local/pgsql/data/base... ok > creating directory /usr/local/pgsql/data/global... ok > creating directory /usr/local/pgsql/data/pg_xlog... ok > creating directory /usr/local/pgsql/data/pg_clog... ok > selecting default max_connections... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 10 > selecting default shared_buffers... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 50 > creating configuration files... ok > creating template1 database in /usr/local/pgsql/data/base/1... Signal 12 > > initdb: failed > > ***************************** > > I try to use "make MAX_CONNECTIONS=5 check" command, but I got the following > feedback: > > "make: *** No rule to make target `check'. Stop." > > How can I do to install PostgreSQL on my windows 2000? The version of PostgreSQL > I installed is "7.4.3-1" > > I am looking forward to your reply! > > Thank you very much! > > Chuanrong > > -- > Chuanrong Zhang > 2545 N.Frederick Ave. Apt.106 > Milwaukee, WI 53211 > Phone:1-414-229-5818 or 3818 > http://www.uwm.edu/~czhang > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
Hey Mike,
It might be useful to clarify this for new users. It seems an awful
lot of people are getting started with PostgreSQL using some webpage or
site that doesn't match the version they're playing with, leading to the
inevitable "it doesn't work" post.
_____
Chuanrong (and anyone else just starting with PostgreSQL under Cygwin),
The basic steps one should take when wanting to run PostgreSQL under
Cygwin on Windows is as follows now:
1. Visit www.cygwin.com, download setup.exe, run, and do usual
Cygwin install, being sure to include PostgreSQL package of
course. :-)
2. Read the documentation found at the following location:
INSIDE CYGWIN ENVIRONMENT (e.g., using BASH):
/usr/share/doc/Cygwin/postgresql-x.x.x.README
FROM WINDOWS (e.g., using NotePad, etc.):
{cygroot}\usr\share\doc\Cygwin\postgresql-x.x.x.README
e.g.,
C:\cygwin\usr\share\doc\Cygwin\postgresql-x.x.x.README
where x.x.x represents version of PostgreSQL installed;
e.g., postgresql-7.4.3.README for PostgreSQL v7.4.3
Also note that there is no escaping the Unix nature of Cygwin, so if
you're not familiar with using any form of Unix (Linux, FreeBSD,
Solaris, etc.), you will likely need to learn (get a book, take a class,
whatever).
mike g wrote:
> The document or webpage you are using is out of date. See the Readme
> included with the installation. Cygserver is used instead of
> ipc-daemon2 now.
Mike, It works now! Thank you so much! It is so helpful! Have a good day! Chuanrong On Fri, 16 Jul 2004, mike g wrote: > The document or webpage you are using is out of date. See the Readme > included with the installation. Cygserver is used instead of > ipc-daemon2 now. > > On Wed, 2004-07-14 at 12:58, Chuanrong Zhang wrote: > > Dear pgsql-cygwin, > > > > I try to install postgresql on Window. According to the instructions you put on > > the website for " How to install PostgreSQL on Windows", I download and run the > > Cygwin on my Windows 2000. After start "ipc-daemon2", I try to use the initdb > > command to create a new database cluster (I su to postgres user to do this). > > > > initdb -D /usr/local/pgsql/data > > > > But I failed. The following are the feedback: > > > > ******************************************************* > > $ initdb -D /usr/local/pgsql/data > > The files belonging to this database system will be owned by user "czhang". > > This user must also own the server process. > > > > The database cluster will be initialized with locale C. > > > > fixing permissions on existing directory /usr/local/pgsql/data... ok > > creating directory /usr/local/pgsql/data/base... ok > > creating directory /usr/local/pgsql/data/global... ok > > creating directory /usr/local/pgsql/data/pg_xlog... ok > > creating directory /usr/local/pgsql/data/pg_clog... ok > > selecting default max_connections... Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > 10 > > selecting default shared_buffers... Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > Signal 12 > > 50 > > creating configuration files... ok > > creating template1 database in /usr/local/pgsql/data/base/1... Signal 12 > > > > initdb: failed > > > > ***************************** > > > > I try to use "make MAX_CONNECTIONS=5 check" command, but I got the following > > feedback: > > > > "make: *** No rule to make target `check'. Stop." > > > > How can I do to install PostgreSQL on my windows 2000? The version of PostgreSQL > > I installed is "7.4.3-1" > > > > I am looking forward to your reply! > > > > Thank you very much! > > > > Chuanrong > > > > -- > > Chuanrong Zhang > > 2545 N.Frederick Ave. Apt.106 > > Milwaukee, WI 53211 > > Phone:1-414-229-5818 or 3818 > > http://www.uwm.edu/~czhang > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings > -------------------------------------------------- Chuanrong Zhang 2545 N.Frederick Ave. Apt.106 Milwaukee, WI 53211 Phone:1-414-229-5818 or 3818 http://www.uwm.edu/~czhang