cant' start psql ipv6 error

From: Tim Dunphy <bluethundr(at)jokefire(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: cant' start psql ipv6 error
Date: 2011-09-09 21:00:01
Message-ID: 65929cdb-2029-4ac4-ba5f-f31256f9611f@li289-212
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hello,

I am attempting to restore a postgres database one I have running in a test lab. both database servers are running version 8.1. I have restored the data to the cluster directory and started with the init script. the host os is centos 5.6.

Here are the contents of my data directory:

[root(at)cobbler opt]# ls -l /var/lib/pgsql/data/
total 116
-rw------- 1 postgres postgres 156 Aug 10 22:11 backup_label
drwx------ 7 postgres postgres 4096 Jun 27 13:57 base
drwx------ 2 postgres postgres 4096 Aug 10 22:12 global
drwx------ 2 postgres postgres 4096 Aug 10 10:51 pg_clog
-rw------- 1 postgres postgres 3485 Jun 20 13:57 pg_hba.conf
-rw------- 1 postgres postgres 3182 Mar 2 2010 pg_hba.conf~
-rw------- 1 postgres postgres 3427 Jun 20 13:50 pg_hba.conf.bak
-rw------- 1 postgres postgres 1460 Mar 2 2010 pg_ident.conf
drwx------ 2 postgres postgres 4096 Mar 18 2010 pg_log
drwx------ 4 postgres postgres 4096 Mar 2 2010 pg_multixact
drwx------ 2 postgres postgres 4096 Aug 10 21:06 pg_subtrans
drwx------ 2 postgres postgres 4096 Mar 2 2010 pg_tblspc
drwx------ 2 postgres postgres 4096 Mar 2 2010 pg_twophase
-rw------- 1 postgres postgres 4 Mar 2 2010 PG_VERSION
drwx------ 3 postgres postgres 4096 Aug 10 18:11 pg_xlog
-rw------- 1 postgres postgres 13757 Jun 20 14:06 postgresql.conf
-rw------- 1 postgres postgres 13690 Mar 2 2010 postgresql.conf~
-rw------- 1 postgres postgres 13688 Jun 20 13:50 postgresql.conf.bak
-rw------- 1 postgres postgres 57 Sep 9 16:41 postmaster.opts
-rw-r--r-- 1 root root 54 Sep 9 16:29 recovery.conf

As you can see there is a recovery.conf file here and it has the following contents:

view plaincopy to clipboardprint?
[root(at)cobbler opt]# cat /var/lib/pgsql/data/recovery.conf
restore_command = 'cp /var/lib/pgsql/archive/%f "%p"'

But when I try to start the service it fails:

[root(at)cobbler opt]# service postgresql start
Starting postgresql service: [FAILED]

And in the pgstartup log I see the following complaint:

view plaincopy to clipboardprint?
LOG: could not create IPv6 socket: Address family not supported by protocol
LOG: logger shutting down

I have commented out references to ipv6 in the pg_hba.conf file
view plaincopy to clipboardprint?
# IPv6 local connections:
#host all all ::1/128 ident sameuser

lsmod shows that ipv6 is not enabled on the host

view plaincopy to clipboardprint?
[root(at)cobbler opt]# lsmod | grep ipv6
[root(at)cobbler opt]#

And in the hosts file there are no ipv6 addresses

view plaincopy to clipboardprint?
[root(at)cobbler opt]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain
##10.96.234.60 cobbler.example.net cobbler
174.129.239.150 puppet.example.net puppet
10.254.81.194 lb.clientdomain.example.com
10.240.217.103 cobbler.example.net cobbler

I was hoping to get some advice on how I can get the service running.

thanks in advance!
tim

Browse pgsql-novice by date

  From Date Subject
Next Message Tony Theodore 2011-09-11 06:13:50 Using expression names in subsequent calculation
Previous Message ScientificWare-Luigi D'Angelo 2011-09-09 15:23:51 Re: replication set-up