View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000138Pgpool-IIBugpublic2015-07-14 18:092015-10-15 09:54
Reporterkhchine5 Assigned Tot-ishii  
PrioritynormalSeveritytextReproducibilitysometimes
Status closedResolutionopen 
PlatformLinuxOSLinux raspberrypi 3.18.7+OS Version3.18.7+
Summary0000138: Address already in use
DescriptionHi All,

i'm trying to make stream replication between tow databases.The first database is in a Linux raspberrypi machine and the other in a vps (Ubuntu disctribution).

If i try to connect to psql with my pgpool port , i get this error

postgres@raspberrypi:/$ psql -p 5438
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5438"?
postgres@raspberrypi:/$


my pgpool.conf

# ----------------------------
# pgPool-II configuration file
# ----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# Whitespace may be used. Comments are introduced with "#" anywhere on a line.
# The complete list of parameter names and allowed values can be found in the
# pgPool-II documentation.
#
# This file is read on server startup and when the server receives a SIGHUP
# signal. If you edit the file on a running system, you have to SIGHUP the
# server for the changes to take effect, or use "pgpool reload". Some
# parameters, which are marked below, require a server shutdown and restart to
# take effect.
#


#------------------------------------------------------------------------------
# CONNECTIONS
#------------------------------------------------------------------------------

# - pgpool Connection Settings -

listen_addresses = '*'
                                   # Host name or IP address to listen on:
                                   # '*' for all, '' for no TCP/IP connections
                                   # (change requires restart)
port = 5438
                                   # Port number
                                   # (change requires restart)
socket_dir = '/var/run/postgresql'
                                   # Unix domain socket path
                                   # The Debian package defaults to
                                   # /var/run/postgresql
                                   # (change requires restart)


# - pgpool Communication Manager Connection Settings -

pcp_port = 9898
                                   # Port number for pcp
                                   # (change requires restart)
pcp_socket_dir = '/var/run/postgresql'
                                   # Unix domain socket path for pcp
                                   # The Debian package defaults to
                                   # /var/run/postgresql
                                   # (change requires restart)

# - Backend Connection Settings -

backend_hostname0 = '10.8.0.1'
                                   # Host name or IP address to connect to for backend 0
backend_port0 = 5432
                                   # Port number for backend 0
backend_weight0 = 1
                                   # Weight for backend 0 (only in load balancing mode)
backend_data_directory0 = '/var/lib/postgres/9.3/main/'
                                   # Data directory for backend 0
backend_flag0 = 'ALLOW_TO_FAILOVER'
                                   # Controls various backend behavior
                                   # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER
backend_hostname1 = 'localhost'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/postgres/9.1/main/'
backend_flag1 = 'ALLOW_TO_FAILOVER'

# - Authentication -

enable_pool_hba = on

#pool_passwd = 'pool_passwd'
                                   # Use pool_hba.conf for client authentication
authentication_timeout = 60
                                   # Delay in seconds to complete client authentication
                                   # 0 means no timeout.

# - SSL Connections -

ssl = off
                                   # Enable SSL support
                                   # (change requires restart)
#ssl_key = './server.key'
                                   # Path to the SSL private key file
                                   # (change requires restart)
#ssl_cert = './server.cert'
                                   # Path to the SSL public certificate file
                                   # (change requires restart)
#ssl_ca_cert = ''
                                   # Path to a single PEM format file
                                   # containing CA root certificate(s)
                                   # (change requires restart)
#ssl_ca_cert_dir = ''
                                   # Directory containing CA root certificate(s)
                                   # (change requires restart)


#------------------------------------------------------------------------------
# POOLS
#------------------------------------------------------------------------------

# - Pool size -

num_init_children = 32
                                   # Number of pools
                                   # (change requires restart)
max_pool = 4
                                   # Number of connections per pool
                                   # (change requires restart)

# - Life time -

child_life_time = 300
                                   # Pool exits after being idle for this many seconds
child_max_connections = 0
                                   # Pool exits after receiving that many connections
                                   # 0 means no exit
connection_life_time = 0
                                   # Connection to backend closes after being idle for this many seconds
                                   # 0 means no close
client_idle_limit = 0
                                   # Client is disconnected after being idle for that many seconds
                                   # (even inside an explicit transactions!)
                                   # 0 means no disconnection


