pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql-8.4 won't boot at startup on 9.10
6+ messages / 5 participants
[nested] [flat]

* Postgresql-8.4 won't boot at startup on 9.10
@ 2010-04-02 02:53  Jordz <jordan.d.carter@gmail.com>
  0 siblings, 3 replies; 6+ messages in thread

From: Jordz @ 2010-04-02 02:53 UTC (permalink / raw)
  To: pgsql-admin

I have just moved to rackspacecloud and created a Ubuntu 9.10 server.
Moved everything over all fine (7-10 wordpress sites). Now I have a
couple rails apps that need to move over and run on postgresql 8.4.

I installed postgresql via sudo apt-get as per usual. Usually at this
point the postgresql server starts up and I can forget about it. But
no luck. I booted it by running /etc/init.d/postgresql-8.4 start. When
I run that command it boots fine, I can connect via psql no trouble.

I rebooted the machine to see what happened. After boot, apache and
mysql started just fine, wp sites came up nicely no trouble.
postgresql wouldn't start up.

I have tried installing from source, I have tried using different
/etc/init.d/postgresql-8.4 scripts. I have no idea what to do.

I have downgraded to upstart to 0.6.3-10. I have apt-get updated,
upgraded. I have Googled. I have pushed and pulled.

Usually with any linux issue in the past I have been able to find a
solution on the net or work it out myself. This one stumps me to no
end.

The other irritating part is that while I wait to work out this issue
I am still paying for my old server running my Rails apps.

Anybody have any clues? Solutions? Experience? Cheers!

FORUM POST HERE http://ubuntuforums.org/showthread.php?p=9063126#post9063126



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgresql-8.4 won't boot at startup on 9.10
@ 2010-04-06 17:49  Scott Whitney <scott@journyx.com>
  parent: Jordz <jordan.d.carter@gmail.com>
  2 siblings, 0 replies; 6+ messages in thread

From: Scott Whitney @ 2010-04-06 17:49 UTC (permalink / raw)
  To: Jordz <jordan.d.carter@gmail.com>; +Cc: pgsql-admin

Will PG start at all? Manually, even? I'd say "go back to clean," first of all 
by removing your from-source install, and reinstall the apt-get packages. 

At that point, can you start postgres at all? If not, what do you system logs 
and postgres startup logs say? 

----- "Jordz" <jordan.d.carter@gmail.com> wrote: 
> I have just moved to rackspacecloud and created a Ubuntu 9.10 server. 
> Moved everything over all fine (7-10 wordpress sites). Now I have a 
> couple rails apps that need to move over and run on postgresql 8.4. 
> 
> I installed postgresql via sudo apt-get as per usual. Usually at this 
> point the postgresql server starts up and I can forget about it. But 
> no luck. I booted it by running /etc/init.d/postgresql-8.4 start. When 
> I run that command it boots fine, I can connect via psql no trouble. 
> 
> I rebooted the machine to see what happened. After boot, apache and 
> mysql started just fine, wp sites came up nicely no trouble. 
> postgresql wouldn't start up. 
> 
> I have tried installing from source, I have tried using different 
> /etc/init.d/postgresql-8.4 scripts. I have no idea what to do. 
> 
> I have downgraded to upstart to 0.6.3-10. I have apt-get updated, 
> upgraded. I have Googled. I have pushed and pulled. 
> 
> Usually with any linux issue in the past I have been able to find a 
> solution on the net or work it out myself. This one stumps me to no 
> end. 
> 
> The other irritating part is that while I wait to work out this issue 
> I am still paying for my old server running my Rails apps. 
> 
> Anybody have any clues? Solutions? Experience? Cheers! 
> 
> FORUM POST HERE http://ubuntuforums.org/showthread.php?p=9063126#post9063126 
> 
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) 
> To make changes to your subscription: 
> http://www.postgresql.org/mailpref/pgsql-admin 
> 

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgresql-8.4 won't boot at startup on 9.10
@ 2010-04-06 18:38  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Jordz <jordan.d.carter@gmail.com>
  2 siblings, 2 replies; 6+ messages in thread

