Re: [CYGWIN] Where is the link to cygwin?

We just added code to add the *.exe suffix for MinGW and I am hoping
this will fix your register problem on Cygwin too.  Would you test a
recent snapshot and let me know if it works?

---------------------------------------------------------------------------

Reini Urban wrote:
> Marek Lewczuk schrieb:
> > Reini Urban wrote:
> >> Richard Sydney-Smith schrieb:
> >> A new initd script will come with 8.0,
> >> which just calls pg_ctl and
> >> adds service install/uninstall args.
> > 
> > Reini,
> > a few days ago you wrote that you are working on plperl patch for cygwin 
> > - how are doing with this ? 
> 
> well, bruce said that it should work now.
> I got reproducable crashes with IPC.
> But I really think that are problems with our cygserver,
> not with postgresql. That's why I'm busy with testing our cygserver,
> and a few libtool bugs.
> 
> > I also found a bug in "pg_ctl register" 
> > function - it adds a service, but the path to the pg_ctl file is 
> > /usr/local/pgsl/bin/pg_ctl.exe  - which is not available in windows.... 
> > or "pg_ctl register" will not work on cygwin ?
> 

Re: [CYGWIN] Where is the link to cygwin?

Bruce Momjian wrote:
> We just added code to add the *.exe suffix for MinGW and I am hoping
> this will fix your register problem on Cygwin too.  Would you test a
> recent snapshot and let me know if it works?

Latest CVS compilation fails, so I was not able to check pg_ctl.

