Skip site navigation (1) Skip section navigation (2)

Re: Connecting to the database server

From: johnf <jfabiani(at)yolo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Connecting to the database server
Date: 2008-01-11 16:30:05
Message-ID: 200801110830.05272.jfabiani@yolo.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Friday 11 January 2008 08:22:46 am LWATCDR wrote:
> I think I got the data moved over from my old server. Now I am trying
> to connect to the server with pgadminIII
> I went into the postgers.conf and made these the changes I thought I
> needed for me to log on and I did a restart but it is still telling me
> that it can not connect.
> Also I am getting a problem when I try to install the pg-DBD from yum.
> I probably just need to go perl to install that I hope.
>
> # - Connection Settings -
>
> listen_addresses = '*'          # what IP address(es) to listen on;
>                                         # comma-separated list of
> addresses; # defaults to 'localhost', '*' = all # (change requires restart)
> port = 5432                             # (change requires restart)
> max_connections = 100                   # (change requires restart) # Note:
> increasing max_connections costs ~400 bytes of shared memory per #
> connection slot, plus lock space (see max_locks_per_transaction).  You #
> might also need to raise shared_buffers to support more connections.
> #superuser_reserved_connections = 3     # (change requires restart)
> #unix_socket_directory = ''             # (change requires restart)
> #unix_socket_group = ''                 # (change requires restart)
> unix_socket_permissions = 0777          # octal
>                                         # (change requires restart)
> #bonjour_name = ''                      # defaults to the computer name
>                                         # (change requires restart)
>
> # - Security & Authentication -
>
> #authentication_timeout = 1min          # 1s-600s
> #ssl = off                              # (change requires restart)
> #password_encryption = on
> #db_user_namespace = off
>
> # Kerberos
> #krb_server_keyfile = ''                # (change requires restart)
> #krb_srvname = 'postgres'               # (change requires restart)
> #krb_server_hostname = ''               # empty string matches any keytab
> entry # (change requires restart) #krb_caseins_users = off                #
> (change requires restart)
>
> # - TCP Keepalives -
> # see 'man 7 tcp' for details
>
> #tcp_keepalives_idle = 0                # TCP_KEEPIDLE, in seconds;
>                                         # 0 selects the system default
> #tcp_keepalives_interval = 0            # TCP_KEEPINTVL, in seconds;
>                                         # 0 selects the system default
> #tcp_keepalives_count = 0               # TCP_KEEPCNT;
>                                         # 0 selects the system default
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

I'm no expert but I think your postgres.conf is just fine.  You should be 
looking in pg_hba.conf

-- 
John Fabiani

In response to

Responses

pgsql-novice by date

Next:From: Isaac VetterDate: 2008-01-11 17:08:27
Subject: max_connections, solaris semaphores and initdb
Previous:From: LWATCDRDate: 2008-01-11 16:22:46
Subject: Connecting to the database server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group