Re: Can't connect to PGSQL

From: "Michiel Lange" <michiel(at)minas(dot)demon(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can't connect to PGSQL
Date: 2002-11-06 07:14:35
Message-ID: aqafgl$ol0$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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(at)yahoo(dot)com> schreef in bericht
news:20021105012651(dot)62134(dot)qmail(at)web14006(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message fred 2002-11-06 09:40:52 USERS
Previous Message Michiel Lange 2002-11-06 07:10:46 Re: Linux system panic

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-11-06 08:30:01 Romanian version of the PostgreSQL "Advocacy and Marketing" site is ready
Previous Message Fred 2002-11-06 06:33:46 out parameters ( oracle 2 pg )