Thread: Starting postgres at boot
I am trying to learn Postgresql.
Though basic, I have a problem with starting the postgres at boot,
placed the following in /etc/rc.local:
su -c '/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l /var/log/postgresql/postgresql.log start' postgres
but, at times I find the process, other times it is absent (ps aux | grep postgres).
Help is highly appreciated.
aikhan
On Monday, August 30, 2010 04:24:53 Md. Aminul Islam Khan wrote: > Hi, > I am trying to learn Postgresql. > Though basic, I have a problem with starting the postgres at boot, > placed the following in /etc/rc.local: > su -c '/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l > /var/log/postgresql/postgresql.log start' postgres > but, at times I find the process, other times it is absent (ps aux | grep > postgres). > Help is highly appreciated. > > aikhan When the process didn't start, there should have been an error generated and sent to the system log file (/var/log/messages or me). There should be some error information in the postgres log as well. You will have to look there and get a hint of what is wrong. Also, does the command you publish work from the command line? -- Terry Lee Tucker tel: (336) 372-5432; cell: (336) 404-6897 terry@chosen-ones.org
I am using laptop, HP, sometimes it is off the wired LAN (not using wireless). The postgres starts if the laptop is off the LAN, but not when hooked to the network. Other than this I could not find any clue from the log.
Any suggestion?
Thanks.
Aikhan
On Aug 30, 2010 4:43 PM, "Terry Lee Tucker" <terry@chosen-ones.org> wrote:On Monday, August 30, 2010 04:24:53 Md. Aminul Islam Khan wrote:
> Hi,
> I am trying to learn Postgr...When the process didn't start, there should have been an error generated and
sent to the system log file (/var/log/messages or me). There should be some
error information in the postgres log as well. You will have to look there and
get a hint of what is wrong. Also, does the command you publish work from the
command line?
--
Terry Lee Tucker
tel: (336) 372-5432; cell: (336) 404-6897
terry@chosen-ones.org
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice