Re: Connecting to the database server - Mailing list pgsql-novice

Thanks I did move on to pg_hba.conf but no joy yet.
I turned off ipchains since this box is inside our firewall and I am
just testing for now.
I added these lines to pg_hba.conf and restarted postgres
host    all         all         192.168.100.0/24       ident sameuser
host    phone       all         192.168.100.0/24       trust



I now get a message saying that the server terminated this connection
unexpectedly.
Any ideas?

On Jan 11, 2008 11:30 AM, johnf <jfabiani@yolo.com> wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>