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

From: アムス <ams(at)asiams(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Can I install 2nd set of postgresql into the same server?
Date: 2002-11-14 05:36:55
Message-ID: 001601c28b9f$e73275e0$2dc4a4db@LocalHost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-11-14 05:45:21 Re: Upgrade to dual processor machine?
Previous Message Tom Lane 2002-11-14 04:33:36 Re: 1600 Column limit..