SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 06:52 AM
| ||||
| ||||
 Postgres 8.1.4 is not starting in RHEL 4 Hi I installed 8.1.4 POSTGRESQL RPMS on my system. When I tried to run /etc/init.d/postgresql start I got this error. [root@newdell init.d]# ./postgresql start Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists [FAILED] Starting postgresql service: [FAILED] Then i removed "pg_log" and given [root@newdell data]# pg_ctl --log /tmp/pg.log start pg_ctl: cannot be run as root Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process. Then i cahnged the user as postgres [root@newdell data]# su postgres bash-3.00$ pg_ctl --log /tmp/pg.log start pg_ctl: no database directory specified and environment variable PGDATA unset Try "pg_ctl --help" for more information. bash-3.00$ Please help me Thanks Manish --------------------------------- Access over 1 million songs - Yahoo! Music Unlimited.      |
|
04-10-2008, 06:52 AM
| ||||
| ||||
| Re: Postgres 8.1.4 is not starting in RHEL 4 On 12/1/06, Manish Pillai <manishg_pillai@yahoo.com> wrote: > > Hi > I installed 8.1.4 POSTGRESQL RPMS on my system. When I tried to run > /etc/init.d/postgresql start I got this error. > > [*root@newdell init.d]# ./postgresql start > Initializing database: mkdir: cannot create directory > `/var/lib/pgsql/data/pg_log': File exists > [FAILED] > Starting postgresql service: [FAILED] > * > Then i removed "pg_log" and given > > [*root@newdell data]# pg_ctl --log /tmp/pg.log start > pg_ctl: cannot be run as root > Please log in (using, e.g., "su") as the (unprivileged) user that will > own the server process. > > * > Then i cahnged the user as postgres > > [*root@newdell data]# su postgres > bash-3.00$ pg_ctl --log /tmp/pg.log start > pg_ctl: no database directory specified and environment variable PGDATA > unset > Try "pg_ctl --help" for more information. > bash-3.00$ > * > Please help me > you should 'su - postgres' instead of 'su postgres' and try again. probably PGDATA is not getting set because of that. regds mallah. from man page of su ------------------- su is used to become another user during a login session. Invoked without a username, su defaults to becoming the super user. The optional argument - may be used to provide an environment similar to what the user would expect had the user logged in directly. Thanks > Manish > > > ------------------------------ > Access over 1 million songs - Yahoo! Music Unlimited.<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/> > > |
Linear Mode
