From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Jason Ma <rosegun38(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to startup the database server? |
Date: | 2012-12-19 14:29:24 |
Message-ID: | 50D1CF44.2020906@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/19/2012 06:06 AM, Jason Ma wrote:
> Hi all,
> I am a freshman of PostgreSQL, My env: PG 8.4 on CentOS,I follow the
> document in the offical site to startup the db server. Here's what I do
> below, the database cluster is ready, but I can't start the database server.
>
> [root(at)testbox ~]# service postgresql initdb
> Data directory is not empty! [FAILED]
Well this means there already something in the data directory, most
likely the result of a previous initdb.
Is that indeed the case?
>
> [root(at)testbox ~]# service postgresql start
> Starting postgresql service: [FAILED]
>
> -bash-4.1$ postgres -D /var/lib/pgsql/data
> -bash-4.1$ ps -ef |grep postgres
> root 2710 2585 0 21:52 pts/1 00:00:00 su - postgres
> postgres 2711 2710 0 21:52 pts/1 00:00:00 -bash
> postgres 2752 2711 0 21:55 pts/1 00:00:00 ps -ef
> postgres 2753 2711 0 21:55 pts/1 00:00:00 grep postgres
>
> -bash-4.1$ postgres -D /var/lib/pgsql/data > binlog 2>&1 &
> -bash-4.1$ ps -ef |grep postgres
> root 2710 2585 0 21:52 pts/1 00:00:00 su - postgres
> postgres 2711 2710 0 21:52 pts/1 00:00:00 -bash
> postgres 2768 2711 1 21:59 pts/1 00:00:00 ps -ef
> postgres 2769 2711 0 21:59 pts/1 00:00:00 grep postgres
>
> I wonder why I can't start the database? Do I have some place to see the
> log file. Hope anybody can help me. Thanks.
I do not use CentOS/RH so I am of limited use here. For some pointers see:
http://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux
From there the log would seem to be in /var/lib/pgsql
> --
> Best wishes,
>
> Jason Ma
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Ma | 2012-12-19 15:07:36 | Re: How to startup the database server? |
Previous Message | Jason Ma | 2012-12-19 14:06:01 | How to startup the database server? |