Thread: questions about install postgresql on Window

questions about install postgresql on Window

From
Chuanrong Zhang
Date:
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




Re: questions about install postgresql on Window

From
mike g
Date:
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

Re: questions about install postgresql on Window

From
Frank Seesink
Date:
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.

Re: questions about install postgresql on Window

From
Chuanrong Zhang
Date:
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