Обсуждение: Can't connect to PGSQL

Поиск
Список
Период
Сортировка

Can't connect to PGSQL

От
ferdinan firmansyah
Дата:
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/

Re: Can't connect to PGSQL

От
Stephan Szabo
Дата:
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)



About lower and uppercase

От
Sonia Sánchez Díaz
Дата:
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.



Re: About lower and uppercase

От
Stephan Szabo
Дата:
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.



Re: Can't connect to PGSQL

От
"Michiel Lange"
Дата:
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



Re: [GENERAL] Can't connect to PGSQL

От
"Shridhar Daithankar"
Дата:
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


Re: [GENERAL] Can't connect to PGSQL

От
"scott.marlowe"
Дата:
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.


Re: Can't connect to PGSQL

От
Thomas Swan
Дата:
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.