#------------------------------------------------------------------------------
# LOGS
#------------------------------------------------------------------------------

# - Where to log -

log_destination = 'stderr'
                                   # Where to log
                                   # Valid values are combinations of stderr,
                                   # and syslog. Default to stderr.

# - What to log -

print_timestamp = on
                                   # Print timestamp on each line
                                   # (change requires restart)

log_connections = off
                                   # Log connections
log_hostname = off
                                   # Hostname will be shown in ps status
                                   # and in logs if connections are logged
log_statement = off
                                   # Log all statements
log_per_node_statement = off
                                   # Log all statements
                                   # with node and backend informations
log_standby_delay = 'none'
                                   # Log standby delay
                                   # Valid values are combinations of always,
                                   # if_over_threshold, none

# - Syslog specific -

syslog_facility = 'LOCAL0'
                                   # Syslog local facility. Default to LOCAL0
syslog_ident = 'pgpool'
                                   # Syslog program identification string
                                   # Default to 'pgpool'

# - Debug -

debug_level = 0
                                   # Debug message verbosity level
                                   # 0 means no message, 1 or more mean verbose


#------------------------------------------------------------------------------
# FILE LOCATIONS
#------------------------------------------------------------------------------

pid_file_name = '/var/run/postgresql/pgpool.pid'
                                   # PID file name
                                   # (change requires restart)
logdir = '/var/log/postgresql'
                                   # Directory of pgPool status file
                                   # (change requires restart)


#------------------------------------------------------------------------------
# CONNECTION POOLING
#------------------------------------------------------------------------------

connection_cache = on
                                   # Activate connection pools
                                   # (change requires restart)

                                   # Semicolon separated list of queries
                                   # to be issued at the end of a session
                                   # The default is for 8.3 and later
reset_query_list = 'ABORT; DISCARD ALL'
                                   # The following one is for 8.2 and before
#reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'


#------------------------------------------------------------------------------
# REPLICATION MODE
#------------------------------------------------------------------------------

replication_mode = off
                                   # Activate replication mode
                                   # (change requires restart)
replicate_select = off
                                   # Replicate SELECT statements
                                   # when in replication or parallel mode
                                   # replicate_select is higher priority than
                                   # load_balance_mode.

insert_lock = on
                                   # Automatically locks a dummy row or a table
                                   # with INSERT statements to keep SERIAL data
                                   # consistency
                                   # Without SERIAL, no lock will be issued
lobj_lock_table = ''
                                   # When rewriting lo_creat command in
                                   # replication mode, specify table name to
                                   # lock

# - Degenerate handling -

replication_stop_on_mismatch = off
                                   # On disagreement with the packet kind
                                   # sent from backend, degenerate the node
                                   # which is most likely "minority"
                                   # If off, just force to exit this session

failover_if_affected_tuples_mismatch = off
                                   # On disagreement with the number of affected
                                   # tuples in UPDATE/DELETE queries, then
                                   # degenerate the node which is most likely
                                   # "minority".
                                   # If off, just abort the transaction to
                                   # keep the consistency


#------------------------------------------------------------------------------
# LOAD BALANCING MODE
#------------------------------------------------------------------------------

load_balance_mode = off
                                   # Activate load balancing mode
                                   # (change requires restart)
ignore_leading_white_space = on
                                   # Ignore leading white spaces of each query
white_function_list = ''
                                   # Comma separated list of function names
                                   # that don't write to database
                                   # Regexp are accepted
black_function_list = 'nextval,setval'
                                   # Comma separated list of function names
                                   # that write to database
                                   # Regexp are accepted


#------------------------------------------------------------------------------
# MASTER/SLAVE MODE
#------------------------------------------------------------------------------

master_slave_mode = off
                                   # Activate master/slave mode
                                   # (change requires restart)
master_slave_sub_mode = 'stream'
                                   # Master/slave sub mode
                                   # Valid values are combinations slony or
                                   # stream. Default is slony.
                                   # (change requires restart)

# - Streaming -

sr_check_period = 0
                                   # Streaming replication check period
                                   # Disabled (0) by default
sr_check_user = 'nobody'
                                   # Streaming replication check user
                                   # This is necessary even if you disable
                                   # streaming replication delay check with
                                   # sr_check_period = 0
sr_check_password = ''
                                   # Password for streaming replication check user
delay_threshold = 0
                                   # Threshold before not dispatching query to standby node
                                   # Unit is in bytes
                                   # Disabled (0) by default

# - Special commands -

follow_master_command = ''
                                   # Executes this command after master failover
                                   # Special values:
                                   # %d = node id
                                   # %h = host name
                                   # %p = port number
                                   # %D = database cluster path
                                   # %m = new master node id
                                   # %H = hostname of the new master node
                                   # %M = old master node id
                                   # %P = old primary node id
                                   # %% = '%' character


#------------------------------------------------------------------------------
# PARALLEL MODE AND QUERY CACHE
#------------------------------------------------------------------------------

parallel_mode = off
                                   # Activates parallel query mode
                                   # (change requires restart)
enable_query_cache = off
                                   # Activates query cache
                                   # (change requires restart)

pgpool2_hostname = ''
                                   # Set pgpool2 hostname
                                   # (change requires restart)

# - System DB info -

system_db_hostname = 'localhost'
                                   # (change requires restart)
system_db_port = 5432
                                   # (change requires restart)
system_db_dbname = 'pgpool'
                                   # (change requires restart)
system_db_schema = 'pgpool_catalog'
                                   # (change requires restart)
system_db_user = 'pgpool'
                                   # (change requires restart)
system_db_password = ''
                                   # (change requires restart)


#------------------------------------------------------------------------------
# HEALTH CHECK
#------------------------------------------------------------------------------

health_check_period = 0
                                   # Health check period
                                   # Disabled (0) by default
health_check_timeout = 20
                                   # Health check timeout
                                   # 0 means no timeout
#health_check_user = 'nobody'
health_check_user = 'odoo'
                                   # Health check user
health_check_password = ''
                                   # This parameter is not yet implemented.
                                   # Password for health check user


#------------------------------------------------------------------------------
# FAILOVER AND FAILBACK
#------------------------------------------------------------------------------

failover_command = ''
                                   # Executes this command at failover
                                   # Special values:
                                   # %d = node id
                                   # %h = host name
                                   # %p = port number
                                   # %D = database cluster path
                                   # %m = new master node id
                                   # %H = hostname of the new master node
                                   # %M = old master node id
                                   # %P = old primary node id
                                   # %% = '%' character
failback_command = ''
                                   # Executes this command at failback.
                                   # Special values:
                                   # %d = node id
                                   # %h = host name
                                   # %p = port number
                                   # %D = database cluster path
                                   # %m = new master node id
                                   # %H = hostname of the new master node
                                   # %M = old master node id
                                   # %P = old primary node id
                                   # %% = '%' character

fail_over_on_backend_error = on
                                   # Initiates failover when writing to the
                                   # backend communication socket fails
                                   # This is the same behaviour of pgpool-II
                                   # 2.2.x and previous releases
                                   # If set to off, pgpool will report an
                                   # error and disconnect the session.


#------------------------------------------------------------------------------
# ONLINE RECOVERY
#------------------------------------------------------------------------------

recovery_user = 'postgres'
                                   # Online recovery user
recovery_password = ''
                                   # Online recovery password
recovery_1st_stage_command = ''
                                   # Executes a command in first stage
recovery_2nd_stage_command = ''
                                   # Executes a command in second stage
recovery_timeout = 5000
                                   # Timeout in seconds to wait for the
                                   # recovering node's postmaster to start up
                                   # 0 means no wait
client_idle_limit_in_recovery = 0
                                   # Client is disconnected after being idle
                                   # for that many seconds in the second stage
                                   # of online recovery
                                   # 0 means no disconnection
                                   # -1 means immediate disconnection


#------------------------------------------------------------------------------
# OTHERS
#------------------------------------------------------------------------------

relcache_expire = 0
                                   # Life time of relation cache in seconds.
                                   # 0 means no cache expiration(the default).
                                   # The relation cache is used for cache the
                                   # query result against PostgreSQL system
                                   # catalog to obtain various information
                                   # including table structures or if it's a
                                   # temporary table or not. The cache is
                                   # maintained in a pgpool child local memory
                                   # and being kept as long as it survives.
                                   # If someone modify the table by using
                                   # ALTER TABLE or some such, the relcache is
                                   # not consistent anymore.
                                   # For this purpose, cache_expiration
                                   # controls the life time of the cache.



