From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
---|---|
To: | shreedhar <shreedhar(at)lucidindia(dot)net> |
Cc: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How can I set postmaster as a service |
Date: | 2003-09-06 09:26:21 |
Message-ID: | 20030906102621.A20928@bacon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On 06/09/2003 09:53 shreedhar wrote:
> I already had postgresql file in /etc/rc.d/init.d.
> I run the following ln commands as specified.
> if I boot my system it is opening database. But failing while opening
> database by remote host.
> May be -i option is missing.
>
> If I use the following line in postgresql file
> su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
> /usr/bin/postmaster -o '-p ${PGPORT}' start > /dev/null 2>&1" < /dev/null
>
> I could able to start database but I could not able to connect through
> remost host.
>
> If I change the option -o to -i I am getting an error while starting
> database itself.
>
> su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
> /usr/bin/postmaster -i '-p ${PGPORT}' start > /dev/null 2>&1" < /dev/null
>
> How can I rectify this error.
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster '-p ${PGPORT}' start -o \" -i \" > /dev/null 2>&1" <
/dev/null
or in postgresql.conf
tcpip_socket = true
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-07 00:59:49 | Re: [osdldbt-general] Re: Seeking information about |
Previous Message | Darko Prenosil | 2003-09-06 09:22:50 | Re: How can I set postmaster as a service |
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-09-06 09:58:35 | Re: tsearch2 and unexpected exists (Function defn) |
Previous Message | Darko Prenosil | 2003-09-06 09:22:50 | Re: How can I set postmaster as a service |