Skip site navigation (1) Skip section navigation (2)

Re: troubles after updating from 7.4.2 to 7.4.3

From: Frank Seesink <frank(at)mail(dot)wvnet(dot)edu>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: troubles after updating from 7.4.2 to 7.4.3
Date: 2004-06-25 03:06:44
Message-ID: cbg4s9$utv$ (view raw, whole thread or download thread mbox)
Lists: pgsql-cygwin

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(at)iname(dot)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(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly

In response to

pgsql-cygwin by date

Next:From: mike gDate: 2004-06-25 03:24:03
Subject: Re: troubles after updating from 7.4.2 to 7.4.3
Previous:From: Gerardo CastilloDate: 2004-06-24 17:30:40
Subject: Problem with upper function and special characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group