make[4]: Leaving directory `/usr/src/pgsql/src/backend/parser'
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels 
-fno-strict-al
iasing pg_dump.o common.o pg_dump_sort.o pg_backup_archiver.o 
pg_backup_db.o pg_
backup_custom.o pg_backup_files.o pg_backup_null.o pg_backup_tar.o 
dumputils.o
../../../src/backend/parser/keywords.o -L../../../src/interfaces/libpq 
-lpq -L..
/../../src/port -L/usr/local/lib  -lpgport -lz -lreadline -lcrypt -o 
pg_dump.exe

../../../src/port/libpgport.a(pgstrcasecmp.o)(.text+0x1b0):pgstrcasecmp.c: 
multi
ple definition of `_pg_tolower'
../../../src/interfaces/libpq/libpq.a(dyofs00145.o)(.text+0x0): first 
defined he
re
Info: resolving _optarg by linking to __imp__optarg (auto-import)
Info: resolving _optind by linking to __imp__optind (auto-import)
collect2: ld returned 1 exit status
make[3]: *** [pg_dump] Error 1
make[3]: Leaving directory `/usr/src/pgsql/src/bin/pg_dump'

NET HELPMSG 3534

Hi

Get this error when trying to start the PostgreSQl service.  User is created 
(non-admin).
security rights given to the postgresql folder. run as servie granted.

Any guess?

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

Error In PostgreSQL Server Starting

PostgreSQL 8.0.0-beta4 Windows 2000 Installation

An error occured: socket() error

I installed Cygwin with apache gcc and ssh.
Under Apache i installed the CGI:IRC Script. Source: 
http://cgiirc.sourceforge.net/docs/advanced.php

The Apache test Page runs fine, ssh runs well, the CGI:IRC Login Screen apears.
But the Login for the IRC:CGI Script need to open a Socket. Under c:/cygwin/tmp 
i get every Login a new directory with the ip file from the client included.

Check out this link to see the Error:
http://sag.qc.to:8080

The Error Log from Apache:
[Wed Nov  3 06:21:09 2004] CGI:IRC Error: Error opening socket: Operation not 
permitted (main::load_socket 1106)[Wed Nov  3 06:21:27 2004] [notice] child pid 
660 exit signal User defined signal 2 (31)
[Wed Nov  3 06:21:29 2004] [notice] child pid 684 exit signal User defined 
signal 2 (31)

The File Access Log from Apache:
80.218.188.37 - - [03/Nov/2004:06:21:05 +0100] "GET / HTTP/1.1" 200 1561
80.218.188.37 - - [03/Nov/2004:06:21:07 +0100] "POST /irc.cgi HTTP/1.1" 200 873
80.218.188.37 - - [03/Nov/2004:06:21:09 +0100] "GET /irc.cgi?
item=fuserlist&interface=nonjs&R=k5etbza7vm HTTP/1.1" 200 371
80.218.188.37 - - [03/Nov/2004:06:21:09 +0100] "GET /irc.cgi?
item=fform&interface=nonjs&R=k5etbza7vm HTTP/1.1" 200 625
80.218.188.37 - - [03/Nov/2004:06:21:09 +0100] "GET /nph-irc.cgi?
serv=uk.quakenet.org&nick=SAG-Guest337&interface=nonjs&chan=%23%5D%5B-%3D%5BSAG%
5D%3D-%5D%5B&R=k5etbza7vm HTTP/1.1" 200 -
80.218.188.37 - - [03/Nov/2004:06:21:12 +0100] "POST /client.cgi HTTP/1.1" 200 
46

I have no idea how to fix or where to ask to solve this problem :/
Maybe here ?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

installation according to C:\Applications\cygwin\usr\share\doc\postgresql-7.4.3\FAQ_MSWIN

ipc-daemon2 &
[2] 1424
[1]   Done                    ipc-daemon2

Administrator <at> DEMENTOR ~
$ ps
      PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND
     1724       1    1724       1724  con  500 13:47:53 /usr/bin/bash
     1424    1724    1424       1236  con  500 13:57:30 /usr/bin/ipc-daemon2
     1776    1724    1776       1788  con  500 13:57:36 /usr/bin/ps

Administrator <at> DEMENTOR ~
$ initdb -D /usr/local/pgsql/data -W -E UTF-8 -U Administrator
The files belonging to this database system will be owned by user 
"Administrator"
This user must also own the server process.
50
The database cluster will be initialized with locale C.
creating template1 database in /usr/local/pgsql/data/base/1... Signal 12
creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... oka"
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
initdb: removing data directory "/usr/local/pgsql/data"

How can I adjust max_connections ?
Or, what has to be done ?
Uwe.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: Error In PostgreSQL Server Starting

Autosoft Systems schrieb:
>   Respected Sir,
> I want to use postgreSQL database in windows for application.
> I have downloaded installation of cygwin setup from mirror site.
> And install on Windows 2000. after this i create postgres user account then login using postgres user.
> but i was unable to start postgresql server

how about reading the cygwin specific docs?
less /usr/share/doc/Cygwin/postgresql*.README
ipc-daemon2 must not be used anymore, use cygserver instead.

> 
> Error in
> 
> 1... ipc-daemon &
> 
> 2... initdb -D /usr/local/pgsql/data
> signal 12
> fail ...
> 
> 3... postmaster -D /usr/local/pgsql/data &
> fatal error
> 
> so
> Please send me solution in step wise to install cygwin_postgreSQL on Windows 2000.
> 
> i am waiting for reply
> 
> Thanking you
> Jitendra Takalkar
> 
> 
> 

--

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Re: installation according to C:\Applications\cygwin\usr\share\doc\postgresql-7.4.3\FAQ_MSWIN

contact schrieb:
> ipc-daemon2 &
> [2] 1424
> [1]   Done                    ipc-daemon2
> 
> Administrator <at> DEMENTOR ~
> $ ps
>      PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND
>     1724       1    1724       1724  con  500 13:47:53 /usr/bin/bash
>     1424    1724    1424       1236  con  500 13:57:30 /usr/bin/ipc-daemon2
>     1776    1724    1776       1788  con  500 13:57:36 /usr/bin/ps
> 
> Administrator <at> DEMENTOR ~
> $ initdb -D /usr/local/pgsql/data -W -E UTF-8 -U Administrator
> The files belonging to this database system will be owned by user 
> "Administrator"
> This user must also own the server process.
> 50
> The database cluster will be initialized with locale C.
> creating template1 database in /usr/local/pgsql/data/base/1... Signal 12
> creating directory /usr/local/pgsql/data... ok
> creating directory /usr/local/pgsql/data/base... ok
> creating directory /usr/local/pgsql/data/global... oka"
> 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
> initdb: removing data directory "/usr/local/pgsql/data"
> 
> How can I adjust max_connections ?
> Or, what has to be done ?

read the docs.
   disable ipc-daemon2
   install cygserver

--

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

pgsql instalation