Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can't connect to PGSQL

Can't connect to PGSQL

From
ferdinan firmansyah
Date:
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

From
"Shridhar Daithankar"
Date:
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: Can't connect to PGSQL

From
"scott.marlowe"
Date:
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: [ADMIN] Can't connect to PGSQL

From
Thomas Swan
Date:
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.