LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 09-24-2012, 05:36 AM   #1
cheche.buretche
LQ Newbie
 
Registered: Sep 2012
Posts: 1

Rep: Reputation: Disabled
postgresql start failed


hello everyone,

May I request for your guidance.

I am configuring "postgresql" but it never start the result is always failed.

Kindly refer below;

For pg_hba.conf
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> host all all 127.0.0.1/32 trust
> host all all 192.168.1.1/24 trust
> # IPv6 local connections:
> host all all ::1/128 trust
>
> -------------------------------------------------------------

For postgresql.conf

> # CONNECTIONS AND AUTHENTICATION
> #------------------------------------------------------------
> # - Connection Settings -
>
>#listen_addresses='localhost'
listen_addresses='*'

># port =5432
port =5432 -------------------------------------------------------------

when i did the test the result:

> [root@localhost ~]# /etc/init.d/postgresql restart
> Stopping postgresql service: [FAILED]
> Starting postgresql service: [FAILED]
> [root@localhost ~]#
-------------------------------------------------------------

Thank you very much...
 
Old 09-24-2012, 11:14 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,960

Rep: Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693
Quote:
Originally Posted by cheche.buretche View Post
hello everyone,
May I request for your guidance. I am configuring "postgresql" but it never start the result is always failed. Kindly refer below;
when i did the test the result:

> [root@localhost ~]# /etc/init.d/postgresql restart
> Stopping postgresql service: [FAILED]
> Starting postgresql service: [FAILED]
> [root@localhost ~]#

Thank you very much...
Well, did you check the log files? What error(s) were present in them? Without details, there's nothing we can help you with...you don't say what version/distro of Linux, how you installed postgresql, what version of postgresql, etc. Check the logs....chances are, they will tell you what error(s) you have in your configs.
 
Old 09-25-2012, 09:28 AM   #3
fernfrancis
Member
 
Registered: Feb 2009
Location: Goa(India)-Sharjah(UAE)
Distribution: RHEL,centos,fedora,ubuntu
Posts: 229

Rep: Reputation: 18
Follow this procedure for installation for compiling and installing the database server

copy the tar file (postgresql-.....tar) to /usr/local
extract it tar -xvf postgresql-.....tar
cd postgresql-...
configure with the parameters needed i usually do this

./configure -- prefix-/usr/local/pgsql --enable-multibyte --enable-unicode --with-java --without-readline
make
make install
/usr/sbin/adduser postgres
cd /usr/local/pgsql/data
chown -R postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

later in this file /usr/local/pgsql/data/postgresql.conf

add the listen_address =" your server address"

/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start


this should start the database

let me know if you need help
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
starting postgresql failed ukrainet Linux - Newbie 3 01-09-2011 12:57 PM
[SOLVED] Postgresql 9 en OpenSuse 11.3 Starting Failed gonvaro Linux - Newbie 4 01-09-2011 12:54 PM
postgresql service failed to start or stop purohit.mayur Linux - Newbie 5 01-07-2010 04:36 AM
Starting postgresql service: [FAILED] HeyAZ Fedora 1 08-21-2006 10:30 PM
Upgrading to postgresql 7.4 failed Manuel Tejada Red Hat 1 02-01-2004 03:31 PM


All times are GMT -5. The time now is 04:53 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration