vvv Home | News | Sitemap | FAQ | advertise | OSDir is an Inevitable website.

it was only listening on "localhost" and not on

Below is an erratic odbc.ini file entry [MSSQL2005] Driver = ODBC Driver 11 for SQL Server Description = Microsoft SQL ODBC Driver Server = your_mssql_server_host Port = 1433 Database = [POSTGRESQL9] Why do they give the same output? When I connect using ODBC, a > modified record is always updated with the time that I > connected to the server - not the current time. > > For example, Is The Server Running On Host "localhost" ( And Accepting Tcp/ip Connections On Port 5432? This is a typical problem when using hand-compiled or third-party PostgreSQL packages on Debian or Ubuntu, because the source default for the Unix-domain socket directory is /tmp but the Debian packaging

Both of my client machines had installedrecent norton antivirus and that anti virus was causing this problem. Escape character is '^]'. Reply Link Swapneel November 14, 2007, 2:07 amJust wanted to point out that with PostgreSQL 8.x the option tcpip_socket is no longer valid.The correct parameter is,listen_address = ‘localhost'which needs to be this contact form Reply Link Rizki Ardian September 14, 2016, 6:57 amThank you so much !

ln -s /var/run/postgresql/.s.PGSQL.5432 /tmp/.s.PGSQL.5432 Don't forget to make sure your pg_hba.conf is correctly configured too. Layout of text on paper Why did it take longer to go to Rivendell in The Hobbit than in The Fellowship of the Ring? In this case that is 'root', but it could be 'postgres', or 'bob'. Let's see if I can connect to Postgres' port: $ telnet app06 5432 Trying

Please turn Javascript on for the full experience. ≡ MenuHomeAboutLinux Shell Scripting TutoriaLRSS/FeednixCraftLinux and Unix tutorials for new and seasoned sysadmin.PostgreSQL psql: could not connect to server: Connection refused by Vivek Ask Ubuntu works best with JavaScript enabled Okay, Port 5432 is open and accepting connections. file as follow -------------------------- host all all samenet trust --------------------------Restart the Services.

But last few days ago , i ‘ve changed the root (super user) password and not able to log in at all . Output the first position in your program for each input character Parents disagree on type of music for toddler's listening I want to become a living god! You must have account and permission to connect as vivek user.-d sales : Specifies the name of the database (sales) to connect to.See also:=> How do I add a user to Please note this will give the user full access to select, insert, update, and delete from this table.

Fix the socket directory of the third-party package to be compatible with Debian/Ubuntu. To reduce the request size (currently 57237504 bytes), reduce PostgreSQL's shared memory usage, perhaps by reducing shared_buffers or max_connections. Before that it seemed that multiple instances of postgresql were installed. How did you figure this out?

Use option "-o -h *" if you start postgres from pg_ctl, otherwise do add "-h" "*" to the postgres command line, like e.g. /usr/local/pgsql/bin/postgres -D /pg/data "-h" "*" Of course /pg/data Free forum by Nabble Edit this page UbuntuCommunityAsk!DeveloperDesignDiscourseHardwareInsightsJujuShopMore ›AppsHelpForumLaunchpadMAASCanonical current community chat Ask Ubuntu Ask Ubuntu Meta your communities Sign up or log in to customize your list. Let's see if anything is listening on port 5432 $ telnet localhost 5432 Trying