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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Jordz [ Fr, 02 April 2010 04:53 ] [ ID #2037928 ]

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" <jordan.d.carter [at] 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 [at] 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

<html><head><style type=3D'text/css'>p { margin: 0; }</style></head><body><=
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<br>by removing your from-source install, and reinstall the apt-get pac=
kages.<br><br>At that point, can you start postgres at all? If not, what do=
you system logs<br>and postgres startup logs say?<br><br>----- "Jordz" <=
;jordan.d.carter [at] gmail.com> wrote:
<br>> I have just moved to rackspacecloud and created a Ubuntu 9.10 serv=
er.<br>> Moved everything over all fine (7-10 wordpress sites). Now I ha=
ve a<br>> couple rails apps that need to move over and run on postgresql=
8.4.<br>> <br>> I installed postgresql via sudo apt-get as per usual=
.. Usually at this<br>> point the postgresql server starts up and I can f=
orget about it. But<br>> no luck. I booted it by running /etc/init.d/pos=
tgresql-8.4 start. When<br>> I run that command it boots fine, I can con=
nect via psql no trouble.<br>> <br>> I rebooted the machine to see wh=
at happened. After boot, apache and<br>> mysql started just fine, wp sit=
es came up nicely no trouble.<br>> postgresql wouldn't start up.<br>>=
<br>> I have tried installing from source, I have tried using different=
<br>> /etc/init.d/postgresql-8.4 scripts. I have no idea what to do.<br>=
> <br>> I have downgraded to upstart to 0.6.3-10. I have apt-get upda=
ted,<br>> upgraded. I have Googled. I have pushed and pulled.<br>> <b=
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=
<br>> end.<br>> <br>> The other irritating part is that while I wa=
it to work out this issue<br>> I am still paying for my old server runni=
ng my Rails apps.<br>> <br>> Anybody have any clues? Solutions? Exper=
ience? Cheers!<br>> <br>> FORUM POST HERE http://ubuntuforums.org/sho=
wthread.php?p=3D9063126#post9063126<br>> <br>> -- <br>> Sent via p=
gsql-admin mailing list (pgsql-admin [at] postgresql.org)<br>> To make change=
s to your subscription:<br>> http://www.postgresql.org/mailpref/pgsql-ad=
min<br>> </div></body></html>
------=_Part_12183_7630754.1270576158871--
Scott Whitney [ Di, 06 April 2010 19:49 ] [ ID #2037933 ]

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

Jordz <jordan.d.carter [at] 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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Tom Lane [ Di, 06 April 2010 20:38 ] [ ID #2037934 ]

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

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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Scott Marlowe [ Di, 06 April 2010 20:58 ] [ ID #2037991 ]

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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Jens Wilke [ Do, 08 April 2010 12:46 ] [ ID #2038135 ]

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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Jens Wilke [ Do, 08 April 2010 12:52 ] [ ID #2038136 ]
Datenbanken » gmane.comp.db.postgresql.admin » Postgresql-8.4 won't boot at startup on 9.10

Vorheriges Thema: PD_ALL_VISIBLE flag warning
Nächstes Thema: Database level encryption