| Lists: | pgsql-novice |
|---|
| From: | "White, Benjamin" <Benjamin(dot)White(at)umassmed(dot)edu> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Standard in must be a tty |
| Date: | 2003-09-12 21:02:27 |
| Message-ID: | BF6D55009E4EF847B08A66465FDBFDBE13A100@edcentmail01.ad.umassmed.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
I'm trying to initialize and start postgresql under Red Hat 8 using the
command:
/etc/rc.d/init.d/postgresql start
The script fails, and from looking at the log, it would appear that the
error "Standard in must be a tty" occurs when the script does a
"su" to the postgres user to run the initdb script.
The version of Postgresql is 7.1.3-2, and all components (lib,
postgresql, server, and perl) were installed using RPM.
I appreciate the help - tried a bunch of things over the past 2 days
with no avail...
Thanks
Benjamin J. White
Associate Chief Information Officer
Product Support & Technology
University of Massachusetts Medical School
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "White, Benjamin" <Benjamin(dot)White(at)umassmed(dot)edu> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Standard in must be a tty |
| Date: | 2003-09-13 03:21:51 |
| Message-ID: | 1604.1063423311@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
"White, Benjamin" <Benjamin(dot)White(at)umassmed(dot)edu> writes:
> I'm trying to initialize and start postgresql under Red Hat 8 using the
> command:
> /etc/rc.d/init.d/postgresql start
> The script fails, and from looking at the log, it would appear that the
> error "Standard in must be a tty" occurs when the script does a
> "su" to the postgres user to run the initdb script.
I'm quite sure that no part of the Postgres code reports such an error,
so it seems reasonable to suppose that "su" itself is complaining.
Which really means that the script invoking "su" is doing it wrong.
> The version of Postgresql is 7.1.3-2, and all components (lib,
> postgresql, server, and perl) were installed using RPM.
7.1.3 is ancient history now, and very likely the start script you're
trying to use is too. My local copy of RH 8.0 has PG 7.2.3 as the
standard package --- but if you are just getting started with Postgres,
there is no rational reason for you to be running anything before 7.3.4.
Go forth and get an up-to-date RPM; if it doesn't have a workable start
script included, let us know and we'll try to help more.
regards, tom lane
| From: | "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net> |
|---|---|
| To: | "White, Benjamin" <Benjamin(dot)White(at)umassmed(dot)edu> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Standard in must be a tty |
| Date: | 2003-09-13 05:59:56 |
| Message-ID: | Pine.LNX.4.44.0309131126260.2105-100000@Bhuvan.bksys.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
The problem is with su command. Postgresql does not emit this message. I
faced similar problem long back when i tried su from cron. Are you trying
to run the script from cron? If not, you forward your postgresql init.d
script offlist to me.
regards,
bhuvaneswaran
On Fri, 12 Sep 2003, White, Benjamin wrote:
> I'm trying to initialize and start postgresql under Red Hat 8 using the
> command:
>
>
>
> /etc/rc.d/init.d/postgresql start
>
>
>
> The script fails, and from looking at the log, it would appear that the
> error "Standard in must be a tty" occurs when the script does a
>
> "su" to the postgres user to run the initdb script.
>
>
>
> The version of Postgresql is 7.1.3-2, and all components (lib,
> postgresql, server, and perl) were installed using RPM.
>
>
>
> I appreciate the help - tried a bunch of things over the past 2 days
> with no avail...
>
>
>
> Thanks
>
>
>
> Benjamin J. White
>
> Associate Chief Information Officer
>
> Product Support & Technology
>
> University of Massachusetts Medical School
>
>
>
>