From: Tom Lane @ 2010-04-06 18:38 UTC (permalink / raw)
  To: Jordz <jordan.d.carter@gmail.com>; +Cc: pgsql-admin

Jordz <jordan.d.carter@gmail.com> writes:
> I have just moved to rackspacecloud and created a Ubuntu 9.10 server.
> Moved everything over all fine (7-10 wordpress sites). Now I have a
> couple rails apps that need to move over and run on postgresql 8.4.

> I installed postgresql via sudo apt-get as per usual. Usually at this
> point the postgresql server starts up and I can forget about it. But
> no luck. I booted it by running /etc/init.d/postgresql-8.4 start. When
> I run that command it boots fine, I can connect via psql no trouble.

Usually, just installing a package is not enough to make it autostart
at boot --- if that were true then people could never safely "install
everything".  I think you missed a step.  On Red Hat systems you'd need
something like "sudo chkconfig postgresql on"; probably Ubuntu is
similar.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgresql-8.4 won't boot at startup on 9.10
@ 2010-04-06 18:58  Scott Marlowe <scott.marlowe@gmail.com>
  parent: Jordz <jordan.d.carter@gmail.com>
  2 siblings, 0 replies; 6+ messages in thread

From: Scott Marlowe @ 2010-04-06 18:58 UTC (permalink / raw)
  To: Jordz <jordan.d.carter@gmail.com>; +Cc: pgsql-admin

On Thu, Apr 1, 2010 at 8:53 PM, Jordz <jordan.d.carter@gmail.com> wrote:
> I have just moved to rackspacecloud and created a Ubuntu 9.10 server.
> Moved everything over all fine (7-10 wordpress sites). Now I have a
> couple rails apps that need to move over and run on postgresql 8.4.
>
> I installed postgresql via sudo apt-get as per usual. Usually at this
> point the postgresql server starts up and I can forget about it. But
> no luck. I booted it by running /etc/init.d/postgresql-8.4 start. When
> I run that command it boots fine, I can connect via psql no trouble.

Look up the update-rc.d command.  It's what's used in debian and
ubuntu to setup services to run or not run on boot etc.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgresql-8.4 won't boot at startup on 9.10
@ 2010-04-08 10:46  Jens Wilke <jens.wilke@affinitas.de>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 6+ messages in thread

From: Jens Wilke @ 2010-04-08 10:46 UTC (permalink / raw)
  To: pgsql-admin

Am Dienstag 06 April 2010 20:38:46 schrieb Tom Lane:

> Usually, just installing a package is not enough to make it autostart
> at boot 

This is not true for debian and ubuntu.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgresql-8.4 won't boot at startup on 9.10
@ 2010-04-08 10:52  Jens Wilke <jens.wilke@affinitas.de>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 6+ messages in thread

From: Jens Wilke @ 2010-04-08 10:52 UTC (permalink / raw)
  To: pgsql-admin

Am Dienstag 06 April 2010 20:38:46 schrieb Tom Lane:

> Usually, just installing a package is not enough to make it autostart
> at boot 

sorry for the first reply.
On debian and ubuntu update-rcd is usually run when installing new 
packages. 8.4.2-0ubuntu9.10 installes fine here and creates all the links 
in /etc/rc*
Please check if they exist:
ls /etc/rc*/*postgres*

Regards,
Jens Wilke



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2010-04-08 10:52 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-02 02:53 Postgresql-8.4 won't boot at startup on 9.10 Jordz <jordan.d.carter@gmail.com>
2010-04-06 17:49 ` Scott Whitney <scott@journyx.com>
2010-04-06 18:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-04-08 10:46   ` Jens Wilke <jens.wilke@affinitas.de>
2010-04-08 10:52   ` Jens Wilke <jens.wilke@affinitas.de>
2010-04-06 18:58 ` Scott Marlowe <scott.marlowe@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox