Postgres server does not start.

[Sthu Deus <sthu.deus@gmail.com>]

Good day.


Please, help me to run my postgres DB.

Here is problem description.

I have 2 instances in /var/lib/postgresql/8.3:

main
mine

When I start postgres server w/ command:

/etc/init.d/postgresql-8.3 start

I get:

Starting PostgreSQL 8.3 database server: main mineThe PostgreSQL server failed to start. Please check the log output. failed!
 failed!

In the appropriate logs I have:

for the main:

2010-01-31 13:31:00 GMT-7 LOG:  could not load root certificate file "root.crt": no SSL error reported
2010-01-31 13:31:00 GMT-7 DETAIL:  Will not verify client certificates.
2010-01-31 13:31:00 GMT-7 LOG:  test message did not get through on socket for statistics collector
2010-01-31 13:31:00 GMT-7 LOG:  disabling statistics collector for lack of working socket
2010-01-31 13:31:00 GMT-7 WARNING:  autovacuum not started because of misconfiguration
2010-01-31 13:31:00 GMT-7 HINT:  Enable the "track_counts" option.
2010-01-31 13:31:00 GMT-7 LOG:  database system was shut down at 2010-01-31 13:10:52 GMT-7
2010-01-31 13:31:00 GMT-7 LOG:  incomplete startup packet
2010-01-31 13:31:00 GMT-7 LOG:  database system is ready to accept connections

and for the mine:

2010-01-31 13:31:03 GMT-7 LOG:  could not load root certificate file "root.crt": no SSL error reported
2010-01-31 13:31:03 GMT-7 DETAIL:  Will not verify client certificates.
2010-01-31 13:31:03 GMT-7 LOG:  could not bind IPv4 socket: Address already in use
2010-01-31 13:31:03 GMT-7 HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2010-01-31 13:31:03 GMT-7 WARNING:  could not create listen socket for "localhost"
2010-01-31 13:31:03 GMT-7 FATAL:  could not create any TCP/IP sockets

So, I can not connect to the databases from "mine".
From the logs I do understand that "mine" have a concurrency w/ the "main" - but I did not change postgres configuration - as far as I remember, - and since I installed postgres I used both - main and mine - w/o any concurrency.

So, what is wrong? Or how I can fix it?


PS Reading of the install and run chapters of the postgres documentation gave me no ideas, as well as searching on Internet - relating to my problem.

Thanks for Your time.

PS Please, reply to the list.