Postgresql-8.4 won"t boot at startup on 9.10

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

Re: Postgresql-8.4 won"t boot at startup on 9.10

------=_Part_12183_7630754.1270576158871
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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" 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
>
------=_Part_12183_7630754.1270576158871
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<=
div style=3D'font-family: Times New Roman; font-size: 12pt; color: #000000'=
>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 pac=
kages.

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 serv=
er.
> Moved everything over all fine (7-10 wordpress sites). Now I ha=
ve 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 f=
orget about it. But
> no luck. I booted it by running /etc/init.d/pos=
tgresql-8.4 start. When
> I run that command it boots fine, I can con=
nect via psql no trouble.
>
> I rebooted the machine to see wh=
at happened. After boot, apache and
> mysql started just fine, wp sit=
es 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 upda=
ted,
> upgraded. I have Googled. I have pushed and pulled.
> r>> Usually with any linux issue in the past I have been able to find a<=
br>> solution on the net or work it out myself. This one stumps me to no=

> end.
>
> The other irritating part is that while I wa=
it to work out this issue
> I am still paying for my old server runni=
ng my Rails apps.
>
> Anybody have any clues? Solutions? Exper=
ience? Cheers!
>
> FORUM POST HERE http://ubuntuforums.org/sho=
wthread.php?p=3D9063126#post9063126
>
> --
> Sent via p=
gsql-admin mailing list (pgsql-admin@postgresql.org)
> To make change=
s to your subscription:
> http://www.postgresql.org/mailpref/pgsql-ad=
min
>
------=_Part_12183_7630754.1270576158871--

Re: Postgresql-8.4 won"t boot at startup on 9.10

Jordz 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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Postgresql-8.4 won"t boot at startup on 9.10

On Thu, Apr 1, 2010 at 8:53 PM, Jordz 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.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Postgresql-8.4 won"t boot at startup on 9.10

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.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Postgresql-8.4 won"t boot at startup on 9.10

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin