Thread: Standard in must be a tty

Standard in must be a tty

From
"White, Benjamin"
Date:

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

 

Re: Standard in must be a tty

From
Tom Lane
Date:
"White, Benjamin" <Benjamin.White@umassmed.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

Re: Standard in must be a tty

From
"A.Bhuvaneswaran"
Date:
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
>
>
>
>