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@xxxxxxxxxx] Sent: Thursday, June 07, 2007 2:48 PM To: phillip Cc: pgsql-general@xxxxxxxxxxxxxx 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.
