Обсуждение: Can't connect to PGSQL
We have installed LinuxRedhat+PgSQL in our server. We can ping the server's IP. But we cannot connect our database through PGAdmin or our application. We have already set the port to the default. 1. What seems to be the problem? 2. How can I read the server's activities?(reading the log) __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/
On Mon, 4 Nov 2002, ferdinan firmansyah wrote: > We have installed LinuxRedhat+PgSQL in our server. We > can ping the server's IP. But we cannot connect our > database through PGAdmin or our application. We have > already set the port to the default. > > 1. What seems to be the problem? > 2. How can I read the server's activities?(reading the > log) Are you allowing http connections to the server (tcpip_socket=true in postgresql.conf) and are you allowing connections from the machine in question (see pg_hba.conf)
Hi! I don't know if this is possible from postgresql configuration... I want to ignore the use of uppercase and lowercase from the data restored into the DB... I mean, if I write a query like this: select * from fruits where fruit_name like 'orange'; I could get any result where the string looks like: orange Orange ORANGE Is it possible??? Regards.
On Mon, 4 Nov 2002, [iso-8859-1] Sonia S�nchez D�az wrote: > Hi! > > I don't know if this is possible from postgresql configuration... > > I want to ignore the use of uppercase and lowercase from the data restored > into the DB... > > I mean, if I write a query like this: > > select * from fruits where fruit_name like 'orange'; > > I could get any result where the string looks like: > > orange > Orange > ORANGE > > Is it possible??? Not really without doing a little bit of changing to the query (for example using ILIKE rather than LIKE or lower(fruit_name) like 'orange' with an appropriate index on lower(fruit_name). Theoretically, it could perhaps be possible to create a locale which compare 'orange' and 'OraNgE' equally and then initdb in that locale, but I've never tried it so I don't know if it'd work.
did you start your databases with the -i option (enable TCP/IP connections) if so, you may have a firewall or something disable port 5432 When you start your databases, how do you do so? like: /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i >/log/logfile-`date +"%d-%m-%y"` 2>&1 for postmaster sends it's output to stdout, so you have to redirect it... you can just tail the logfile, open it with vi, vim or any other texteditor, altough I suggest you use more or tail... "ferdinan firmansyah" <mymand@yahoo.com> schreef in bericht news:20021105012651.62134.qmail@web14006.mail.yahoo.com... > We have installed LinuxRedhat+PgSQL in our server. We > can ping the server's IP. But we cannot connect our > database through PGAdmin or our application. We have > already set the port to the default. > > 1. What seems to be the problem? > 2. How can I read the server's activities?(reading the > log) > > > __________________________________________________ > Do you Yahoo!? > HotJobs - Search new jobs daily now > http://hotjobs.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
On 4 Nov 2002 at 17:26, ferdinan firmansyah wrote: > We have installed LinuxRedhat+PgSQL in our server. We > can ping the server's IP. But we cannot connect our > database through PGAdmin or our application. We have > already set the port to the default. > > 1. What seems to be the problem? > 2. How can I read the server's activities?(reading the > log) See if this helps you http://wiki.ael.be/index.php/PostgresQL101 Bye Shridhar -- It [being a Vulcan] means to adopt a philosophy, a way of life which islogical and beneficial. We cannot disregard that philosophy merely forpersonal gain, no matter how important that gain might be. -- Spock, "Journey to Babel", stardate 3842.4
On Mon, 4 Nov 2002, ferdinan firmansyah wrote: > We have installed LinuxRedhat+PgSQL in our server. We > can ping the server's IP. But we cannot connect our > database through PGAdmin or our application. We have > already set the port to the default. > > 1. What seems to be the problem? Find your postgresql.conf file i.e. 'locate postgresql.conf'. Edit it and change this line: tcpip_socket = false to look like this: tcpip_socket = true > 2. How can I read the server's activities?(reading the > log) Not sure. Look in the /var/log directory to see if RedHat sets up postgresql to log there.
ferdinan firmansyah wrote: >We have installed LinuxRedhat+PgSQL in our server. We >can ping the server's IP. But we cannot connect our >database through PGAdmin or our application. We have >already set the port to the default. > >1. What seems to be the problem? > Check to see if you installed RedHat with firewall rules. This might also prevent connections.