Problems with PostgreSQL 8

Problems with PostgreSQL 8

[cappellano]

Hello!

Before someone tells me to use Linux or a NT based win to run a native
Postgres, I must say that I have no choice regarding the use of
Postgres on old Win98 machines - this is a huge project that involves
some schools that still have this OS and will take a little longer for
them to switch to Linux.

Given this background information, let me tell my problem:

when I try to run the postmaster everything goes fine. But any attempt
to connect or run external scripts fails. See below:


LOG:  could not recognize system timezone, defaulting to "Etc/GMT+3"
HINT:  You can specify the correct timezone in postgresql.conf.
    165 [main] postmaster 712289 child_info::sync: wait failed, pid
901337, Win32 error 0
    952 [main] postmaster 712289 fork: child 901337 - died waiting for
dll loading, errno 11
LOG:  could not fork startup process: Resource temporarily unavailable


I need it wirking as soon as possible. so, any help would make me glad!

Thanks1

-- 
http://www.geeknerdnanico.net

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[cappellano]

Sorry about the double post.

A message that does not appears on the log file:

psql: could not connect to server: Connection reset by peer
	Is the server running locally and accpeting
	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


cheers!

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[Reini Urban]

cappellano schrieb:
> Before someone tells me to use Linux or a NT based win to run a native
> Postgres, I must say that I have no choice regarding the use of
> Postgres on old Win98 machines - this is a huge project that involves
> some schools that still have this OS and will take a little longer for
> them to switch to Linux.
> 
> Given this background information, let me tell my problem:
> when I try to run the postmaster everything goes fine. But any attempt
> to connect or run external scripts fails. See below:


> LOG:  could not recognize system timezone, defaulting to "Etc/GMT+3"
> HINT:  You can specify the correct timezone in postgresql.conf.
>     165 [main] postmaster 712289 child_info::sync: wait failed, pid
> 901337, Win32 error 0
>     952 [main] postmaster 712289 fork: child 901337 - died waiting for
> dll loading, errno 11
> LOG:  could not fork startup process: Resource temporarily unavailable
> 
> I need it wirking as soon as possible. so, any help would make me glad!

Which postgresql 8 version exactly?
The cygwin release or self-build?

Official is 8.0.7, but I have more versions on my own setup site 
http://rurban.xarch.at/software/cygwin/

Running postmaster as service or as user?
Started by /etc/init.d/postgresql?

I'm sorry that I cannot test it on Win98.

-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[cappellano]

Hello there!

> Which postgresql 8 version exactly?

8.0.7-1, though there is  a 8.1.4-2.

> The cygwin release or self-build?

cygwin.

>
> Official is 8.0.7, but I have more versions on my own setup site
> http://rurban.xarch.at/software/cygwin/
>
> Running postmaster as service or as user?
> Started by /etc/init.d/postgresql?

user, I guess. because i think Win98 cannot work with services.

following the tutorial on postgres site and many others:
/usr/sbin/postmaster ou pg_ctl

trying /etc/rc.d/init.d/postgres start fails.  it says cygserver is
not running, but it is.


>
> I'm sorry that I cannot test it on Win98.

no problem.

thanks for helping

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[cappellano]

So far, I put postmaster to run, but it
does not receive any connection. trying to start
/etc/rc.d/init.d/postgres fails. Running cygsrv -S cygserver results
in error 120. My conclusion is I cannot run Postgres 8 on this
plataform.

If anyone can run Postgres 7 or know any *working* tutorial, just tell
me (I´ve followed 3 or 4 tutorials and all them gives me the same
results - no connection to the DB).

Cheers!
Ricardo

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[Reini Urban]

2007/12/11, cappellano <timmy.jf@gmail.com>:
> So far, I put postmaster to run, but it
> does not receive any connection. trying to start
> /etc/rc.d/init.d/postgres fails. Running cygsrv -S cygserver results
> in error 120. My conclusion is I cannot run Postgres 8 on this
> plataform.
>
> If anyone can run Postgres 7 or know any *working* tutorial, just tell
> me (I´ve followed 3 or 4 tutorials and all them gives me the same
> results - no connection to the DB).

I also have a working postgres 7 also which is not tested on win98
neither on my setup site.
Just try to Add http://rurban.xarch.at/software/cygwin/ to your setup
site and add the postgresql7.4 package there.
But I wonder if this will work, because your real problem seems to be
the missing IPC
support with your failing cygserver. This is not related to postgresql at all.


-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[cappellano]

Hi there!

> But I wonder if this will work, because your real problem seems to be
> the missing IPC
> support with your failing cygserver. This is not related to postgresql at all.
>

IPC is, in theory, installed. But everytime I run it I have a gpf
error. So I don't lnow if it is running or not.

Cheers!

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: Problems with PostgreSQL 8

[Dave Korn]

On 12 December 2007 12:17, cappellano wrote:

> Hi there!
> 
>> But I wonder if this will work, because your real problem seems to be
>> the missing IPC
>> support with your failing cygserver. This is not related to postgresql at
>> all. 
>> 
> 
> IPC is, in theory, installed. But everytime I run it I have a gpf
> error. So I don't lnow if it is running or not.


  Say, you *do* have CYGWIN=server set in your environment variables, don't you?

http://cygwin.com/cygwin-ug-net/using-cygserver.html#use-cygserver
http://cygwin.com/cygwin-ug-net/using-cygwinenv.html 

    cheers,
      DaveK
-- 
Can't think of a witty .sigline today....


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[cappellano]

>
>   Say, you *do* have CYGWIN=server set in your environment variables, don't you?

Yes, I *do*.

> http://cygwin.com/cygwin-ug-net/using-cygserver.html#use-cygserver
> http://cygwin.com/cygwin-ug-net/using-cygwinenv.html
>

any case, I will remove everything from cygwin and try again.

cheers and thanks.

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[cappellano]

Reading the details on the ipc-daemon gpf, i see the error was caused
with the cygwin1.dll.

in one of the guides I´ve found it says toset the PATH, but nothig how
to or where. also, it comments about cygwin2.dll, but I cant find it
on my system.

so, any idea?

cheers

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Problems with PostgreSQL 8

[Larry Hall (Cygwin)]

cappellano wrote:
> Reading the details on the ipc-daemon gpf, i see the error was caused
> with the cygwin1.dll.


ipc-daemon?  That's as old as the hills and deprecated too!  You want
cygserver.  See <http://cygwin.com/cygwin-ug-net/using-cygserver.html> for
details.


> in one of the guides I´ve found it says toset the PATH, but nothig how
> to or where. also, it comments about cygwin2.dll, but I cant find it
> on my system.
> 
> so, any idea?


No idea.  Whatever guide you found is wrong.  There is no cygwin2.dll.
Not yet anyway.



-- 
Larry Hall                              http://www.rfk.com
RFK Partners, Inc.                      (508) 893-9779 - RFK Office
216 Dalton Rd.                          (508) 893-9889 - FAX
Holliston, MA 01746

_____________________________________________________________________

A: Yes.
 > Q: Are you sure?
 >> A: Because it reverses the logical flow of conversation.
 >>> Q: Why is top posting annoying in email?

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/