Re: troubles after updating from 7.4.2 to 7.4.3 - Mailing list pgsql-cygwin

From Frank Seesink
Subject Re: troubles after updating from 7.4.2 to 7.4.3
Date
Msg-id cbg4s9$utv$1@sea.gmane.org
Whole thread Raw
In response to troubles after updating from 7.4.2 to 7.4.3  ("zuhans@iname.com" <zuhans@iname.com>)
List pgsql-cygwin
Hans,

I have certain basic steps I follow when running Cygwin's setup.exe to
update my Cygwin install.  Might help.

1.  Shutdown all Cygwin processes.
2.  Run setup.exe and update packages as usual.
3.  Run Cygwin BASH and execute following:

    $ cygcheck -c > packages.lst

     Filename unimportant & used as example.  cygcheck will validate your
     installed packages with an 'OK'.  I output info to file so it's
     easier to peruse.
4.  I check the output from #4 with

    $ less packages.lst

     If you see any that do NOT have 'OK' next to them, note them.  Then
     repeat from step #1 until all packages say 'OK'.  I have found that
     sometimes when using setup.exe, some of the packages apparently can
     be mangled (or at least cygcheck thinks so).
5.  Once all is well install-wise, I do one last thing:

    $ chmod a+rx /usr/bin /usr/bin/*

     This is because sometimes the file permissions are not set right in
     /usr/bin, and that is where postgres.exe is.

This last step is likely your issue.  After updating, it's possible
postgres.exe's file permissions were not set right.  If you simply type

    $ postgres

what do you get?  If it comes back 'command not found', there ya go.
File permissions.  If postgres is set right, you should get an error
message from postgres itself about not being able to find the data
directory, etc.

Hope this helps.


zuhans@iname.com wrote:
> hello,
>
> just for testing/programming (jdbc) purposes i used to start and stop my
> postgresql 7.4.2 with two script files.
>
> after cygwin-update the new version 7.4.3 is installed and my db won't
> start any more!!
>
> has it something to do with my scripts?
> my start-db-script is:
> #!/bin/sh
> echo
> echo "IPC-Daemon starten..."
> ipc-daemon2 &
> ps -f
> echo
> echo "PostgreSQL starten..."
> postmaster -i -D /usr/share/postgresql/data &
> ps -f
>
>
> my stop-db-script is:
> #!/bin/sh
> echo
> echo "PostgreSQL stoppen..."
> pg_ctl stop -w -D /usr/share/postgresql/data -s -m smart
> ps -f
> echo
> echo "IPC-Daemon stoppen..."
> kill $(ps -f | grep ipc-d | awk '{print $2}')
> ps -f
>
> there is simply no error-message after my install-script, but i can't
> connect to the server any more.
>
> please help me! i must say that i'm a bloody beginner with postgresql!
> greetings
> hans
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>

pgsql-cygwin by date:

Previous
From: "zuhans@iname.com"
Date:
Subject: troubles after updating from 7.4.2 to 7.4.3
Next
From: mike g
Date:
Subject: Re: troubles after updating from 7.4.2 to 7.4.3