failing to start posgresql.

check under $PGHOME/data/pg_log directory.

Usually $PGHOME=/usr/local/pgsql if u have not changed this path during installation

With Reagrds
Ashish...
----- Original Message -----
From: phillip
To: pgsql-general@postgresql.org
Sent: Thursday, June 07, 2007 2:21 PM
Subject: [GENERAL] failing to start posgresql.

hie i am a newbie to Postgresql. I installed Postgresql using an rpm. my problem is that when i issue the service postgresql start command the database is failing to start. Where can i get the error logs for the database so that i can see what is the problem. Is there a another way of starting it

Thanks

take a look inside the rpm and see what it installed:

rpm -ql <rpmname>

On Thu, Jun 07, 2007 at 10:51:59AM +0200, phillip wrote:

hie i am a newbie to Postgresql. I installed Postgresql using an rpm. my
problem is that when i issue the service postgresql start command the
database is failing to start. Where can i get the error logs for the
database so that i can see what is the problem. Is there a another way of
starting it

Thanks

--
Lost time is when we learn nothing from the experiences of life. Time
gained is when we grow to have a wisdom that is tested in the reality of life.

I have done so but I am not seeing the location of log files. Another
question, is it possible to do a fresh installation of postgresql server and
then replace the </var/lib/pgsql/data> folder with the one on my old
installation and get my old database?

Here is a screen shot when I ran the command:
[root@ir:base]# rpm -ql postgresql-server
/etc/rc.d/init.d/postgresql
/etc/sysconfig/pgsql
/usr/bin/initdb
/usr/bin/initlocation
/usr/bin/ipcclean
/usr/bin/pg_controldata
/usr/bin/pg_ctl
/usr/bin/pg_resetxlog
/usr/bin/postgres
/usr/bin/postmaster
/usr/lib/pgsql
/usr/lib/pgsql/ascii_and_mic.so
/usr/lib/pgsql/cyrillic_and_mic.so
/usr/lib/pgsql/euc_cn_and_mic.so
/usr/lib/pgsql/euc_jp_and_sjis.so
/usr/lib/pgsql/euc_kr_and_mic.so
/usr/lib/pgsql/euc_tw_and_big5.so
/usr/lib/pgsql/latin2_and_win1250.so
/usr/lib/pgsql/latin_and_mic.so
/usr/lib/pgsql/plpgsql.so
/usr/lib/pgsql/utf8_and_ascii.so
/usr/lib/pgsql/utf8_and_big5.so
/usr/lib/pgsql/utf8_and_cyrillic.so
/usr/lib/pgsql/utf8_and_euc_cn.so
/usr/lib/pgsql/utf8_and_euc_jp.so
/usr/lib/pgsql/utf8_and_euc_kr.so
/usr/lib/pgsql/utf8_and_euc_tw.so
/usr/lib/pgsql/utf8_and_gb18030.so
/usr/lib/pgsql/utf8_and_gbk.so
/usr/lib/pgsql/utf8_and_iso8859.so
/usr/lib/pgsql/utf8_and_iso8859_1.so
/usr/lib/pgsql/utf8_and_johab.so
/usr/lib/pgsql/utf8_and_sjis.so
/usr/lib/pgsql/utf8_and_tcvn.so
/usr/lib/pgsql/utf8_and_uhc.so
/usr/lib/pgsql/utf8_and_win1250.so
/usr/lib/pgsql/utf8_and_win1256.so
/usr/lib/pgsql/utf8_and_win874.so
/usr/share/locale/cs/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/cs/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/cs/LC_MESSAGES/postgres.mo
/usr/share/locale/de/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/de/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/de/LC_MESSAGES/postgres.mo
/usr/share/locale/es/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/es/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/es/LC_MESSAGES/postgres.mo
/usr/share/locale/fr/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/fr/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/fr/LC_MESSAGES/postgres.mo
/usr/share/locale/hr/LC_MESSAGES/postgres.mo
/usr/share/locale/hu/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/hu/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/hu/LC_MESSAGES/postgres.mo
/usr/share/locale/it/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/it/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/it/LC_MESSAGES/postgres.mo
/usr/share/locale/nb/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/nb/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/nb/LC_MESSAGES/postgres.mo
/usr/share/locale/pt_BR/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/pt_BR/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/pt_BR/LC_MESSAGES/postgres.mo
/usr/share/locale/ru/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/ru/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/ru/LC_MESSAGES/postgres.mo
/usr/share/locale/sl/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/sl/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/sv/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/sv/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/sv/LC_MESSAGES/postgres.mo
/usr/share/locale/tr/LC_MESSAGES/postgres.mo
/usr/share/locale/zh_CN/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo
/usr/share/locale/zh_CN/LC_MESSAGES/postgres.mo
/usr/share/locale/zh_TW/LC_MESSAGES/pg_controldata.mo
/usr/share/locale/zh_TW/LC_MESSAGES/postgres.mo
/usr/share/man/man1/initdb.1.gz
/usr/share/man/man1/initlocation.1.gz
/usr/share/man/man1/ipcclean.1.gz
/usr/share/man/man1/pg_controldata.1.gz
/usr/share/man/man1/pg_ctl.1.gz
/usr/share/man/man1/pg_resetxlog.1.gz
/usr/share/man/man1/postgres.1.gz
/usr/share/man/man1/postmaster.1.gz
/usr/share/pgsql
/usr/share/pgsql/conversion_create.sql
/usr/share/pgsql/information_schema.sql
/usr/share/pgsql/pg_hba.conf.sample
/usr/share/pgsql/pg_ident.conf.sample
/usr/share/pgsql/pg_service.conf.sample
/usr/share/pgsql/postgres.bki
/usr/share/pgsql/postgres.description
/usr/share/pgsql/postgresql.conf.sample
/usr/share/pgsql/sql_features.txt
/var/lib/pgsql
/var/lib/pgsql/.bash_profile
/var/lib/pgsql/backups
/var/lib/pgsql/data

-----Original Message-----
From: Ray Stell [mailto:stellr@cns.vt.edu]
Sent: Thursday, June 07, 2007 2:48 PM
To: phillip
Cc: pgsql-general@PostgreSQL.org
Subject: Re: [GENERAL] failing to start posgresql.

take a look inside the rpm and see what it installed:

rpm -ql <rpmname>

On Thu, Jun 07, 2007 at 10:51:59AM +0200, phillip wrote:

hie i am a newbie to Postgresql. I installed Postgresql using an rpm.
my problem is that when i issue the service postgresql start command
the database is failing to start. Where can i get the error logs for
the database so that i can see what is the problem. Is there a another
way of starting it

Thanks

--
Lost time is when we learn nothing from the experiences of life. Time
gained is when we grow to have a wisdom that is tested in the reality of
life.