From: | r92921004(at)ntu(dot)edu(dot)tw |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | createdb rftDatabase error and error of standard in must be a tty |
Date: | 2005-05-09 14:45:57 |
Message-ID: | 20050509224557.lyubu52beock4oss@wmail9.cc.ntu.edu.tw |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
My OS is RHL9. I installed postgresql-8.0.2. There are the
alterations I remembered. (1) in /etc/init.d/postgresql change " su
-l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster -o "-i" '-p ${PGPORT}' start > /dev/null 2>&1" <
/dev/null" to
" su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -o "-i" -D $PGDATA
-p /usr/bin/postmaster start > /dev/null 2>&1" < /dev/null"
(2) in /var/lib/pgsql/data/pg_hba.conf append
" host rftDatabase "username" "host-ip" 255.255.255.255 trust"
(3) su postgres; adduser globus
When I do "/etc/init.d/postgresql start", it seems fine.
But there is an error when I do "createdb rftDatabase"
Here is the error message.
globus(at)flutefly globus]$ /etc/init.d/postgresql start
Postmaster already running.
[globus(at)flutefly globus]$ createdb rftDatabase
createdb: could not connect to database template1: FATAL: Missing or
erroneous pg_hba.conf file, see postmaster log for details
Then I changed the /var/lib/pgsql/data/pg_hba.conf with "host
rftDatabase "globus" "140.112.20.168" 255.255.255.255 trust"
And I can't start the database anymore. Here is the new error
message. [globus(at)flutefly globus]$ /etc/init.d/postgresql start
Starting postgresql service: standard in must be a tty
[FAILED]
I am appreciated any help.
Thanks a lot.
James Yu
From | Date | Subject | |
---|---|---|---|
Next Message | Hrishikesh Deshmukh | 2005-05-09 14:51:01 | Postgres and GnuPlot |
Previous Message | Abdul-Wahid Paterson | 2005-05-09 14:39:57 | need trigger help |