Re: How to startup the database server?

Thanks, adrian, but I have check the pgstartup.log, I got the following
messages:
.....
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

Success. You can now start the database server using:

/usr/bin/postgres -D /var/lib/pgsql/data
or
/usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start

runuser: cannot set groups: Operation not permitted

I tried this:

-bash-4.1$ /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
server starting
-bash-4.1$ ps -ef |grep postgres
root 2904 2585 0 22:59 pts/1 00:00:00 su - postgres
postgres 2905 2904 0 22:59 pts/1 00:00:00 -bash
postgres 2946 2905 7 23:00 pts/1 00:00:00 ps -ef
postgres 2947 2905 0 23:00 pts/1 00:00:00 grep postgres

It reported that I have started the server but that doesn't work, I think
there must be somebody has the same problem with me. Any suggestions.

Regards,
Jason

2012/12/19 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>

> 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<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
>

--
Best wishes,

Jason Ma