Re: postgres startup method for ubuntu
On 30 jan, 04:14, Jon Hancock <redstarl...@gmail.com> wrote:
I have compiled postgres 8.3rc2 on ubuntu 7.04 and seem to a have
working install.
To start postgres, I do the following:su postgres
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data &ok, that works for dev mode. But what is the recommended approach to
launch postgres at system boot?
Sure, I can hack the above command in an init.d script and if it seems
to work, thats nice.
But since I'm a nube here, I think I should ask for the refined
approach for a startup script. For example, in the mysql world, we
have a safe_mysql script which takes care of startup "best practices".thanks, Jon
I am also searching for a more 'professional' way to startup and
shutdown postgresql on ubuntu and debian systems.
Everytime I deploy a PostgreSQL server in a ubuntu or debian based
server, I create some scripts called pg_start, pg_stop and pg_reload,
save them on default postgresql home dir. Then I create symbolic links
on /usr/bin, and so on I put pg_start on /etc/init.d/bootmisc.sh.
However, I want to deploy it as a "native" linux service, as 'cron' or
'network', and really I dunno how to do it.
Import Notes
Reference msg id not found: f19e2121-7ff7-45c5-a64a-189c4d3c8d38@c4g2000hsg.googlegroups.com
On Thu, Jan 31, 2008 at 02:35:01AM -0800, T.J. Adami wrote:
Everytime I deploy a PostgreSQL server in a ubuntu or debian based
server, I create some scripts called pg_start, pg_stop and pg_reload,
save them on default postgresql home dir. Then I create symbolic links
on /usr/bin, and so on I put pg_start on /etc/init.d/bootmisc.sh.However, I want to deploy it as a "native" linux service, as 'cron' or
'network', and really I dunno how to do it.
Debian does it for me nicely on bootup. I wonder why you
think you need to start it manually ?
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
T.J. Adami wrote:
I am also searching for a more 'professional' way to startup and
shutdown postgresql on ubuntu and debian systems.
The source comes with a startup script that can be installed by
running:
# cp contrib/start-scripts/linux /etc/init.d/postgresql
# update-rc.d postgresql defaults
(update-rc.d is to debian-based systems what chkconfig is to
Redhat-based systems).
--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org
On 31 jan, 12:24, dan...@manitou-mail.org ("Daniel Verite") wrote:
T.J. Adami wrote:
I am also searching for a more 'professional' way to startup and
shutdown postgresql on ubuntu and debian systems.The source comes with a startup script that can be installed by
running:
# cp contrib/start-scripts/linux /etc/init.d/postgresql
# update-rc.d postgresql defaults
(update-rc.d is to debian-based systems what chkconfig is to
Redhat-based systems).--
Daniel
PostgreSQL-powered mail user agent and storage:http://www.manitou-mail.org---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
Debian does it for me nicely on bootup. I wonder why you
think you need to start it manually ?Karsten
I always compile my own version from sources for Python and Perl
support, and also because of newest versions that are update with a
lack of time (for reasonable test reasons).
The source comes with a startup script that can be installed by
running:
# cp contrib/start-scripts/linux /etc/init.d/postgresql
# update-rc.d postgresql defaults
(update-rc.d is to debian-based systems what chkconfig is to
Redhat-based systems).--
Daniel
This adds shutdown scripts too? I need the server shutdown by 'pg_ctl
stop', not by linux killing the process (init 0 or shutdown commands
are very useful sometimes ;) ). I know this is a specific distro
question, however we started this thread yet...
T.J. Adami wrote:
The source comes with a startup script that can be installed by
running:
# cp contrib/start-scripts/linux /etc/init.d/postgresql
# update-rc.d postgresql defaults
(update-rc.d is to debian-based systems what chkconfig is to
Redhat-based systems).--
DanielThis adds shutdown scripts too? I need the server shutdown by 'pg_ctl
stop', not by linux killing the process (init 0 or shutdown commands
are very useful sometimes ;)
Yes. update-rc.d set things up so that at boot time the system will
execute: /etc/init.d/postgresql start, and at shutdown time:
/etc/init.d/postgresql stop
Additionally, the root user can also execute when needed:
/etc/init.d/postgresql {stop|start|reload|restart}
That's the standard way of starting and stopping services on linux,
both automatically and manually.
--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org