My pgpool.log
Jul 14 08:43:09 raspberrypi pgpool: 2015-07-14 08:43:09 DEBUG: pid 2627: loading "/etc/pgpool2/pool_hba.conf" for client authentication configuration file
Jul 14 08:43:09 raspberrypi pgpool: 2015-07-14 08:43:09 ERROR: pid 2627: bind(0.0.0.0:5438) failed. reason: Address already in use
Jul 14 08:43:09 raspberrypi pgpool: 2015-07-14 08:43:09 ERROR: pid 2627: unlink() failed: No such file or directory
Jul 14 08:43:09 raspberrypi pgpool: 2015-07-14 08:43:09 DEBUG: pid 2627: shmem_exit(1)
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: listen_addresses
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: '*' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: port
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 5438 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: socket_dir
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: '/var/run/postgresql' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: pcp_port
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 9898 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: pcp_socket_dir
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: '/var/run/postgresql' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_hostname0
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: '10.8.0.1' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_port0
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 5432 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: pool_config: port slot number 0
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_weight0
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 1 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: pool_config: weight slot number 0 weight: 1.000000
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_data_directory0
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: '/var/lib/postgres/9.3/main/' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_flag0
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 'ALLOW_TO_FAILOVER' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: extract_string_tokens: token: ALLOW_TO_FAILOVER
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: pool_config: allow_to_failover on
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: pool_config: slot number 0 flag: 0000
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_hostname1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 'localhost' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_port1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 5432 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: pool_config: port slot number 1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_weight1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 1 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: pool_config: weight slot number 1 weight: 1.000000
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_data_directory1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: '/var/lib/postgres/9.1/main/' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: backend_flag1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 'ALLOW_TO_FAILOVER' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: extract_string_tokens: token: ALLOW_TO_FAILOVER
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: pool_config: allow_to_failover on
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: pool_config: slot number 1 flag: 0000
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: enable_pool_hba
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: on kind: 1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: authentication_timeout
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 60 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: ssl
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: off kind: 1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: num_init_children
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 32 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: max_pool
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 4 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: child_life_time
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 300 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: child_max_connections
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 0 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: connection_life_time
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 0 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: client_idle_limit
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 0 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: log_destination
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 'stderr' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: print_timestamp
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: on kind: 1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: log_connections
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: off kind: 1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: log_hostname
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: off kind: 1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: log_statement
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: off kind: 1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: log_per_node_statement
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: off kind: 1
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: log_standby_delay
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 'none' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: syslog_facility
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 'LOCAL0' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: syslog_ident
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 'pgpool' kind: 4
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: key: debug_level
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: value: 0 kind: 2
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: loading "/etc/pgpool2/pool_hba.conf" for client authentication configuration file
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 ERROR: pid 2671: bind(0.0.0.0:5438) failed. reason: Address already in use
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 ERROR: pid 2671: unlink() failed: No such file or directory
Jul 14 08:43:24 raspberrypi pgpool: 2015-07-14 08:43:24 DEBUG: pid 2671: shmem_exit(1)
Steps To ReproduceThe pgpool log says all. You have garbage socket file /var/run/postgresql/.s.PGSQL.5438. This usually caused by broken start up script.
How do you start pgpool-II?
TagsNo tags attached.

Activities

t-ishii

2015-09-17 15:35

developer   ~0000567

The pgpool log says all. You have garbage socket file /var/run/postgresql/.s.PGSQL.5438. This usually caused by broken start up script.
How do you start pgpool-II?

t-ishii

2015-10-15 09:54

developer   ~0000591

No response from the reporter. Issue closed.

Issue History

Date Modified Username Field Change
2015-07-14 18:09 khchine5 New Issue
2015-08-04 10:07 t-ishii Steps to Reproduce Updated
2015-08-04 10:08 t-ishii Assigned To => t-ishii
2015-08-04 10:08 t-ishii Status new => assigned
2015-08-04 10:09 t-ishii Status assigned => feedback
2015-09-17 15:35 t-ishii Note Added: 0000567
2015-10-15 09:54 t-ishii Note Added: 0000591
2015-10-15 09:54 t-ishii Status feedback => closed