| View previous topic :: View next topic |
| Author |
Message |
dsomers
n00b
Joined: 25 Dec 2004
Posts: 48
Location: Luxembourg
|
 Posted: Mon Jan 09, 2006 5:47 pm Post subject: postgresql hangs on reboot? |
 |
|
I'm having some weirdness with postgresql (8.1.1).
I can manually stop the process using /etc/init.d/postgresql stop.
However, when I reboot my machine, it starts stopping the processes and freezes when it gets to postgresql (and I end up hitting the Big Red Switch).
Any ideas on why it freezes during a shutdown for reboot but not when manually stopped? |
|
| Back to top |
|
 |
TheAl
Tux's lil' helper
Joined: 22 Jan 2004
Posts: 134
|
| Posted: Wed Jan 11, 2006 11:32 am Post subject: |
|
|
please post here the content of your Pg log files (check the logfile name in /etc/conf.d/postgresql)
And pay attention that the normal Pg shutdown wait for all connexions to databases are down before closing the server.
This mean that if you still get a process connected to your DB, server wont shut down until you force it. |
|
| Back to top |
|
|
dsomers
n00b
Joined: 25 Dec 2004
Posts: 48
Location: Luxembourg
|
| Posted: Wed Jan 11, 2006 6:23 pm Post subject: net stopped before postgresql stopped? |
|
|
One thing I did notice was that during reboot, as the machine shuts down, the NET services (eth0, lo) are stopped before Gentoo attempts to stop PostgreSQL.
This is weird since PostgreSQL has a depend on NET, so I would have expected the NET services to be stopped after PostgreSQL has been stopped. |
|
| Back to top |
|
|
mblakeman
n00b
Joined: 17 Apr 2004
Posts: 8
|
| Posted: Wed Jun 07, 2006 9:49 am Post subject: I'm having the same problem |
|
|
| Did anyone find a solution to this problem. I am having the same issue. Is it possible it is related to NIS? |
|
| Back to top |
|
|
PaulBredbury
Watchman
Joined: 14 Jul 2005
Posts: 7310
|
| Posted: Wed Jun 07, 2006 10:11 am Post subject: |
|
|
| Try setting e.g. RC_NET_STRICT_CHECKING="yes" in /etc/conf.d/rc |
|
| Back to top |
|
|
mblakeman
n00b
Joined: 17 Apr 2004
Posts: 8
|
| Posted: Wed Jun 07, 2006 11:10 am Post subject: RC_NET_STRICT_CHECKING="yes" didn't work |
|
|
Thanks for your tip but it didn't make a difference.
After making this change and rebooting I also ran
Shutdown still hangs on "Stopping PostgreSQL" for about 8 minutes.
I have only just installed PostgreSQL and I have no databases so I can't see how it should take that long to stop.
The eth0 and lo are both stopped before PostgreSQL. Would this be the problem?
This PostgreSQL server is a NIS client but I can't see how that could be causing any problems either.
Stopping PostgreSQL manually using
| Code: | | /etc/init.d/postgresql stop |
before shutdown works perfectly. |
|
| Back to top |
|
|
|
Other Things Gentoo
