Thread: installation problems
I installed PGSqlwinna1 executable on a windows 2000 machine. Everything works fine as the txt file Postgres7.3.1 txt doc found in the Cygwin directory. In the fourth step the following command will not run cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user postgres --shutdown error message is path doesnot point to a valid executable I have tried 1. changing to /bin/postmaster instead but get the same results. I would really appreciate some help. I would like to run postgresql on this windows machine. thanks Ed. Redman Systems Manager Dalhousie University Faculty of Dentistry 5981 University Ave Halifax, Nova Scotia B3H 3J5 phone: 494-1794 fax: 494-2527
> I installed PGSqlwinna1 executable on a windows 2000 machine. > Everything works fine as the txt file Postgres7.3.1 txt doc found in > the Cygwin directory. In the fourth step > > the following command will not run > > cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D > /usr/share/postgresql/data -i" > --dep ipc-daemon --termsig INT --user postgres --shutdown > > error message is path doesnot point to a valid executable > > I have tried 1. changing to /bin/postmaster instead but get the same > results. I would really appreciate some help. I would like to run > postgresql on this windows machine. Funny, but cygwin's "symlink" mechanism is pretty poor. Rather than using a symlink, copy postgres.exe to postmaster.exe and see if that works.
Ed, On Mon, Apr 21, 2003 at 11:07:16AM -0300, Ed Redman wrote: > I installed PGSqlwinna1 executable on a windows 2000 machine. > [snip] > > the following command will not run > > cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D > /usr/share/postgresql/data -i" > --dep ipc-daemon --termsig INT --user postgres --shutdown > > error message is path doesnot point to a valid executable What is the exact (i.e., cut and paste) error message? > [snip] > I would really appreciate some help. I would like to run postgresql on > this windows machine. Why don't you use the PostgreSQL 7.3.2 that is part of the standard Cygwin distribution? Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
On Fri, Apr 25, 2003 at 03:32:56PM -0400, pgsql@mohawksoft.com wrote: > Funny, but cygwin's "symlink" mechanism is pretty poor. Huh? AFAICT, Cygwin's symlinks work as expected (i.e., identical to symlinks on other Unixes). Of course, Cygwin symlinks only work when interpreted by a Cygwin as opposed to Win32 process. > Rather than using a symlink, copy postgres.exe to postmaster.exe and > see if that works. The above is unlikely to help. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
> On Fri, Apr 25, 2003 at 03:32:56PM -0400, pgsql@mohawksoft.com wrote: >> Funny, but cygwin's "symlink" mechanism is pretty poor. > > Huh? AFAICT, Cygwin's symlinks work as expected (i.e., identical to > symlinks on other Unixes). Of course, Cygwin symlinks only work when > interpreted by a Cygwin as opposed to Win32 process. From the perspective of a Windows application trying to run a cygwin application which is a symlink to another cygwin application it does not look like UNIX symlinks. Cygwin symlinks are *not* symlinks, they are application level indirections. NT does support symlinks at the driver level, but I don't know if it is practical or possible to use them for the file system. > >> Rather than using a symlink, copy postgres.exe to postmaster.exe and >> see if that works. > > The above is unlikely to help. Really? It is one of the things I needed to do to get the "PostgreSQL for Windows" Install CD to work. It depends on which API is being used to load the executable. If the Windows API is used to load the EXE, then you can not use a cygwin symlink.
On Mon, Apr 28, 2003 at 10:39:43AM -0400, pgsql@mohawksoft.com wrote:
> > On Fri, Apr 25, 2003 at 03:32:56PM -0400, pgsql@mohawksoft.com wrote:
> >> Funny, but cygwin's "symlink" mechanism is pretty poor.
> >
> > Huh? AFAICT, Cygwin's symlinks work as expected (i.e., identical to
> > symlinks on other Unixes). Of course, Cygwin symlinks only work
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
************************************
> > when interpreted by a Cygwin as opposed to Win32 process.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
********************************************************
> From the perspective of a Windows application trying to run a cygwin
> application which is a symlink to another cygwin application it does
> not look like UNIX symlinks.
See above...
> Cygwin symlinks are *not* symlinks, they are application level
> indirections.
We are beginning to argue semantics which are not benefiting the OP...
> NT does support symlinks at the driver level, but I don't know if it
> is practical or possible to use them for the file system.
The above has been discussed before on the various Cygwin mailing lists.
It is unlikely that the above will ever become part of Cygwin.
> >> Rather than using a symlink, copy postgres.exe to postmaster.exe
> >> and see if that works.
> >
> > The above is unlikely to help.
>
> Really?
Yes.
> It is one of the things I needed to do to get the "PostgreSQL for
> Windows" Install CD to work.
Note that the above is not needed with the standard Cygwin PostgreSQL
package.
Anyway, the OP indicated the following:
On Mon, Apr 21, 2003 at 11:07:16AM -0300, Ed Redman wrote:
> the following command will not run
>
> cygrunsrv --install postmaster --path /usr/bin/postmaster --args
> "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT
> --user postgres --shutdown
Since cygrunsrv is a Cygwin process, it will resolve the postmaster
symlink correctly.
> It depends on which API is being used to load the executable. If the
> Windows API is used to load the EXE, then you can not use a cygwin
> symlink.
See above...
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Hi I am trying to install Postgres 7.3.2. on Windows XP with cygwin. I have followed exactly as mentioned in following link. http://www.tishler.net/jason/software/postgresql/postgresql-7.2.1.README/. I used the cygipc-1.13-2 I can run initdb successfully. But when I run postmaster, it run for a while and I got the following messages on my console $ LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3588) exited with exit code 1 LOG: database system was interrupted at 2003-04-30 21:38:59 PST LOG: checkpoint record is at 0/83B228 LOG: redo record is at 0/83B228; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 480; next oid: 16976 LOG: database system was not properly shut down; automatic recovery in progress LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3640) exited with exit code 1 LOG: ReadRecord: record with zero length at 0/83B268 LOG: redo is not required LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3688) exited with exit code 1 LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3732) exited with exit code 1 LOG: database system is ready LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3776) exited with exit code 1 LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3840) exited with exit code 1 LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3884) exited with exit code 1 LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3928) exited with exit code 1 LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 3972) exited with exit code 1 LOG: PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable LOG: statistics collector process (pid 4016) exited with exit code 1 Any clue ? thanks Nyo __________________________________ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com