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. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
