Thread: Can I install 2nd set of postgresql into the same server?

I am using rental server with root access. The server was initially set up
with postgresql, but the db is used only for the server maintanance.

I could not get connected to the database.

The db was started with -i option. But still, I can not get it connected.

The portnumber should be 5432 as default.

Q1. How can I check to see if postgresql is using port 5432?

I have put PGPORT=5432 at .bash_profile and exported it to make sure it is
using port number 5432. But still I could not get connected.

Here is the part of the program I use.

php3 file has the following code:

<?
 include("gw.conf");
 include("include/admchk.func");
 $conn = @pg_Connect($host,"5432","","",$masterdb);
 if (!$conn) {
  echo "<B>Can not connect to the database.</B><BR>\n";
  exit;
 }
?>

Each time I run this portion, I get the error of not connected to the db.

Q2. Can anyone help me find out what to look for in order to correct this
problem?

Q3. Can I install another copy of postgresql into the existing server?
Another words, can I stall another copy of postgresql which will not
interrupt to the previous set of postgresql?

Thank you very much for your help in advance.

Abraham Lee
AMS

On Thursday 14 Nov 2002 5:36 am, アムス wrote:
> I am using rental server with root access. The server was initially set up
> with postgresql, but the db is used only for the server maintanance.
>
> I could not get connected to the database.
>
> The db was started with -i option. But still, I can not get it connected.
>
> The portnumber should be 5432 as default.
>
> Q1. How can I check to see if postgresql is using port 5432?

Try the "lsof" command "lsof -i" will list all processes that have any ports
open.

> I have put PGPORT=5432 at .bash_profile and exported it to make sure it is
> using port number 5432. But still I could not get connected.
>
> Here is the part of the program I use.
>
> php3 file has the following code:
>
> <?
>  include("gw.conf");
>  include("include/admchk.func");
>  $conn = @pg_Connect($host,"5432","","",$masterdb);
>  if (!$conn) {
>   echo "<B>Can not connect to the database.</B><BR>\n";
>   exit;
>  }
> ?>
>
> Each time I run this portion, I get the error of not connected to the db.

Try checking the pg_errormessage($conn)

> Q2. Can anyone help me find out what to look for in order to correct this
> problem?

If PG is listening on the port, and there's no firewall interfering then it's
probably the settings in your pg_hba.conf - make sure the host you connect
from (localhost?) is listed as allowing connections. See the manuals for
details.

> Q3. Can I install another copy of postgresql into the existing server?
> Another words, can I stall another copy of postgresql which will not
> interrupt to the previous set of postgresql?

I seem to remember doing this (I use a separate machine for testing now).
Install to a different location, make sure you initdb a different location
and choose a different port for the new PostgreSQL to listen on.

HTH
--
  Richard Huxton

On Thu, 14 Nov 2002, [iso-2022-jp] $B%"%`%9(B wrote:

> I am using rental server with root access. The server was initially set up
> with postgresql, but the db is used only for the server maintanance.
>
> I could not get connected to the database.
>
> The db was started with -i option. But still, I can not get it connected.
>
> The portnumber should be 5432 as default.
>
> Q1. How can I check to see if postgresql is using port 5432?
>
> I have put PGPORT=5432 at .bash_profile and exported it to make sure it is
> using port number 5432. But still I could not get connected.

Nobody's mentioned it yet, but I'm pretty sure all use of environmental
variables EXCEPT for PGDATA have been deprecated.

You need to find the postgresql.conf file your postmaster is using to
startup with (it should be in the $PGDATA directory, as defined by the
.bash_profile in the user account responsible for starting postgresql up)
and there should be a port number entry in there.