What do you have the pg_hba.conf file? That file controls security. Patrix Linux wrote:
Dear my friends....
I am trying to config my postgres on SuSE 10 but it does not run properly. I want to use tcp/ip connection because I am going to use KNoda to administrate the database.
I just installed the postgres and it was installed successfully. But I can not login with psql: " acer-suse:/usr/local/pgsql # psql rumahsakit psql: FATAL: database "rumahsakit" does not exist acer-suse:/usr/local/pgsql # psql -U postgres -W Password for user postgres: psql: FATAL: Ident authentication failed for user "postgres" acer-suse:/usr/local/pgsql # "
I created the rumahsakit database from YaST2 (Miscellanous-->postgres administration).
Please tell me, why does my postgres not run properly?
Thank you very much in advance.
this is my postgresql.conf: =========
#--------------------------------------------------------------------------- # FILE LOCATIONS #--------------------------------------------------------------------------- # The default values of these variables are driven from the -D command #line # switch or PGDATA environment variable, represented here as ConfigDir. #data_directory = 'ConfigDir' # use data in another directory #hba_file = #'ConfigDir/pg_hba.conf' # host-based authentication file #ident_file = 'ConfigDir/pg_ident.conf' # IDENT configuration file # If external_pid_file is not explicitly set, no extra pid file is #written. #external_pid_file = '(none)' # write an extra pid file #--------------------------------------------------------------------------- # CONNECTIONS AND AUTHENTICATION #--------------------------------------------------------------------------- # - Connection Settings - # what IP address(es) to listen on; listen_addresses = '192.168.1.65'
Also you may want to change listen_addresses = '192.168.1.65' to listen_addresses = '*' until you get the other stuff straighted out. It won't lissten on 12.0.0.1 with this designation.
# comma-separated list of addresses; defaults to 'localhost', '*' = all port = 5433 max_connections = 150 # 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 = 2 #unix_socket_directory = '' #unix_socket_group = '' # octal unix_socket_permissions = 0777 #bonjour_name = '' # defaults to the computer name # - Security & Authentication - #authentication_timeout = 60 # 1-600, in seconds #ssl = off #password_encryption = on #db_user_namespace = off # Kerberos #krb_server_keyfile = '' #krb_srvname = 'postgres' #krb_server_hostname = '' # empty string matches any #keytab entry #krb_caseins_users = off # - 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