Problem on starting PostgreSQL

Problem on starting PostgreSQL

[Vernon Wu]

I am very new to cygwin. After installed cygwin successfully, I can't get the PostgreSQL up so far. Here is what I have: 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$ initdb -D /usr/share/postgresql/data
The program
    '/usr/bin/postgres'
needed by initdb does not belong to PostgreSQ
there may be a configuration problem.

This was the error message issued by that pro
/usr/bin/postgres: invalid current euid 500
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
There is not the data directory under the /usr/share/postgresql. I don't have enought knowledge to tell where it should 
be there or not. I have spent some hours doing research and can't find a solutation so far. What I miss? Please help me 
out.

Thanks in advance.

v. 



--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problem on starting PostgreSQL

[Jim.George]

On Sat, 19 May 2001, Vernon Wu wrote:

> I am very new to cygwin. After installed cygwin successfully, I can't get the PostgreSQL up so far. Here is what I have:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> $ initdb -D /usr/share/postgresql/data
> The program
>     '/usr/bin/postgres'
> needed by initdb does not belong to PostgreSQ
> there may be a configuration problem.
>
> This was the error message issued by that pro
> /usr/bin/postgres: invalid current euid 500
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> There is not the data directory under the /usr/share/postgresql. I don't have enought knowledge to tell where it should
> be there or not. I have spent some hours doing research and can't find a solutation so far. What I miss? Please help me
> out.
>
> Thanks in advance.
>
> v.
>

Vernon,

	look in the file /usr/doc/postgresql-7.2.1/INSTALL it tells you
exactly what to do.  I can see from the above that you've missed at least
2 of the required steps out, create a user postrges and create the
directory /usr/share/postgresql/data and then set the permissions to be the
same as who will start initDB, this should be postgres but can be
Adminisrtator providing you set the permissions correctly.

HTH,


Jim



--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problem on starting PostgreSQL

[Jason Tishler]

On Tue, May 21, 2002 at 07:19:11AM +0100, Jim.George wrote:
> On Sat, 19 May 2001, Vernon Wu wrote:
> 
> > I am very new to cygwin. After installed cygwin successfully,
> I can't get the PostgreSQL up so far. Here is what I have:
> > [snip]
> > $ initdb -D /usr/share/postgresql/data
> 
> 	look in the file /usr/doc/postgresql-7.2.1/INSTALL it tells you
> exactly what to do.
> [snip]

Actually, the Cygwin specific README is probably more useful:

    /usr/doc/Cygwin/postgresql-7.2.1.README

Jason

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problem on starting PostgreSQL

[Vernon Wu]

Thanks Jason and Jim.

In fact, the error occured while I was following the instruction of /usr/doc/Cygwin/postgresql-7.2.1.README.

I had tried the first step of /cygwin/usr/doc/postgresql-7.2.1/html/installation.html. I am failed on the first step: 
"./configure" with the message "bash: ./configure: Not such file or directory" And I can't find configure.exe in /usr/bin 
directory. I guess I need to install the file. But what package is the file located?

Thanks again for your help.

Vernon

5/21/2002 7:22:20 PM, Jason Tishler <jason@tishler.net> wrote:

>On Tue, May 21, 2002 at 07:19:11AM +0100, Jim.George wrote:
>> On Sat, 19 May 2001, Vernon Wu wrote:
>> 
>> > I am very new to cygwin. After installed cygwin successfully,
>> I can't get the PostgreSQL up so far. Here is what I have:
>> > [snip]
>> > $ initdb -D /usr/share/postgresql/data
>> 
>> 	look in the file /usr/doc/postgresql-7.2.1/INSTALL it tells you
>> exactly what to do.
>> [snip]
>
>Actually, the Cygwin specific README is probably more useful:
>
>    /usr/doc/Cygwin/postgresql-7.2.1.README
>
>Jason
>
>--
>Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
>Bug reporting:         http://cygwin.com/bugs.html
>Documentation:         http://cygwin.com/docs.html
>FAQ:                   http://cygwin.com/faq/
>
>




--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problem on starting PostgreSQL

[Jim.George]

On Tue, 21 May 2002, Vernon Wu wrote:

> Thanks Jason and Jim.
>
> In fact, the error occured while I was following the instruction of /usr/doc/Cygwin/postgresql-7.2.1.README.
>
> I had tried the first step of /cygwin/usr/doc/postgresql-7.2.1/html/installation.html. I am failed on the first step:
> "./configure" with the message "bash: ./configure: Not such file or directory" And I can't find configure.exe in /usr/bin
> directory. I guess I need to install the file. But what package is the file located?
>
> Thanks again for your help.
>
> Vernon
>
Vernon,

	the point we're trying to make is that you don't need to compile
the application as there is already a binary version that comes with
Cygwin.

	When you run 'Install Now' open the database section of the
setup.ini and make sure that postgres is selected.


HTH,

Jim
r


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/